topic Re: resolve macro inside quotes in SAS Programming

resolve macro inside quotes

lizzy28 — Wed, 28 Jan 2015 20:38:29 GMT

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.

Re: resolve macro inside quotes

ballardw — Wed, 28 Jan 2015 22:00:08 GMT

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.

Re: resolve macro inside quotes

lizzy28 — Wed, 28 Jan 2015 23:13:09 GMT

Thanks a lot, Ballard!