Supp_Merge_Levels.SAS

/* Merge our raw data with our constraint categories to determine which constraints apply to which data points */

proc sql;
	create table
		joined
	as select
		t.*,
		con,
		case when
			(t.county = l.county and l.degree = 'dummy' and t.degree ~= 'ALL')
			or (t.degree = l.degree and l.county = 'dummy' and t.county ~= 'ALL')
		then 1 else 0 end as included
	from
		testset as t
	left join
		levels as l
	on
		1 = 1;
quit;