Using date

[L_L]

Dear all

I have a dataset with two dates as the example below.

I would like to create a variable X1=DATE2 - DATE1 (months).

How can I proceed?

Thanks in advance for any help

N		Date1	Date2
1		01/06/2006	05/06/2009
2		01/01/2006	28/03/2006
3		01/01/2002	15/01/2002
4		01/09/2007	02/10/2008
5		01/01/2000	02/02/2000
6		01/01/1993	15/01/1993
7		01/10/1989	15/10/1989
8		01/02/1998	01/07/1998
9		01/03/1998	12/03/1998

[art297 · Accepted solution]

Depending upon how you define number of months difference, you might be able to use something like:

data want;

  set have;

  months=intck('month',date1,date2,'c');

run;