/* Creation of Masterlist for All Months reports for this Group Number;*/------>I Have This Part PROC SQL; CREATE TABLE WORK.FILTER_FOR_REGISTRY_CURRENT AS SELECT a.* FROM MICRO.REGISTRY_CURRENT a WHERE a.GROUP_NUMBER = '0000000'; proc sql; create table work.census_in_microdata as select a.state_code,a.county_code, a.rept_num, b.data_value, b.datatype, b.version, b.ref_mm, b.ref_yy from work.filter_for_registry_current a, micro.microdata_current b where a.state_code=b.state_code and a.rept_num=b.rept_num; /* Creation of Masterlist for All Months reports for this Group Number;*/ quit; /* Creation of List for January Ref MM reports for this Group Number;*/ proc sql; create table January_Census_Output as select state_code, rept_num, data_value, datatype, version, ref_mm, ref_yy from work.census_in_microdata where ref_mm='01' group by state_code, rept_num having version=max(version); quit; /* Creation of List for January Ref MM reports for this Group Number;*/ /* Creation of List for February Ref MM reports for this Group Number;*/ proc sql; create table February_Census_Output as select state_code, rept_num, data_value, datatype, version, ref_mm, ref_yy from work.census_in_microdata where ref_mm='02' group by state_code, rept_num having version=max(version); quit; /* Creation of List for February Ref MM reports for this Group Number;*/ /* Creation of List for March Ref MM reports for this Group Number;*/ proc sql; create table March_Census_Output as select state_code, rept_num, data_value, datatype, version, ref_mm, ref_yy from work.census_in_microdata where ref_mm='03' group by state_code, rept_num having version=max(version); quit; /* Creation of List for March Ref MM reports for this Group Number;*/--------->I Have This Part /* Creation of List for All First Time Reporters for Ref MM=03 reports for this Group Number;*/--------->I Need This Part. proc sql; create table 'WORK.FILTER_FOR_REGISTRY_CURRENT'; select a.* from WORK.FILTER_FOR_REGISTRY_CURRENT a; create table 'Table micro.microdata_current b'; select b.* from micro.microdata_current b; quit;/* Creation of List for All First Time Reporters for Ref MM=03 reports for this Group Number;*/--------->I Need This Part.
... View more
