%let DorsHHFPath =/dorsshare/HHFit;
%put &DorsHHFPath;
%Let StateList=ga il in ky md mi;
%macro fetchstate(Statelist= ,
Currdate= );
%Let cnt=1;
%Let Thisstate=%scan(&StateList, &cnt, %Str( ) );
%Do %While (&Thisstate NE );
proc import out= &Thisstate
datafile="&DorsHHFPath/&Thisstate./&Thisstate._HHF_STM_ToState_&CURRDATE_KEY._01.csv"
dbms=CSV replace ;
getnames=no;
datarow=3;
run;
/*** Advance counter and select next state ***/
%Let cnt=%eval(&cnt + 1);
%Let Thisstate=%scan(&StateList, &cnt, %Str( ) );
%End;
%Mend;
%fetchstate(StateList=&StateList,
Currdate=&Currdate);
&CURRDATE_KEY represents todays date. This macro script creates a work file if the date extention is todays date. If not the script generates an error. Is there a way to avoid the error with some type of else statement that says 'no file' ??
Check SAS 9.4 macro appendix for a macro that shows how this can be executed, where empty data set gets an empty record. There example is for export but I think you’ll get the idea.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.