topic Re: calculating age in SAS in SAS Programming https://communities.sas.com/t5/SAS-Programming/calculating-age-in-SAS/m-p/372577#M89103 <P>Hi, using the attached XLS file ...</P> <P>&nbsp;</P> <P><FONT face="courier new,courier"><STRONG>libname x 'z:\text.xls';</STRONG></FONT></P> <P>&nbsp;</P> <P><FONT face="courier new,courier"><STRONG>data want;</STRONG></FONT><BR /><FONT face="courier new,courier"><STRONG>set x.'sheet1$'n;</STRONG></FONT><BR /><FONT face="courier new,courier"><STRONG>age = yrdif(bob,today(),'age');</STRONG></FONT><BR /><FONT face="courier new,courier"><STRONG>run;</STRONG></FONT></P> <P>&nbsp;</P> <P><FONT face="courier new,courier"><STRONG>libname x clear;</STRONG></FONT></P> <P>&nbsp;</P> <P><FONT face="courier new,courier"><STRONG>DATA SET: want</STRONG></FONT></P> <P><FONT face="courier new,courier"><STRONG>name &nbsp; &nbsp; &nbsp; &nbsp;bob &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; age</STRONG></FONT></P> <P><FONT face="courier new,courier"><STRONG>singh &nbsp; &nbsp; 01JAN1980 &nbsp; &nbsp; 37.4986</STRONG></FONT><BR /><FONT face="courier new,courier"><STRONG>anitha &nbsp; &nbsp;06MAR1991 &nbsp; &nbsp; 26.3233</STRONG></FONT></P> <P>&nbsp;</P> <P>&nbsp;</P> Sun, 02 Jul 2017 16:34:27 GMT MikeZdeb 2017-07-02T16:34:27Z calculating age in SAS https://communities.sas.com/t5/SAS-Programming/calculating-age-in-SAS/m-p/372569#M89101 <P>how to calulate age in SAS of particluar person the data is in excel</P><P>which is something like this&nbsp;</P><P>name &nbsp;bob</P><P>singh &nbsp;1-jan-1980</P><P>anitha 6-mar-1991</P><P>&nbsp;</P> Sun, 02 Jul 2017 16:10:57 GMT https://communities.sas.com/t5/SAS-Programming/calculating-age-in-SAS/m-p/372569#M89101 hmc 2017-07-02T16:10:57Z Re: calculating age in SAS https://communities.sas.com/t5/SAS-Programming/calculating-age-in-SAS/m-p/372577#M89103 <P>Hi, using the attached XLS file ...</P> <P>&nbsp;</P> <P><FONT face="courier new,courier"><STRONG>libname x 'z:\text.xls';</STRONG></FONT></P> <P>&nbsp;</P> <P><FONT face="courier new,courier"><STRONG>data want;</STRONG></FONT><BR /><FONT face="courier new,courier"><STRONG>set x.'sheet1$'n;</STRONG></FONT><BR /><FONT face="courier new,courier"><STRONG>age = yrdif(bob,today(),'age');</STRONG></FONT><BR /><FONT face="courier new,courier"><STRONG>run;</STRONG></FONT></P> <P>&nbsp;</P> <P><FONT face="courier new,courier"><STRONG>libname x clear;</STRONG></FONT></P> <P>&nbsp;</P> <P><FONT face="courier new,courier"><STRONG>DATA SET: want</STRONG></FONT></P> <P><FONT face="courier new,courier"><STRONG>name &nbsp; &nbsp; &nbsp; &nbsp;bob &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; age</STRONG></FONT></P> <P><FONT face="courier new,courier"><STRONG>singh &nbsp; &nbsp; 01JAN1980 &nbsp; &nbsp; 37.4986</STRONG></FONT><BR /><FONT face="courier new,courier"><STRONG>anitha &nbsp; &nbsp;06MAR1991 &nbsp; &nbsp; 26.3233</STRONG></FONT></P> <P>&nbsp;</P> <P>&nbsp;</P> Sun, 02 Jul 2017 16:34:27 GMT https://communities.sas.com/t5/SAS-Programming/calculating-age-in-SAS/m-p/372577#M89103 MikeZdeb 2017-07-02T16:34:27Z