resolve macro inside quotes

[lizzy28]

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.

[ballardw · Accepted solution]

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.

[lizzy28]

Thanks a lot, Ballard!