topic Re: multiple file processing in data step in SAS Programming

multiple file processing in data step

jhhuh — Thu, 14 Mar 2013 08:19:49 GMT

Hi,

I want to change a variable in a data.

But I want to do the same job for multiple files in a directory.

I kind of feel that I can do this efficiently if I use macro, but I do not know exactly becuase I am just a beginner of SAS macro.

The SAS code for one file is..

data test;

set pars.prod11_beer;

COLUPC = 1*UPC

drop UPC;

run;

Any advice or suggetion from you would be greatly appreciated!

Thanks!

Jagadishkatam — Thu, 14 Mar 2013 08:30:41 GMT

Hi ,

Please try the below macro

%macro dir(name=,file=,var=,var2=);

data &name;

set pars..&file;

&var= 1*&var2

drop &var2;

run;

%mend;

%dir(name=test, file=prod11_beer,var=COLUPC,var2=UPC);

Hope this helps

Thanks,

Jagadish

jhhuh — Thu, 14 Mar 2013 09:50:01 GMT

Thanks.

But it did not work well..

I got the error message below.

Do you have any idea why this happened?

Jagadishkatam — Thu, 14 Mar 2013 09:57:06 GMT

Please remove the additional . from pars..&file, there should be a single . like this

pars.&file

Please try and let me know the output.

Thanks,

Jagadish

jhhuh — Thu, 14 Mar 2013 15:30:14 GMT

Thank you so much!

It worked beautifully!

Jin-Hee Huh