topic Assigning value to macro variable based on weekday to process data in SAS Programming

Assigning value to macro variable based on weekday to process data

CHAN07 — Tue, 25 Jul 2017 18:24:37 GMT

Hello

I want to specify folder date in the program. I receive the data on Weekdays at night and run the program early next morning. So, the folder date is always like this:

Processing data on Tue -------------- Date of Mon

Processing data on Wed -------------- Date of Tue

Processing data on Thur -------------- Date of Wed

Processing data on Fri -------------- Date of Thu

Processing data on Mon -------------- Date of Fri(Last) /*Facing problem in this one*/

I have written macro variable where it reads in the previous data dates.

%LET FOLDER_NAME = %SYSFUNC(INTNX(WEEKDAY, %SYSFUNC(TODAY()),-1,E),YYMMDDN8.);

So, If I process the data on 20170725, the folder date would be 20170724. But how should I include logic in this one for processing data on Monday. So, if the data is processed on monday of any given week, it should take in the date of last friday.

Thanks

Chandan Mishra

Re: Assigning value to macro variable based on weekday to process data

Reeza — Tue, 25 Jul 2017 19:05:15 GMT

Did you check the output? Using INTNX with the WEEKDAY should accomplish this, is it not? If so, post an example of how it isn't working.

Re: Assigning value to macro variable based on weekday to process data

CHAN07 — Wed, 26 Jul 2017 15:28:33 GMT

So, If I used this code for Monday 24th July, 2017, it is giving me value of 20170723. Rather I want the value to be 20170721 i.e. Friday.

Thanks

Chandan Mishra

Re: Assigning value to macro variable based on weekday to process data

Reeza — Wed, 26 Jul 2017 15:39:59 GMT

The alignment parameter is messing up your calculation.

Remove it.

 
 1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 59         
 60         %let testdate = '24Jul2017'd;
 61         %LET FOLDER_NAME = %SYSFUNC(INTNX(WEEKDAY, &testdate,-1),YYMMDDN8.);
 62         %put &folder_name.;
 20170721
 63         
 64         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 76

Re: Assigning value to macro variable based on weekday to process data

CHAN07 — Mon, 31 Jul 2017 21:33:02 GMT

Thank you so much for providing the solution.

Thanks

Chandan Mishra