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 |
What is the function of output statement in a SAS Program?
Where do the database management systems store data and how do u import them.
What is the role of unrestrictive users? : sas-grid-administration
Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com
/*i have the following dataset.*/ data score; input marks ; datalines; 10 20 30 40 50 60 70 80 90 100 ; run; Now i should get the result as sum of 1 to 5 i.e(10+20+30+40+50)=150 and 2 to 6 i.e(20+30+40+50+60)=200 and 3 to 7 i.e(30+40+50+60+70)=250 and so on. how to get it. thanks in advance
How will you generate test data with no input data?
Briefly describe 5 ways to do a "table lookup" in sas.
how to write code for left outer join in SAs using datastep?
is data integration and etl programming is same? : Sas-di
what is Global Symbol table and Local symbol table?
We want to merge file A and B. File A has variable age, file B provide birthdate. How to merge the data according to age in file B
Which command is used to perform sorting in sas program?