topic Re: Creating dataset with ultimo month dates in SAS Programming

Creating dataset with ultimo month dates

Gaffron — Tue, 01 Mar 2016 12:47:44 GMT

I need a program that forms at the end of month dates between two dates.

Somthing like:

data date;

format date ddmmyy10.;

do date='01jan2010'd to '31dec2016'd by 1;

output;

end;

run;

But unly with one date for each month.

data months;

format date ddmmyy10.;

do date=intnx('month', '31dec2010'd, n)-1 to '31dec2016'd by n;

output;

end;

run;

But how to I count n up with 1 to 31dec2016?

Best regards

Terkel

LinusH — Tue, 01 Mar 2016 12:54:22 GMT

Do a regular do loop with a plain increment variable. Here you specify how many months you wish to generate.

Use that in your assignment statement as an argument in the intnx() function.

Ksharp — Wed, 02 Mar 2016 03:11:07 GMT

data date;
format date ddmmyy10.;
do date='01jan2010'd to '31dec2016'd by 1;
 if day(date+1)=1 then output;
end;
run;