multiple file processing in data step

[jhhuh]

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 · Accepted solution]

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]

Thanks.

But it did not work well..

I got the error message below.

Do you have any idea why this happened?

[Jagadishkatam]

Hi

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]

Thank you so much!

It worked beautifully!

Jin-Hee Huh