Help using Base SAS procedures

macro variables

Accepted Solution Solved
Reply
Super Contributor
Super Contributor
Posts: 444
Accepted Solution

macro variables

Hi,

I am trying to get the last day of the current month and 1st day of October and having a problem with "end_dt" :

 

ERROR: Expected close parenthesis after macro function invocation not found.

 

 

%let st_dt = %sysfunc(intnx(month,&today,-3));

%let end_dt = %sysfunc(intnx(month,&today,1)-1);

%put st_dt is &st_dt;

%put end_dt is &end_dt;

 

Anyone  please?


Accepted Solutions
Solution
‎01-05-2017 12:00 PM
Super User
Posts: 5,518

Re: macro variables

The problem lies with yoIur END_DT computations.  %SYSFUNC should be applied to INTNX, but cannot be applied to the math that attempts to subtract one:

 

%let end_dt = %sysfunc(intnx(month,&today,1)-1);

Instead, try:

 

%let end_dt = %eval(%sysfunc(intnx(month,&today,1))-1);

View solution in original post


All Replies
Solution
‎01-05-2017 12:00 PM
Super User
Posts: 5,518

Re: macro variables

The problem lies with yoIur END_DT computations.  %SYSFUNC should be applied to INTNX, but cannot be applied to the math that attempts to subtract one:

 

%let end_dt = %sysfunc(intnx(month,&today,1)-1);

Instead, try:

 

%let end_dt = %eval(%sysfunc(intnx(month,&today,1))-1);

Super Contributor
Super Contributor
Posts: 444

Re: macro variables

Posted in reply to Astounding

i knew  it had something to do with it but just did not know  how to approach that problem. thanks Astounding!!

Trusted Advisor
Posts: 1,586

Re: macro variables

Function INTNX acceps alse an alignment argument:

 

%let st_dt = %sysfunc(intnx(month,&today,-3,B)); /* B = beginning, i.e day 01 */

%let end_dt = %sysfunc(intnx(month,&today,1,E)); /* E = Ending - i.e. last day of the month */

%put st_dt is &st_dt;

%put end_dt is &end_dt;

Super Contributor
Super Contributor
Posts: 444

Re: macro variables

right!

i could have  used 

%let end_dt1 = %sysfunc(intnx(month,&today,0,E));

 

thanks Shmuel

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 343 views
  • 4 likes
  • 3 in conversation