Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

I have a dataset with variables empid and doj how to calculate retirement age?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is sas application server? : Sas-di

1074


Explain proc univariate?

1027


describe the interaction table in sas di? : Sas-di

1031


Explain the purpose of substr functions in sas programming.

1057


what is the difference between unique key and primary key? : Sas-di

1125


Do you need to rearrange the order of the data for the report?

2303


What is the difference between match merge and one to one merge?

1244


what is the use of sas management console? : Sas-di

1089


What would be the value of month at the end of data step execution and how many observations would be there?

1141


how to do user inputs and command line arguments in sas?

3046


What areas of SAS are you most interested in?

1533


I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.

2146


Define run-group processing?

1035


what is treatment emergent events and treatment emregent adverse event

2397


what is broad cast agent? : Sas-bi

1068