Using date

L_L — Thu, 15 Sep 2011 14:14:45 GMT

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

art297 — Thu, 15 Sep 2011 14:32:05 GMT

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;

topic Using date in SAS Procedures