My syntax is word for word what is used for the solution however my output data doesn't separate the "Park" and Monument" rows. Both tables have Park and Monument. Please help. data parks monuments; set"&path/np_summary"; where type in ('NM', 'NP'); Campers=sum (OtherCamping, TentCampers, RVCampers, BackcountryCampers); format Campers comma17.; length ParkType $ 8; if type='NP' then do; ParkType='Park'; output=parks; end; else do; Parktype='Monument'; output=monuments; end; keep Reg ParkName DayVisits OtherLodging Campers ParkType; run;
... View more