topic Re: Generating Days of the Month in a Dataset Given Year and Month in SAS Programming

Generating Days of the Month in a Dataset Given Year and Month

BCNAV — Fri, 10 Jul 2020 13:04:16 GMT

Suppose I have two global macro variables called year and month that a user can change as need (or automatically set). I would like SAS to automatically create a dataset that has one variable called date and it will populate all the days on the month. So if year was set to 2020 and month was set to 5, then the dataset would be automatically created with all the days for May (31 of them) as YYMMDDS8. Is this possible?

Thanks!

Re: Generating Days of the Month in a Dataset Given Year and Month

PeterClemmensen — Fri, 10 Jul 2020 13:15:25 GMT

Like this?

%let year = 2020;
%let month = 5;

data want;
    do dt = mdy(&month, 1, &year) by 1 while (month(dt)=&month);
       output;
    end;
    format dt yymmdds8.;
run;

Re: Generating Days of the Month in a Dataset Given Year and Month

BCNAV — Fri, 10 Jul 2020 13:25:17 GMT

nice! You original worked as well (I modified it to my needs...posted below for others). Thanks for both!

%let year = 2020;
%let month = 2;

data egtask.DATE_LIST;
   do DATE = intnx('month', mdy(&month, 1, &year), 0, 'b') to 
      intnx('month', mdy(&month, 1, &year), 0, 'e');
         output;
   end;
   format DATE yymmdds8.;
run;

Re: Generating Days of the Month in a Dataset Given Year and Month

PeterClemmensen — Fri, 10 Jul 2020 13:53:45 GMT

Anytime 🙂 Glad to help