topic Date logic in SAS Programming

Date logic

Danglytics — Wed, 01 Feb 2012 18:16:20 GMT

Hi,

I have a statement end date that I need to figure the statement start date, which is exactly the same day but in the month previous.

for example

id bill_end_date bill_st_date

1 12Jan2011 12Dec2010

2 23Feb2011 23Jan2011

etc.

thanks for your help.

Reeza — Wed, 01 Feb 2012 18:22:00 GMT

intnx function with the same option.

Check the docs.

Haikuo — Wed, 01 Feb 2012 18:25:05 GMT

Something like this may get your started:

data have;

infile cards;

format bill_end_date date9.

bill_st_date date9.;

input id bill_end_date : date9.;

bill_st_date=intnx('mon', bill_end_date,-1,'sameday');

cards;

1 12Jan2011

2 23Feb2011

;

proc print;run;

Kindly Regards,

Haikuo

Danglytics — Wed, 01 Feb 2012 18:27:38 GMT

thank you for your help.

what happens to months with 31 days? I assume it goes to month end?

Haikuo — Wed, 01 Feb 2012 18:39:21 GMT

Bingo! It will go to the last day of the month. Try it for yourself, change 12Jan2011 to 31Mar2011, and see what happens.

Regards,

Haikuo