topic Re: creating a column of months with a do loop in SAS Programming

creating a column of months with a do loop

akosyan — Wed, 25 Sep 2019 13:39:10 GMT

Hi,

Can you please help me with this ask ?

So I have

%let start_month = 1801

%let end_month = 1907

I want to create a datatable containing only one column which will have all the months from start to end. I am assuming I should append a new month values in a do loop.

Thanks,

Re: creating a column of months with a do loop

PeterClemmensen — Wed, 25 Sep 2019 13:41:27 GMT

Hi and welcome to the SAS Community 🙂

Does 1801 represent january in 2018?

Re: creating a column of months with a do loop

akosyan — Wed, 25 Sep 2019 13:42:52 GMT

Thank you 🙂

yes 1801 is January 2018,

Re: creating a column of months with a do loop

PaigeMiller — Wed, 25 Sep 2019 13:46:12 GMT

@akosyan wrote:

Hi,

Can you please help me with this ask ?

So I have

%let start_month = 1801

%let end_month = 1907

I want to create a datatable containing only one column which will have all the months from start to end. I am assuming I should append a new month values in a do loop.

Thanks,

Don't bother with macros.

data want;
    startmonth='01JAN18'd;
    endmonth='01JUL19'd;
    month=startmonth;
    do while(month le endmonth);
        output;
        month=intnx('month',month,1);
    end;
    keep month;
    format month yymm5.;
run;

Re: creating a column of months with a do loop

akosyan — Wed, 25 Sep 2019 13:47:40 GMT

Thanks Paige,

It worked, except for the formatting I needed to put yymmn4.