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 |
Please write codes to merge two datasets and keep every record in the first dataset.
what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming
Name statements that function at both compile and execution time.
What is the difference between %put and symbolgen? : sas-macro
how does sas handle missing values in an update? : Sas programming
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
what is sas data set?
Difference between nodup and nodupkey options?
how do u test a pros sql(works or not) without executing it?
You have a data set of 100 observations,how can you restrict the output so that the output has only data from row no. 10 to row no. 20
How would you delete duplicate observations?
how we can call macros with in data step?