creating a column of months with a do loop

[akosyan]

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,

[PeterClemmensen]

Hi and welcome to the SAS Community 🙂

Does 1801 represent january in 2018?

[akosyan]

Thank you 🙂

yes 1801 is January 2018,

[PaigeMiller]

---

@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;

[akosyan]

Thanks Paige,

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