topic Re: SAS macro vars-Today,yesterday,same day in the prior month from yesterday in SAS Programming

SAS macro vars-Today,yesterday,same day in the prior month from yesterday

Ronein — Tue, 10 Jul 2018 09:07:40 GMT

Hello

I want to create 3 sas macro varaibles :Today,yesterday,same day in the prior month from yesterday.

data _null_;
call symputx('Today', PUT(intnx('DAY',today(),0), date9.));
* Today;
call symputx('d_yesterday', put(today()-1, date9.));
* yesterday;
call symputx('beta', PUT(intnx('MONTH',today()-1,-1,'s'), date9.));
*last month same day of yesterday;
RUN;
%put &Today.;/*10JUL2018*/
%put &d_yesterday.;/*09JUL2018*/
%put &beta.;/*09JUN2018*/

When I did it in another way I received an error.

May someone tell me please why is the error?

%let d_today=%sysfunc(today());
%put &d_today.;
data _null_;
call symputx('d_yesterday', PUT(intnx('DAY',&d_today.,-1), date9.));
* yesterday;
call symputx('beta', PUT(intnx('DAY',%SYSFUNC(&d_today.),-1), date9.));
*last month same day of yesterday;
RUN;
%put &d_yesterday.;
%put &beta.;

Re: SAS macro vars-Today,yesterday,same day in the prior month from yesterday

MadhuKorni — Tue, 10 Jul 2018 10:27:28 GMT

1.Remove %sysfunc in your datastep code.

2.intnx is not required in your code.

Remove %sysfunc and intnx functions in the belowline of code

call symputx('beta', PUT(intnx('DAY',%SYSFUNC(&d_today.),-1), date9.));

call symputx('beta', PUT(intnx('DAY',&d_today.,-1), date9.));

call symputx('beta', PUT(&d_today.-1, date9.));

Above two lines of code gives the same result.

Re: SAS macro vars-Today,yesterday,same day in the prior month from yesterday

Tom — Tue, 10 Jul 2018 13:26:16 GMT

Macro processing is just simple text replacement. Look at what you posted.

@Ronein wrote:

When I did it in another way I received an error.

May someone tell me please why is the error?

%let d_today=%sysfunc(today());
%put &d_today.;
data _null_;
call symputx('beta', PUT(intnx('DAY',%SYSFUNC(&d_today.),-1), date9.));
RUN;

So you set the macro variable D_TODAY to some 5 digit integer string representing the number of days since 1960. For today that is the string 21375.

You then used it to as the name of the SAS function for %SYSFUNC() macro function to call. There is no function named 21375. And anyway you left off the required () after the function name.

Re: SAS macro vars-Today,yesterday,same day in the prior month from yesterday

PaigeMiller — Tue, 10 Jul 2018 13:35:20 GMT

@Ronein wrote:

Hello

I want to create 3 sas macro varaibles :Today,yesterday,same day in the prior month from yesterday.

data _null_;
call symputx('Today', PUT(intnx('DAY',today(),0), date9.));
* Today;
call symputx('d_yesterday', put(today()-1, date9.));
* yesterday;
call symputx('beta', PUT(intnx('MONTH',today()-1,-1,'s'), date9.));
*last month same day of yesterday;
RUN;
%put &Today.;/*10JUL2018*/
%put &d_yesterday.;/*09JUL2018*/
%put &beta.;/*09JUN2018*/

When I did it in another way I received an error.

May someone tell me please why is the error?

%let d_today=%sysfunc(today());
%put &d_today.;
data _null_;
call symputx('d_yesterday', PUT(intnx('DAY',&d_today.,-1), date9.));
* yesterday;
call symputx('beta', PUT(intnx('DAY',%SYSFUNC(&d_today.),-1), date9.));
*last month same day of yesterday;
RUN;
%put &d_yesterday.;
%put &beta.;

From now on, could you please post your code in the proper format, by clicking on the running man icon, then pasting your code into the window that opens? Thanks.