topic Re: Macro to create new variable based on dataset name in SAS Programming

Macro to create new variable based on dataset name

deleted_user — Fri, 11 Dec 2009 22:00:57 GMT

Have 51 separate county datasets. Want to combine the 51 county datasets and create a variable "county name" based on the name of each dataset. Any suggestions?

Re: Macro to create new variable based on dataset name

Cynthia_sas — Fri, 11 Dec 2009 22:13:54 GMT

Hi:
You could "macro-ize" something like the program example below. It is always best, however to start with a basic non-macro program and understand how it works before you convert it to a macro program.

cynthia
[pre]
data new;
set sashelp.prdsale(in=prdsale)
sashelp.prdsal2(in=prdsal2)
sashelp.prdsal3(in=prdsal3);
if prdsale=1 then filename = 'SASHELP.PRDSALE';
else if prdsal2 = 1 then filename = 'SASHELP.PRDSAL2';
else if prdsal3 = 1 then filename = 'SASHELP.PRDSAL3';
run;

ods listing;
proc freq data=new order=data;
tables filename;
run;
[/pre]

Re: Macro to create new variable based on dataset name

Peter_C — Fri, 11 Dec 2009 22:18:48 GMT

if you have SAS92 use option INDSNAME= {VARname} see http://support.sas.com/kb/34/513.html .

Re: Macro to create new variable based on dataset name

Cynthia_sas — Fri, 11 Dec 2009 22:27:25 GMT

Thanks, Peter! I forget sometimes to point out the newer syntax.
cynthia