topic Re: need to get last 4 calendar dates from the date indicated in SAS Programming

need to get last 4 calendar dates from the date indicated

kajal_30 — Tue, 07 Jun 2022 13:58:18 GMT

Hi Team,

I have a date as input and I need to get last 6 dates in a continues manner for the same gap between dates.

for eg I have a date %let yearmt = 202201 so I need dates as 202110 ,202107,202104,202101,202010,202007 . How can I calculate it using a macro?

Regards

Kajal

Re: need to get last 4 calendar dates from the date indicated

PaigeMiller — Tue, 07 Jun 2022 14:02:44 GMT

Use built-in SAS functions to compute months (and all calendar arithmetic)

%let yearmt=202201;
%let yearmtn=%sysfunc(inputn(&yearmt,yymmn6.));

%macro dothis;
    %do i=1 %to 6;
        %let thismonth=%sysfunc(intnx(month,&yearmtn,%eval(&i*-3),b));
        %put %sysfunc(putn(&thismonth,yymmn6.));
    %end;
%mend;
%dothis

Re: need to get last 4 calendar dates from the date indicated

ballardw — Tue, 07 Jun 2022 14:03:41 GMT

Why does the subject line for your post say "4 calendar dates" and the body of the question "last 6 dates"?

Given any "date" what is the rule for determining what the dates would be? I can guess but really would prefer not to rely on guesses when programming.

Do all of the values go into one macro variable? 4 macro variables? 6 macro variables? Data step variable(s)? In other words, what is the result to look like.

Note: Macro variables are text. So 202201 is not a "date" but 6 characters.

Re: need to get last 4 calendar dates from the date indicated

kajal_30 — Mon, 13 Jun 2022 12:13:43 GMT

thank you @PaigeMiller