topic calculate start date based on two variables in SAS Procedures

calculate start date based on two variables

robwork — Thu, 15 Mar 2012 01:09:34 GMT

Hi I am trying to calculate a start date of employment usig the variables TimeInJobYears and TimeInJobMonths

Is there anyway that I can use these two fields to calculate when a person started work, I was thinking along the lines of todays date - (TimeInJob
Years + TimeInJobMonths)

Any help would be greatly appreciated, Thanks

calculate start date based on two variables

Hima — Thu, 15 Mar 2012 01:18:27 GMT

Can you post sample data?

calculate start date based on two variables

robwork — Thu, 15 Mar 2012 01:23:52 GMT

The TimeInJobYears and TimeInJobMonths fields hold a numeric number.

Name TimeInJobYears TimeInJobMonths

John Smith 6 4

Alan Turner 2 8

calculate start date based on two variables

Haikuo — Thu, 15 Mar 2012 01:31:04 GMT

Here is one approach, please note, I choose the beginning of the month as the date. You chould select end, middle as well.

data have;

input Name & $12. TimeInJobYears TimeInJobMonths ;

cards;

John Smith 6 4

Alan Turner 2 8

;

data want;

set have;

start_dt=intnx('month',today(),-TimeInJobYears*12-TimeInJobMonths, 'b');

format start_dt date9.;

run;

proc print;run;

calculate start date based on two variables

Linlin — Thu, 15 Mar 2012 01:41:39 GMT

how about:

data have;

input TimeInJobYears TimeInJobmonth;

cards;

5 10

6 11

;

data want;

set have;

start_date=intnx('month',today(),-(12*TimeInJobYears+TimeInJobYears),'m');

format start_date mmddyy10.;

run;

proc print;run;

TimeIn TimeIn

Obs JobYears Jobmonth start_date

1 5 10 10/16/2006

2 6 11 09/15/2005

calculate start date based on two variables

robwork — Thu, 15 Mar 2012 01:41:51 GMT

Thanks, that worked perfectly.