Hello Everyone, I have a following code which need to be run according to weekday; the difference is in the WHERE clause of the codes: if weekday(today()) NE 2 then: PROC SQL; create table work.Amount as SELECT A,B,C FROM Amount_Month WHERE DATE_AMT = today()-1; QUIT; if weekday(today()) EQ 2 then: PROC SQL; create table work.Amount as SELECT A,B,C FROM Amount_Month WHERE DATE_AMT >= today()-3; QUIT; How can make this code run, as I tried using it inside data _null_ but I'm getting an error, please help. Thanks in advance. ... View more

Hello Everyone, I have a following code snippet, in which we keep adding an ELSE-IF statement whenever a new month starts. For example: once the month of June will start, a new ELSE-IF condition will be added as follows: ELSE IF &YYYYMMDD=20150531 THEN FILEDD=20150601; where: YYYYMMDD will be the previous month's end date & FILEDD is the new month (here June) start date. I want to automate it & avoid adding the ELSE IF statement manually every month. Any suggestions are welcome. Thanks in advance data _null_; call symputx('tt1',put(intnx('day',today(),-2),yymmddn8.),G); run; %macro DAILY_(YYYYMMDD); data ORCL.BASE1&YYYYMMDD; set MY_DIR.Daily_&YYYYMMDD.; IF &YYYYMMDD='20141231'd THEN FILEDD='20150101'd; else IF &YYYYMMDD='20150131'd THEN FILEDD='20150201'd; else IF &YYYYMMDD='20150228'd THEN FILEDD='20150301'd; else IF &YYYYMMDD='20150331'd THEN FILEDD='20150401'd; else IF &YYYYMMDD='20150430'd THEN FILEDD='20150501'd; ELSE FILEDD=FILEDD; %mend; %DAILY_(&tt1); ... View more