Hi All,
I'm trying to write my 1st SAS Macro (see below).
What I'm trying to achieve is create datasets for each Zone and also create a dataset where the ZoneFilter = 'Eastern Civ' 'Top Civ' 'Locatin2 Civ'. I can get the macro to work for creating a dataset for each Zone other than the 3 combined ones above.
%let OneList='Eastern Civ' 'Top Civ' 'Locatin2 Civ';
%macro zonedata(ZoneFilter_nm=,title=);
proc sql;
create table zonedata_&title. as
SELECT *
from work.tesdata as a
where a.ZoneFilter = &ZoneFilter_nm
;
quit;
%mend zonedata;
%zonedata(ZoneFilter_nm='Mid State',title=Mid_State)
%zonedata(ZoneFilter_nm='Mid Terr',title=Mid_Terr)
%zonedata(ZoneFilter_nm='Eastern Civ',title=Eastern_Civ)
%zonedata(ZoneFilter_nm='North State',title=North_State)
%zonedata(ZoneFilter_nm='Top Oz',title=Top_Oz)
%zonedata(ZoneFilter_nm='Top Terr',title=Top_Terr)
%zonedata(ZoneFilter_nm='Top Civ',title=Top_Civ)
%zonedata(ZoneFilter_nm='Bottom Oz',title=Bottom_Oz)
%zonedata(ZoneFilter_nm='Bottom Terr',title=Bottom_Terr)
%zonedata(ZoneFilter_nm='Bottomern State',title=Bottomern_State)
%zonedata(ZoneFilter_nm='Locatin1',title=Locatin1)
%zonedata(ZoneFilter_nm='Loc',title=Loc)
%zonedata(ZoneFilter_nm='Locatin2 Civ',title=Locatin2_Civ)
%zonedata(ZoneFilter_nm='Locatin2ern Oz',title=Locatin2ern_Oz)
... View more