Supp_Agg_Levels.SAS

/*	We need constraints for every combination of dimensions you can build by leaving out one dimension at a time.
	This is pretty simple in a 2-dimensional dataset. */

proc sql;
	create table
		levels

	/* Constraints across the degree dimension */

	as select distinct
		county,
		'dummy' as degree
	from
		testset

	/* And constraints across the county dimension */

	union all
	select distinct
		'dummy' as county,
		degree
	from
		testset;
quit;

/* Assign numbers to our soon-to-be constraints */

data levels;
	set levels;

	con = _n_;
run;