I have written some code, and it works just fine. I am always trying to learn other ways to do the same thing. In this case, instead of relying on PROC SQL and into: for the macro variable I would like to learn another way to accomplish this and possibly lessen the number of lines of code I am writing. Here is what I currently have: CD=CalendarDay, PM=PriorMonth, CM=CurrentMonth DATA DATES;
FORMAT START_DATE_PM DATE9.;
FORMAT CD3PM DATE9.;
FORMAT START_DATE_CM DATE9.;
FORMAT CD2CM DATE9.;
START_DATE_PM = INTNX('MONTH',TODAY(),-1,'B');
CD3PM = INTNX('DAY',START_DATE_PM,2);
START_DATE_CM = INTNX('MONTH',TODAY(),0,'B');
CD2CM = INTNX('DAY',START_DATE_CM,1);
RUN;
PROC SQL NOPRINT;
SELECT CD2CM, CD3PM
INTO: CD2CM,
: CD3PM
FROM DATES;
QUIT;
%PUT &CD2CM;
%PUT &CD3PM;
... View more
