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 do you feel about hardcoding?
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
How can I remove header from output data set?
how can you create zero observation dataset? : Sas programming
Describe the function and utility of the most difficult SAS macro that you have written?
How would you delete observations with duplicate keys?
i have a null dataset with 20 variables. i want to upload the variables which contain name like a or k or anything in another dataset.how can we create the dataset?
What is the purpose of using the N=PS option?
how do you derive descriptive statistics?
1 Answers Accenture, Quintiles,
There is a field containing a date. It needs to be displayed in the format "ddmonyy" if it's before 1975, "dd mon ccyy" if it's after 1985, and as 'Disco Years' if it's between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT
what are sas/access and sas/connect? : Sas programming
Are you familiar with special input delimiters How are they used?