Hi There, I am trying set up the following variable for a daily process %let most_recent_file = data_201907; such that "_201907" is based on the most recent data file available. The file is generated mid month every month, for the prior month's data. Example today is Aug 16 til Sep 15, I will use data_201907. From Sep 16 til Oct 15 I will use data_201908 etc. So I thought the logic should be something along the lines of: take today. Subtract 2 weeks. Then subtract 1 month. I tried the following: %let today = %sysfunc(today(), yymmddn8.); %put &today. ; %let var1 = %sysfunc(intnx(week,%sysfunc(today()),-2,same),yymmddn8.); %put &var1.; %let var2 = %sysfunc(intnx(month,%sysfunc(&var1),-1,same),yymmn6.); %put &var2.; But I'm getting ERROR: Function name missing in %SYSFUNC or %QSYSFUNC macro function reference. Am I missing something really simple?
... View more