Else statement in proc import macro

Q1983 — Wed, 31 Jan 2018 19:02:15 GMT

%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' ??

Re: Else statement in proc import macro

Kurt_Bremser — Wed, 31 Jan 2018 19:16:44 GMT

Use the fexist() function.

Re: Else statement in proc import macro

Reeza — Wed, 31 Jan 2018 20:45:07 GMT

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.

topic Re: Else statement in proc import macro in SAS Programming

Else statement in proc import macro

Re: Else statement in proc import macro

Re: Else statement in proc import macro