Hi, greetings, If you experts could help me with this coding, I would really appreciate it. I have seven different datasets, whose names are USA, GBR, JPN, Ind_73, Ind_36, Ind_28, and Ind_60. (First three are countries, last four are industries). By using SAS Macro, I am trying to split each dataset into 18 sub-datasets (say, annually, from 2000~2017). So, I tried to put the names of the seven datasets into var1=, var2, ... var7, and using double do-loop (by year within by dataset) I tried to achieve this and export them into EXCEL. My codes run as follows: %put _global_; %LET var1=USA; %LET var2=JPN; %LET var3=GBR; %LET var4=Ind_73; %LET var5=Ind_36; %LET var6=Ind_28; %LET var7=Ind_60; %MACRO Divide_year; %DO i=1 %TO 7; %DO j=2000 %TO 2017; DATA &var&i&j; SET &var&i; IF Annc_fyear=&j; KEEP Source Target FIC SIC_2D; run; PROC EXPORT data=&var&i&j dbms=xlsx outfile="C:\Users\kchoi9\Desktop\Network and Finance\Data\Three_countries_four_industries\&var&i&j.xlsx" replace; RUN; %END; %END; %MEND Divide_year; %Divide_year; But I get a whole bunch of errors, first and foremost like the following: ERROR: File WORK.VAR1.DATA does not exist. How should I solve this? Please help. KS -,
... View more