%let 2 months before

Ronein — Wed, 21 Oct 2020 03:58:53 GMT

Hello

User define macro parameter with %let in format of YYMM.

I know how to create a new macro parameter that is sas date(numeric number that represent number of days since 1.1.1960)

My question:

I want to create a SAS date (number of days since 1.1.1960) of 2 months before &start.

However it is not working and I receive an error and also the value that I get is null.

WARNING: Argument 1 to function INPUTN referenced by the %SYSFUNC or %QSYSFUNC macro function is out of range.

%let start=1909;/*YYMM*/
%put &start;
%let date_start=%sysfunc(inputn(&start,yymmn4.));
%put &date_start;

%let t=%sysfunc(inputn(intnx('month',&start,-2),yymmn4.));
%put &t;

Re: %let 2 months before

Reeza — Wed, 21 Oct 2020 04:10:19 GMT

1. %SYSFUNC() is needed on every function (INPUTN and INTNX)

2. But, %SYSFUNC() also has a second parameter that acts as the format so you don't need the INPUTN actually.

3. You were referencing start instead of date_start in the third calculation, but I think you really wanted the date_start macro variable that's a SAS date instead.

Or nest all together of course.

%let start=1909;/*YYMM*/
%put &start;

%let date_start=%sysfunc(inputn(&start,yymmn4.));
%put &date_start;

%let t=%sysfunc(intnx(month, &date_start, -2, s), yymmn4.);
%put &t;

@Ronein wrote:

Hello

User define macro parameter with %let in format of YYMM.

I know how to create a new macro parameter that is sas date(numeric number that represent number of days since 1.1.1960)

My question:

I want to create a SAS date (number of days since 1.1.1960) of 2 months before &start.

However it is not working and I receive an error and also the value that I get is null.

WARNING: Argument 1 to function INPUTN referenced by the %SYSFUNC or %QSYSFUNC macro function is out of range.
%let start=1909;/*YYMM*/
%put &start;
%let date_start=%sysfunc(inputn(&start,yymmn4.));
%put &date_start;

%let t=%sysfunc(inputn(intnx('month',&start,-2),yymmn4.));
%put &t;

topic Re: %let 2 months before in SAS Programming

%let 2 months before

Re: %let 2 months before