topic Re: using dates in SAS Procedures

using dates

sophia_SAS — Tue, 10 Apr 2012 18:40:35 GMT

Hi SAS users,

I have a dataset with 3 variables: ID, date1 and date2. I would like to create a new dataset that identifies which observations have a date2 that is 5 months or greater than date1. For example using the data below, I would like to identify IDs 7 and 11 as they have a date2 that is at least 5 months greater than date1.

Thanks.

data have;

input id date1 date2;

cards;

5 05/12/2010 06/12/2010

7 06/22/2010 12/30/2010

9 02/04/2009 05/03/2009

11 03/27/2009 11/05/2009

;

run;

Re: using dates

Linlin — Tue, 10 Apr 2012 18:48:39 GMT

try this one:

data have;

informat date1 date2 mmddyy10.;

format date1 date2 mmddyy10.;

input id date1 date2;

cards;

5 05/12/2010 06/12/2010

7 06/22/2010 12/30/2010

9 02/04/2009 05/03/2009

11 03/27/2009 11/05/2009

;

data want;

set have;

if date2>intnx('month',date1,5,'s');

proc print;run;

Linlin

Re: using dates

sophia_SAS — Tue, 10 Apr 2012 19:02:01 GMT

Thanks LinLin! Always very helpful!