topic Re: Reg:Dates in SAS Procedures

Reg:Dates

R_Win — Mon, 13 Apr 2009 11:48:58 GMT

Hi
i have a date1 variable in this the observations was 05/01/07 and now i want to create another variable date2 and the observations shd be 05/02/07 up to end of that year as i have tried to add days to the first observation but the days diff from one month to anoher.

Here is the output:

date1 date2 date3 date4 ....... date12
05/01/07 05/02/07 05/03/07 05/04/07 .......................... 05/12/07 Message was edited by: Main

Re: Reg:Dates

sbb — Mon, 13 Apr 2009 13:28:05 GMT

A SAS DATA step to increment your source variable by 1 while assigning a new DATE2 variable. A DO loop within the DATA step will provide logic to both assign the new variable and issue an OUTPUT with each loop iteration.

The SAS support http://support.sas.com/ website has SAS-hosted documentation and supplemental technical topic papers for reference. I used the SEARCH facility at the site and found several references - some pasted below.

Scott Barry
SBBWorks, Inc.

Looking for a Date? A Tutorial on Using SAS® Dates and Times
Arthur L. Carpenter, California Occidental Consultants
http://www2.sas.com/proceedings/sugi30/255-30.pdf

Working with Dates in the SAS System
http://support.sas.com/documentation/cdl/en/basess/58133/HTML/default/a001304321.htm

Re: Reg:Dates

DanielSantos — Mon, 13 Apr 2009 13:30:29 GMT

To increment a date value use the INTNX function.

See: http://support.sas.com/documentation/cdl/en/lrdict/61724/HTML/default/a000212700.htm

Greetings from Portugal.

Daniel Santos at www.cgd.pt

Re: Reg:Dates

sbb — Mon, 13 Apr 2009 13:36:28 GMT

For consideration, using INTNX may be useful if incrementing a DATETIME variable by the date-portion, however having a DATE variable and incrementing sequentially (adding 1 increments to the next date) really does not require using INTNX.

Scott Barry
SBBWorks, Inc.

Re: Reg:Dates

DanielSantos — Mon, 13 Apr 2009 14:26:33 GMT

Scott is right, to add 1 day, you just need to increment the DATE variable by 1.

But, I think Main is having trouble to advance one month (quote: "...but the day diff from one month to anoher"), so in this case, INTNX would be the most simple way of doing it.

Cheers from Portugal.

Daniel Santos at www.cgd.pt

Re: Reg:Dates

sbb — Mon, 13 Apr 2009 15:38:54 GMT

My mistake in not reading the post accurately. You make an excellent choice with using INTNX, Daniel.

Scott Barry
SBBWorks, Inc.