topic Re: Resolving intx in SAS Programming

Resolving intx

librasonali — Thu, 03 Feb 2022 12:46:17 GMT

hi ,

below is the small snippet :

%let year_month=202201;
data try;
temp=&year_month.-1;
run;

I want my temp to be 202112 not 202200 . Can you please help me in give a quick solution.

Thanks in advance !

Re: Resolving intx

PeterClemmensen — Thu, 03 Feb 2022 12:54:45 GMT

Do you want it in a macro variable or a Data Step variable?

Re: Resolving intx

Ksharp — Thu, 03 Feb 2022 13:13:51 GMT

You want it be a DATE type variable or just simple NUMERIC type variable ?

%let year_month=202201;
data try;
temp=intnx('month',input("&year_month.01",yymmdd10.),-1);
format temp yymmn6.;
run;

Re: Resolving intx

maguiremq — Thu, 03 Feb 2022 13:27:06 GMT

I don't know if this is the best solution, but here's what I have.

%let yearmonth = %sysfunc(intnx(month, %sysfunc(inputn(202201, yymmn6.)),-1,e));
%put &yearmonth.;

82   %put &yearmonth.;
22645

Re: Resolving intx

Tom — Thu, 03 Feb 2022 15:07:05 GMT

@maguiremq wrote:

I don't know if this is the best solution, but here's what I have.
%let yearmonth = %sysfunc(intnx(month, %sysfunc(inputn(202201, yymmn6.)),-1,e));
%put &yearmonth.;
82   %put &yearmonth.;
22645

Close. If you want to generate the digit string in YYYYMM style then tell %SYSFUNC() to apply the YYMMN format to the value.

1725   %let yearmonth = %sysfunc(intnx(month, %sysfunc(inputn(202201, yymmn6.)),-1,e),yymmn6.);
1726   %put &=yearmonth;
YEARMONTH=202112

Re: Resolving intx

maguiremq — Thu, 03 Feb 2022 15:09:27 GMT

Always there with the better insight! Thanks, Tom!