topic Re: Use macro to convert multiple STATA files to SAS files in SAS Programming

Use macro to convert multiple STATA files to SAS files

lizzy28 — Tue, 10 Feb 2015 15:14:36 GMT

Hi all,

I've asked a similar question previously at . But the answer does not seem to address my current case.

I have 10 STATA files which I need to convert to SAS files. Their files names are like "us_ny_YEAR_core.dta"; here, "YEAR" stands for each specific year from 2001 to 2010. As I tried to do the following macro to convert the files, it does not work.

%macro convert_data();

%do i=2001 %to 2010;

proc import out=ny&i datafile="C:\data\us_ny_&i_core.dta";run;

%end;

%mend;

%convert_data();

run;

Anyone has any suggestion? Thanks so much!

Lizi

Re: Use macro to convert multiple STATA files to SAS files

ballardw — Tue, 10 Feb 2015 16:00:25 GMT

"C:\data\us_ny_&i_core.dta"

should be

"C:\data\us_ny_&i._core.dta"

the . after the macro variable says to append the following text. As written it is looking for a macro variable named I_core

Re: Use macro to convert multiple STATA files to SAS files

lizzy28 — Tue, 10 Feb 2015 16:14:07 GMT

Thanks, Ballard. I see your point.