topic Macro that goes through all dataset in SAS Programming

Macro that goes through all dataset

Brian_Chee — Thu, 02 Apr 2015 00:36:46 GMT

Hello,

I am new to SAS and I was given this macro,

%mend create_libraries;

%create_libraries;

%macro Dt_extract(directory);

proc sql noprint;

select count(*)

into:n_names

from &directory..flname_ann;

quit;

%do z=1 %to &n_names;

data _null_;

a bunch of code

%end;

%mend Dt_extract;

%Dt_extract(temp);

There is data set name flname_ann. Within it is a list of all the names of SAS dataset that I want to go through. So this macro essentially goes through all the dataset, do some modification and towards the end I add in a proc append and end up with a new table with all the modified dataset combined.

Now, within the same folder where I save the flname_ann file, there is another similar dataset with another list of files that I wish to go through. Can someone please explain to me how can I call up the same macro to read this other file, named flname_non?

Thank you very much in advance.

Re: Macro that goes through all dataset

jwillis — Thu, 02 Apr 2015 16:22:29 GMT

This is untested but it should work.

%macro Dt_extract(directory=,file=);

proc sql noprint;

select count(*)

into:n_names

from &directory..&file.;

quit;

%do z=1 %to &n_names;

data _null_;

a bunch of code

%end;

%mend Dt_extract;

%Dt_extract(directory=temp,file=flname_ann);

%Dt_extract(directory=temp,file=flname_non);

Re: Macro that goes through all dataset

Brian_Chee — Thu, 02 Apr 2015 17:18:01 GMT

It works perfectly! Thank you very much.