Help using Base SAS procedures

using dates

Reply
Frequent Contributor
Posts: 104

using dates

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;

Super Contributor
Posts: 1,636

Re: using dates

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

Frequent Contributor
Posts: 104

Re: using dates

Thanks LinLin!  Always very helpful!

Ask a Question
Discussion stats
  • 2 replies
  • 175 views
  • 1 like
  • 2 in conversation