I have a dataset with variables empid and doj how to calculate retirement age?
Answer Posted / virat chary vadla
data joindates;
input empid$ doj date9.;
format doj is8601da.;
cards;
a101 01jan2000
a102 01aug2000
;
/*if retirement time is for 60 yrs then */
data ret_dates;
set joindates;
ret=intnx('year',doj,60,'same');
format ret doj is8601da.;
put 'for the empid--' empid 'retirement date is--' ret;
run;
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
what is sas application server? : Sas-di
Explain proc univariate?
describe the interaction table in sas di? : Sas-di
Explain the purpose of substr functions in sas programming.
what is the difference between unique key and primary key? : Sas-di
Do you need to rearrange the order of the data for the report?
What is the difference between match merge and one to one merge?
what is the use of sas management console? : Sas-di
What would be the value of month at the end of data step execution and how many observations would be there?
how to do user inputs and command line arguments in sas?
What areas of SAS are you most interested in?
I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.
Define run-group processing?
what is treatment emergent events and treatment emregent adverse event
what is broad cast agent? : Sas-bi