topic Re: 6 months back in SAS Programming

6 months back

Tal — Sat, 01 Jun 2024 16:28:31 GMT

%let YTD_START = %sysfunc(intnx(year.11, &LASTFRI, 0),yymmdd10.);

this above gives me YTD_START='2023-11-01' beginning of fiscal year but when i am trying to get the date 6 months prior to fiscal year (below)

%let back_6months= %sysfunc(intnx(month,&YTD_START,-6),yymmdd10.);

i am getting back_6months=1965-01-01. What do i have wrong here?

Re: 6 months back

PaigeMiller — Sat, 01 Jun 2024 16:53:04 GMT

Remove the format from the %let YTD_START = statement.

%let YTD_START = %sysfunc(intnx(year.11, &LASTFRI, 0));

Why? Because to do arithmetic or logical operations on macro variables whose values are dates or time or date/times, the value in the macro variable must be unformatted. See Maxim 28.

Re: 6 months back

Tal — Sat, 01 Jun 2024 17:20:31 GMT

Thank you !!