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
"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
"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
Thanks, Ballard. I see your point.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.