I have a dataset with variables empid and doj how to calculate retirement age?
Answer / 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 |
How to read multiple excel sheets from a single excel file at once????
7 Answers HCL, Verinon Technology Solutions,
what is portability of sas programmes?
what are validation tools that are used in sas? : Sas-administrator
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
What is _n_?
Can you suggest us materials for sdtm mapping?
how many data types in sas? : Sas-administrator
what is the use of proc contents and proc print in sas? : Sas-administrator
How are numeric and character missing values represented internally?
How would you include common or reuse to be processed along with your statements?
How would you delete observations with duplicate keys?
what techniques and/or procs do you use for tables? : Sas programming