topic Re: Apply any procedure to all the files in a library in SAS Procedures

Apply any procedure to all the files in a library

sundeep15685 — Tue, 29 Dec 2015 01:56:20 GMT

Hi,

I have around 20 files in a library. I want to apply Proc means to all the files in the library using a macro than writing all 20 file names.

It should take all the file names automatically if I specify the library name.

Thanks

Re: Apply any procedure to all the files in a library

Reeza — Tue, 29 Dec 2015 02:16:33 GMT

You can get all the dataset names in a library from sashelp.vtable and call execute should be straightforward. You also don't necessarily need a macro depending on your needs. Here's a demo - untested.

%let lname=WORK; 

data dnames; 
set sashelp.vtable;
 where libname=upper("&lname"); 
run; 

data _null_; 
set dnames; 
str=cats("proc means data=&lname..", memname, "; run;"); 
call execute(str); 
run;

Re: Apply any procedure to all the files in a library

sundeep15685 — Tue, 29 Dec 2015 03:18:51 GMT

Hi,

Thanks.

The code is working.

I was actually looking to know about missing values in each dataset using proc means, NMISS option.

As cats function is removing the trailing and leading blanks I am unable to give the NMISS option.

Could you please look into it.

data _Null_;
set metfile;
str=cats("proc means data=&library..", memname, "nmiss", "; run;");
call execute(str);
run;

It is generating the statements

proc means data=TASK3.DEMOSSUBMITnmiss; run;
ERROR: File TASK3.DEMOSSUBMITNMISS.DATA does not exist.

where Nmiss is mixing up with the dataset name.

Re: Apply any procedure to all the files in a library

Reeza — Tue, 29 Dec 2015 03:26:09 GMT

Try one of the other CAT functions.
There's CATT, CATX, CAT. Most likely CATT, which only trims trailing spaces so you can add a space before the NMISS.

Re: Apply any procedure to all the files in a library

sundeep15685 — Tue, 29 Dec 2015 03:32:23 GMT

cool. Its Working.

Thanks.