topic end of month date in SAS Programming

end of month date

Danglytics — Wed, 07 Mar 2012 17:25:43 GMT

Hi,

I'm not sure how to classify an ID to the month end date when I have a date variable for them.

for example i'd like my data set to look like: where i have ID and Date and need to create FILE PERIOD

ID Date FILE_PERIOD

1 01Jan2012 31Jan2012

2 05Feb2012 29Feb2012

etc..

thank you for your help.

Haikuo — Wed, 07 Mar 2012 17:48:43 GMT

Try this one:

data have;

input id $ date :date9.;

format date date9.;

cards;

1 01Jan2012

2 05Feb2012

;

data want;

set have;

FILE_PERIOD=intnx('month',date,0,'e');

format FILE_PERIOD date9.;

run;

Regards,

Haikuo

Danglytics — Wed, 07 Mar 2012 18:12:02 GMT

Great thank you that worked.

Is there a way to get FILE_PERIOD into a character format with the following format structure?

for example the code above will give me 31Jan2012, but i'd like FILE_PERIOD to be 2012Jan31 so that it is consistent with my other formats.

Haikuo — Wed, 07 Mar 2012 18:20:38 GMT

Then try this:

data want ;

set have;

_n_=intnx('month',date,0,'e');

FILE_PERIOD=cats(put(_n_, yymon7.),day(_n_));

run;

Haikuo

Edit: just updated.

Danglytics — Wed, 07 Mar 2012 18:35:09 GMT

Thank you very much.