topic Re: how to calculate average tenure in SAS Programming https://communities.sas.com/t5/SAS-Programming/how-to-calculate-average-tenure/m-p/338260#M76984 <P>Clearly you have a multipart homework assignment, and you have chosen to put each part is a separate topic.&nbsp; But really - separating this "average tenure" request from&nbsp;the "average salary" request?&nbsp; Yes, one of them (tenure) appears to require some preliminary calculation before getting the average.&nbsp; But, just as in your "maximum attrition" question you chose not to provide enough information to make the question clear.</P> <P>&nbsp;</P> <P>You want help (more than help actually).&nbsp; You don't specify what you tried.&nbsp; You don't inform us what you don't understand.&nbsp;&nbsp; This is not enouraging&nbsp;to folks who want to help other learn sas.&nbsp; It seems more like a subcontracting job at very low rates.</P> <P>&nbsp;</P> <P>So tell us, restricting discussion to just this topic, let's just focus on the very first sub-problem:</P> <P>&nbsp;</P> <OL> <LI>What have you tried for calculating tenure?&nbsp;&nbsp; Show us your program and the log it generated - essential for good diagnosis.</LI> </OL> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Sun, 05 Mar 2017 18:31:48 GMT mkeintz 2017-03-05T18:31:48Z how to calculate average tenure https://communities.sas.com/t5/SAS-Programming/how-to-calculate-average-tenure/m-p/338232#M76968 <P>based on below dataset how to calculate tenure</P><P>conditions</P><P>difference between lasthired if available or its need to take today date</P><P>&nbsp; Obs&nbsp;&nbsp; ID&nbsp;&nbsp;&nbsp; Phone&nbsp;&nbsp; LastHired&nbsp; BirthDate&nbsp; Height&nbsp; Month&nbsp; Day&nbsp; termination&nbsp; salary&nbsp; termin&nbsp; Tenure<BR /><BR />&nbsp;&nbsp;&nbsp; 1&nbsp; 327M&nbsp; 5553489&nbsp; 08APR2000&nbsp; 25APR1978&nbsp;&nbsp;&nbsp; 69&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp; 10JAN2014&nbsp;&nbsp;&nbsp; 15000&nbsp;&nbsp;&nbsp; t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 16<BR />&nbsp;&nbsp;&nbsp; 2&nbsp; 102M&nbsp; 5556012&nbsp; 20AUG1999&nbsp; 16MAR1955&nbsp;&nbsp;&nbsp; 70&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp; 26000&nbsp;&nbsp;&nbsp; a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17<BR />&nbsp;&nbsp;&nbsp; 3&nbsp; 131F&nbsp; 5556781&nbsp; 16MAY1997&nbsp; 10SEP1976&nbsp;&nbsp;&nbsp; 64&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp; 25&nbsp;&nbsp; 25DEC2016&nbsp;&nbsp;&nbsp; 35000&nbsp;&nbsp;&nbsp; t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 19<BR />&nbsp;&nbsp;&nbsp; 4&nbsp; 709F&nbsp; 5554023&nbsp; 25JUN1994&nbsp; 08JAN1962&nbsp;&nbsp;&nbsp; 69&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9&nbsp;&nbsp;&nbsp; 17&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp; 28000&nbsp;&nbsp;&nbsp; a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22<BR />&nbsp;&nbsp;&nbsp; 5&nbsp; 056F&nbsp; 5559909&nbsp; 17SEP1991&nbsp; 31JAN1930&nbsp;&nbsp;&nbsp; 59&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp; 33000&nbsp;&nbsp;&nbsp; a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 25<BR />&nbsp;&nbsp;&nbsp; 6&nbsp; 287M&nbsp; 5557024&nbsp; 10DEC1993&nbsp; 14JUL1969&nbsp;&nbsp;&nbsp; 78&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11&nbsp;&nbsp;&nbsp; 23&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp; 40000&nbsp;&nbsp;&nbsp; a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23<BR />&nbsp;&nbsp;&nbsp; 7&nbsp; 097F&nbsp; 5557045&nbsp; 23NOV1994&nbsp; 17AUG1972&nbsp;&nbsp;&nbsp; 68&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11&nbsp;&nbsp;&nbsp; 12&nbsp;&nbsp; 15MAY2000&nbsp;&nbsp;&nbsp; 21000&nbsp;&nbsp;&nbsp; t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22<BR />&nbsp;&nbsp;&nbsp; 8&nbsp; 070M&nbsp; 5555602&nbsp; 12NOV1995&nbsp; 14FEB1946&nbsp;&nbsp;&nbsp; 71&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp; 27&nbsp;&nbsp; 20FEB2005&nbsp;&nbsp;&nbsp; 23000&nbsp;&nbsp;&nbsp; t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21<BR />&nbsp;&nbsp;&nbsp; 9&nbsp; 217M&nbsp; 5558114&nbsp; 27MAR2000&nbsp; 19MAY1963&nbsp;&nbsp;&nbsp; 71&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp; 18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp; 58000&nbsp;&nbsp;&nbsp; a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 16<BR />&nbsp;&nbsp; 10&nbsp; 118F&nbsp; 5559100&nbsp; 11OCT1998&nbsp; 06OCT1977&nbsp;&nbsp;&nbsp; 66&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp; 47000&nbsp;&nbsp;&nbsp; a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18<BR />&nbsp;&nbsp; 11&nbsp; 187M&nbsp; 5553688&nbsp; 18JUL1996&nbsp; 22MAR1925&nbsp;&nbsp;&nbsp; 76&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp; 63000&nbsp;&nbsp;&nbsp; a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20<BR />&nbsp;&nbsp; 12&nbsp; 035M&nbsp; 5555131&nbsp; 02DEC1998&nbsp; 23JUN1974&nbsp;&nbsp;&nbsp; 70&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp; 06JUN2008&nbsp;&nbsp;&nbsp; 45000&nbsp;&nbsp;&nbsp; t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18<BR />&nbsp;&nbsp; 13&nbsp; 254F&nbsp; 5554950&nbsp; 07JAN2000&nbsp; 27FEB1940&nbsp;&nbsp;&nbsp; 63&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp; 25&nbsp;&nbsp; 28AUG2009&nbsp;&nbsp;&nbsp; 50000&nbsp;&nbsp;&nbsp; t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17<BR />&nbsp;&nbsp; 14&nbsp; 167F&nbsp; 5558333&nbsp; 06DEC1999&nbsp; 27OCT1969&nbsp;&nbsp;&nbsp; 69&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp; 22&nbsp;&nbsp; 11NOV2016&nbsp;&nbsp;&nbsp; 39000&nbsp;&nbsp;&nbsp; t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17<BR />&nbsp;&nbsp; 15&nbsp; 093F&nbsp; 5552525&nbsp; 25AUG1993&nbsp; 05NOV1963&nbsp;&nbsp;&nbsp; 57&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp; 25&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp; 42000&nbsp;&nbsp;&nbsp; a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23<BR />&nbsp;&nbsp; 16&nbsp; 261M&nbsp; 5557831&nbsp; 22MAY1994&nbsp; 01NOV1965&nbsp;&nbsp;&nbsp; 70&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp; 24000&nbsp;&nbsp;&nbsp; a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22<BR />&nbsp;&nbsp; 17&nbsp; 088M&nbsp; 5551006&nbsp; 25FEB2000&nbsp; 28MAY1950&nbsp;&nbsp;&nbsp; 69&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9&nbsp;&nbsp;&nbsp; 17&nbsp;&nbsp; 15FEB2017&nbsp;&nbsp;&nbsp; 19000&nbsp;&nbsp;&nbsp; t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17<BR />&nbsp;&nbsp; 18&nbsp; 134M&nbsp; 5559945&nbsp; 15NOV1998&nbsp; 16AUG1959&nbsp;&nbsp;&nbsp; 73&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp; 46000&nbsp;&nbsp;&nbsp; a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18<BR />&nbsp;&nbsp; 19&nbsp; 207M&nbsp; 5556563&nbsp; 17SEP1996&nbsp; 15APR1947&nbsp;&nbsp;&nbsp; 67&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11&nbsp;&nbsp;&nbsp; 25&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp; 48000&nbsp;&nbsp;&nbsp; a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20<BR />&nbsp;&nbsp; 20&nbsp; 158F&nbsp; 5555613&nbsp; 01NOV1995&nbsp; 10JAN1971&nbsp;&nbsp;&nbsp; 65&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp; 28&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp; 47000&nbsp;&nbsp;&nbsp; a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21<BR />&nbsp;&nbsp; 21&nbsp; 065M&nbsp; 5552709&nbsp; 04DEC1994&nbsp; 23JUL1964&nbsp;&nbsp;&nbsp; 60&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9&nbsp;&nbsp;&nbsp; 30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp; 80000&nbsp;&nbsp;&nbsp; a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22<BR />&nbsp;&nbsp; 22&nbsp; 288M&nbsp; 5551856&nbsp; 25NOV1997&nbsp; 01JUL1965&nbsp;&nbsp;&nbsp; 73&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp; 22&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp; 75000&nbsp;&nbsp;&nbsp; a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 19<BR />&nbsp;&nbsp; 23&nbsp; 134F&nbsp; 5554442&nbsp; 28OCT1999&nbsp; 18SEP1979&nbsp;&nbsp;&nbsp; 69&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp; 44000&nbsp;&nbsp;&nbsp; a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17<BR />&nbsp;&nbsp; 24&nbsp; 025F&nbsp; 5552442&nbsp; 30SEP1998&nbsp; 07MAY1971&nbsp;&nbsp;&nbsp; 65&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp; 36000&nbsp;&nbsp;&nbsp; a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18</P> Sun, 05 Mar 2017 08:38:48 GMT https://communities.sas.com/t5/SAS-Programming/how-to-calculate-average-tenure/m-p/338232#M76968 Ravikumarpa4 2017-03-05T08:38:48Z Re: how to calculate average tenure https://communities.sas.com/t5/SAS-Programming/how-to-calculate-average-tenure/m-p/338260#M76984 <P>Clearly you have a multipart homework assignment, and you have chosen to put each part is a separate topic.&nbsp; But really - separating this "average tenure" request from&nbsp;the "average salary" request?&nbsp; Yes, one of them (tenure) appears to require some preliminary calculation before getting the average.&nbsp; But, just as in your "maximum attrition" question you chose not to provide enough information to make the question clear.</P> <P>&nbsp;</P> <P>You want help (more than help actually).&nbsp; You don't specify what you tried.&nbsp; You don't inform us what you don't understand.&nbsp;&nbsp; This is not enouraging&nbsp;to folks who want to help other learn sas.&nbsp; It seems more like a subcontracting job at very low rates.</P> <P>&nbsp;</P> <P>So tell us, restricting discussion to just this topic, let's just focus on the very first sub-problem:</P> <P>&nbsp;</P> <OL> <LI>What have you tried for calculating tenure?&nbsp;&nbsp; Show us your program and the log it generated - essential for good diagnosis.</LI> </OL> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Sun, 05 Mar 2017 18:31:48 GMT https://communities.sas.com/t5/SAS-Programming/how-to-calculate-average-tenure/m-p/338260#M76984 mkeintz 2017-03-05T18:31:48Z