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 |
Do you use PROC REPORT or PROC TABULATE? Which do you prefer? Explain.
what are some good sas programming practices for processing very large data sets? : Sas programming
How could i automate the code in the scenario:Every month one new data set will be created for that perticular month transaction list.Now i would like to update the data in the source table by appending every month data automatically. jan---set jan; feb---set jan feb; mar---set jan mar;
What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?
Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?
What is the differnce between SDTM 3.1.2 to 3.1.1 version
how can you import .csv file in to sas? : Sas programming
Hi, I have one dataset like id date ex: id date 1 13 1 13Oct2011 2 14 2 14Oct2011 3 15 3 15Oct2011 --->this is the current date here i want date format like 13Oct2011,14Oct2011 how we can modify the numeric to date format plz answer.
What is the purpose of the trailing and How would you use them?
How do you add a prefix to some or all variables in a dataset using a SAS macro?
What is SAS? is it a software just for use or we can creat something over there?
Describe the ways in which you can create a macro variable?