Help using Base SAS procedures

Using date

Accepted Solution Solved
Reply
Contributor L_L
Contributor
Posts: 56
Accepted Solution

Using date

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


Accepted Solutions
Solution
‎09-15-2011 10:32 AM
PROC Star
Posts: 7,360

Using date

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;

View solution in original post


All Replies
Solution
‎09-15-2011 10:32 AM
PROC Star
Posts: 7,360

Using date

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;

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 108 views
  • 0 likes
  • 2 in conversation