topic Re: Calculating AVG salary in SAS Programming https://communities.sas.com/t5/SAS-Programming/Calculating-AVG-salary/m-p/338234#M76970 <P>yes additionally I need</P><P>based on same dataset how to calculate tenure(difference between 'lasthired' if available or else its need to take today date</P><P>&nbsp;</P> Sun, 05 Mar 2017 10:00:53 GMT Ravikumarpa4 2017-03-05T10:00:53Z Calculating AVG salary https://communities.sas.com/t5/SAS-Programming/Calculating-AVG-salary/m-p/338231#M76967 <P>how to calculate avg salry from below dataset</P><P>&nbsp;</P><P>data work.talent3;<BR />&nbsp;&nbsp; input ID $ 1-4 Phone 6-12 @14 LastHired date9.<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/112798">@24</a> BirthDate date9. Height $ 34-35 Month 37-38 Day 40-41 @43 termination DATE9. @53salary @59 termin $;<BR />&nbsp;&nbsp; format lasthired birthdate termination date9.;<BR />datalines;<BR />327M 5553489 08APR2000 25APR1978 69&nbsp; 4&nbsp; 8 10JAN2014 15000 t<BR />102M 5556012 20AUG1999 16MAR1955 70&nbsp; 8 20 &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;26000 a<BR />131F 5556781 16MAY1997 10SEP1976 64&nbsp; 6 25 25DEC2016&nbsp;&nbsp; &nbsp;35000 t<BR />709F 5554023 25JUN1994 08JAN1962 69&nbsp; 9 17&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;28000 a<BR />056F 5559909 17SEP1991 31JAN1930 59 12 10&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;33000 a<BR />287M 5557024 10DEC1993 14JUL1969 78 11 23&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;40000 a<BR />097F 5557045 23NOV1994 17AUG1972 68 11 12 15MAY2000&nbsp;&nbsp; &nbsp;21000 t<BR />070M 5555602 12NOV1995 14FEB1946 71&nbsp; 3 27 20FEB2005&nbsp;&nbsp; &nbsp;23000 t<BR />217M 5558114 27MAR2000 19MAY1963 71&nbsp; 7 18&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;58000 a<BR />118F 5559100 11OCT1998 06OCT1977 66 12&nbsp; 2&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;47000 a<BR />187M 5553688 18JUL1996 22MAR1925 76&nbsp; 1&nbsp; 7&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;63000 a<BR />035M 5555131 02DEC1998 23JUN1974 70 12&nbsp; 6 06JUN2008&nbsp;&nbsp; &nbsp;45000 t<BR />254F 5554950 07JAN2000 27FEB1940 63&nbsp; 8 25 28AUG2009&nbsp;&nbsp; &nbsp;50000 t<BR />167F 5558333 06DEC1999 27OCT1969 69&nbsp; 5 22 11NOV2016&nbsp;&nbsp; &nbsp;39000 t<BR />093F 5552525 25AUG1993 05NOV1963 57&nbsp; 2 25&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;42000 a<BR />261M 5557831 22MAY1994 01NOV1965 70 11 15&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;24000 a<BR />088M 5551006 25FEB2000 28MAY1950 69&nbsp; 9 17 15FEB2017&nbsp;&nbsp; &nbsp;19000 t<BR />134M 5559945 15NOV1998 16AUG1959 73 11&nbsp; 1&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;46000 a<BR />207M 5556563 17SEP1996 15APR1947 67 11 25&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;48000 a<BR />158F 5555613 01NOV1995 10JAN1971 65 10 28&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;47000 a<BR />065M 5552709 04DEC1994 23JUL1964 60&nbsp; 9 30&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;80000 a<BR />288M 5551856 25NOV1997 01JUL1965 73&nbsp; 2 22&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;75000 a<BR />134F 5554442 28OCT1999 18SEP1979 69&nbsp; 5&nbsp; 5&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;44000 a<BR />025F 5552442 30SEP1998 07MAY1971 65 10 15&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;36000 a<BR />;run;</P> Sun, 05 Mar 2017 08:25:48 GMT https://communities.sas.com/t5/SAS-Programming/Calculating-AVG-salary/m-p/338231#M76967 Ravikumarpa4 2017-03-05T08:25:48Z Re: Calculating AVG salary https://communities.sas.com/t5/SAS-Programming/Calculating-AVG-salary/m-p/338233#M76969 <PRE><CODE class=" language-sas">proc sql; select avg(salary) from work.talent3; quit;</CODE></PRE> <P>But I guess there's more to it in your question?</P> Sun, 05 Mar 2017 09:27:33 GMT https://communities.sas.com/t5/SAS-Programming/Calculating-AVG-salary/m-p/338233#M76969 Kurt_Bremser 2017-03-05T09:27:33Z Re: Calculating AVG salary https://communities.sas.com/t5/SAS-Programming/Calculating-AVG-salary/m-p/338234#M76970 <P>yes additionally I need</P><P>based on same dataset how to calculate tenure(difference between 'lasthired' if available or else its need to take today date</P><P>&nbsp;</P> Sun, 05 Mar 2017 10:00:53 GMT https://communities.sas.com/t5/SAS-Programming/Calculating-AVG-salary/m-p/338234#M76970 Ravikumarpa4 2017-03-05T10:00:53Z Re: Calculating AVG salary https://communities.sas.com/t5/SAS-Programming/Calculating-AVG-salary/m-p/338268#M76989 <P>Difference between lasthired and what?</P> Sun, 05 Mar 2017 19:36:37 GMT https://communities.sas.com/t5/SAS-Programming/Calculating-AVG-salary/m-p/338268#M76989 Kurt_Bremser 2017-03-05T19:36:37Z