39 %macro select; 40 %*--This macro will be invoked when reading the headers data. It should assign a value 41 of 1 to _keep to indicate that the record/observation is to be processed. 1 means 42 read the data, 0 means do not.--; 43 _keep=1; 44 if SumLev in 44 ! ('070','155','172','270','271','272','273','275','276','274','277','278','291','292','258','293','294','257', 45 '259','382','383','384','387','388','440','450') then _keep=0; *<======levels to skip==================; 46 %mend select; ... 56 data 57 sf32000.usgeos (sortedby=LogRecNo label='2000 Summary File 3 (SF3) Geo Headers data for National File' 58 keep=geocode--AreaSQMI PCT) 59 sf32000.usregdiv(sortedby=LogRecNo label='Summaries for US, Regions and Divisions (SumLev 010, 020 and 030)' 59 ! compress=no) 60 sf32000.usgeocomps(sortedby=LogrecNo label='Geographic Component summaries - all applicable sumlevs') 61 sf32000.usstcnty(sortedby=LogRecNo label='State and County summaries (SumLev 040 and 050)') 62 sf32000.usplaces(sortedby=LogRecNo label='Place level summaries (SumLev 160)' ) 63 sf32000.usmcds(sortedby=LogRecNo label='MCD level summaries (SumLev 060)' ) 64 sf32000.uszips(sortedby=LogRecNo label='5-digit ZIP/ZCTA summaries (SumLev 860)') 65 sf32000.usuas(sortedby=LogRecNo label='Urban Areas (Urbanized Areas & Urban Clusters)') 66 sf32000.usother(sortedby=LogRecNo label='Other misc levels incl MSA, NECMA, CD106, ZIP3, UA parts, etc.'); 67 ... 21876 if geocomp ne '00' then do; 21877 *--geographic components kept only for state level and above. county, mcd components dropped.-; 21878 if sumlev le '040' then output sf32000.usgeocomps; 21879 return; 21880 end; 21881 select(SumLev); 21882 when('010','020','030') output sf32000.usregdiv; 21883 when('040','050') output sf32000.usstcnty; 21884 when('060') output sf32000.usmcds; 21885 when('160') output sf32000.usplaces; 21886 when('860') output sf32000.uszips; 21887 when('400','410') output sf32000.usuas; 21888 otherwise do; 21889 _nother+1; *--to keep this dataset from getting too large--------; 21890 if _nother <= 20000 then output sf32000.usother; 21891 else if mod(_nother,1000)=1 then put SumLev= _nother= ' (other summary levels being deleted***)'; 21892 end; 21893 end; ... NOTE: 487093 records were read from the infile GEOS. The minimum record length was 400. The maximum record length was 400. NOTE: 487093 records were read from the infile IN1. The minimum record length was 520. The maximum record length was 2081. ... NOTE: 487093 records were read from the infile IN8. The minimum record length was 512. The maximum record length was 2196. ... NOTE: 487093 records were read from the infile IN68. The minimum record length was 450. The maximum record length was 2104. NOTE: The data set SF32000.USGEOS has 277186 observations and 74 variables. NOTE: Compressing data set SF32000.USGEOS decreased size by 64.51 percent. Compressed is 1640 pages; un-compressed would require 4621 pages. NOTE: The data set SF32000.USREGDIV has 14 observations and 16594 variables. NOTE: The data set SF32000.USGEOCOMPS has 6141 observations and 16594 variables. NOTE: Compressing data set SF32000.USGEOCOMPS decreased size by 26.87 percent. Compressed is 4509 pages; un-compressed would require 6166 pages. NOTE: The data set SF32000.USSTCNTY has 3271 observations and 16594 variables. NOTE: Compressing data set SF32000.USSTCNTY decreased size by 5.76 percent. Compressed is 3106 pages; un-compressed would require 3296 pages. NOTE: The data set SF32000.USPLACES has 25375 observations and 16594 variables. NOTE: Compressing data set SF32000.USPLACES decreased size by 51.85 percent. Compressed is 12231 pages; un-compressed would require 25400 pages. NOTE: The data set SF32000.USMCDS has 36351 observations and 16594 variables. NOTE: Compressing data set SF32000.USMCDS decreased size by 55.01 percent. Compressed is 16367 pages; un-compressed would require 36376 pages. NOTE: The data set SF32000.USZIPS has 33178 observations and 16594 variables. NOTE: Compressing data set SF32000.USZIPS decreased size by 45.59 percent. Compressed is 18066 pages; un-compressed would require 33203 pages. NOTE: The data set SF32000.USUAS has 7406 observations and 16594 variables. NOTE: Compressing data set SF32000.USUAS decreased size by 27.87 percent. Compressed is 5360 pages; un-compressed would require 7431 pages. NOTE: The data set SF32000.USOTHER has 17886 observations and 16594 variables. NOTE: Compressing data set SF32000.USOTHER decreased size by 41.00 percent. Compressed is 10567 pages; un-compressed would require 17911 pages. NOTE: DATA statement used: real time 2:07:49.88 cpu time 2:03:08.46