Hi all,
I want to import over 10 Excel files into SAS, and they have the same file name other than their serial number, like data1, data2, data3, ... data15. How can I use macro to import them to SAS?
%macro imp_data();
%do i=1%to 15;
proc import out=data&i datafile = "C:\data\data&i.xls";
run;
%end;
%mend;
%imp_data();
run;
Thanks a lot.
To provide a little as to why 2 dots. The Windows naming convention of file.ext uses a . to separate the name and the extension.
The SAS macro language uses the . after a macro variable to combine text. So if file= ABC then &file.ext yields ABCext from the macro processor. The second . is part of the text you want appended so you need to add one.
To provide a little as to why 2 dots. The Windows naming convention of file.ext uses a . to separate the name and the extension.
The SAS macro language uses the . after a macro variable to combine text. So if file= ABC then &file.ext yields ABCext from the macro processor. The second . is part of the text you want appended so you need to add one.
Thanks a lot, Ballard!
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: