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 |
The below code we are using for creating more than one macro variables in proc sql using into clause. How we can use same code to create macro variables vara, varb, varc instead of var1, var2, var3.? proc sql noprint; select count(distinct(patient)) into :var1 - :var3 from dataset1 group by trtreg1c ; quit;
Describe crosslist option in tables statement?
How are numeric and character missing values represented internally?
What is LAG function?How is it used? can any one explain
3 Answers TRE, Verinon Technology Solutions,
How do dates work in SAS data?
if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...
Which command is used to save logs in the external file?
What is the difference between where and if statement?
explain the difference between proc means and proc summary?
is it possible to generate sas datasets using proc print ???
1 Answers GSK GlaxoSmithKline,
What is the Program Data Vector (PDV)? What are its functions?
How to import the Zip files into SAS? If it is possible in SAS? If it is posible write the code...