%LET ElapseTime = ProjEndDate-ProjStDate;
data combine1;
set combine;
TotalProjDays1=&ElapseTime;
AmtSpentPercentage=&PercentSpent;
run;
For the elapse time I do get the difference between the ProjStDate and ProjEndDate however the number is very large. Here is a sample output (shown horizontally
ProjID
1
ProjStDate
15NOV2008:00:00:00
ProjEndDate
15DEC2009:00:00:00
TotalProjDays
34128000
How can I convert the TotalProjDays to obtain the true # of days (in this case from 11/5/08 to 12/5/09??
data combine1;
set combine;
TotalProjDays1=&ElapseTime;
AmtSpentPercentage=&PercentSpent;
run;
For the elapse time I do get the difference between the ProjStDate and ProjEndDate however the number is very large. Here is a sample output (shown horizontally
ProjID
1
ProjStDate
15NOV2008:00:00:00
ProjEndDate
15DEC2009:00:00:00
TotalProjDays
34128000
How can I convert the TotalProjDays to obtain the true # of days (in this case from 11/5/08 to 12/5/09??