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 |
how to remove duplicates using proc sql?
what is broad cast agent? : Sas-bi
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 ...
what is proc Index? and what is proc document?
what is pdv? how it is related to input buffer in sas?
If a variable contains letters or special characters, can it be numeric data type?
How would you code a macro statement to produce information on the SAS log? This statement can be coded anywhere.
In which case u go for libname and in which case u go for proc sql pass thru facilit diff?
We have a string like this "kannafromsalembut" ,from this i want to get only "fromsal" (but one condition with out using substring function)here we can not use scan because in the given string there is no delimeter? so give ans without out using substring ?
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)?
Explain what Proc glm does?
What are the ways in which macro variables can be created in sas programming?