Hi all, I writing a code to import several .dta files available in a same folder named INDyyyy, with yyyy corresponding to the year. However I am running into problems because SAS does not recognize the PROC IMPORT command inside a macro. I can successfully import each of them individually using the following code: PROC IMPORT DATAFILE = "X:\Rawdata\IND1998.dta"
OUT = WORK.IND1998
DMS=STATA replace;
RUN; The natural step forward is to write a macro and loop over the years: %Macro prep;
%do i=1998 %to 2015
PROC IMPORT DATAFILE = "X:\Rawdata\IND&i.dta"
OUT = WORK.IND&i
DBMS=STATA replace;
RUN;
%end
%mend;
%prep; The problem is that the PROC IMPORT command is not recognized inside of the macro. As you can seen in the screenshot below it is written in black, but when outside it is totally fine. I don't understand why this is happening as it seems something similar has been used by several users before, see for example this post. I also know that the problem is not related to the %do loop because I have removed it from the code and nothing changes. Any idea as to why this is happening? Would you have any other suggestions as far as procedures to import such files? Thanks in advance for the help
... View more