https://communities.sas.com/t5/SAS-Programming/Calculating-birth-year-by-subtracting-age-from-date/m-p/859774#M339656 <P>Hi - I am looking for some help on how to calculate birth year given the below data and assuming the data was run on June 1, 2022:</P><P>&nbsp;</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Employee</TD><TD>YOE</TD><TD>Age</TD></TR><TR><TD>A</TD><TD>1</TD><TD>21</TD></TR><TR><TD>B</TD><TD>2</TD><TD>22.4</TD></TR><TR><TD>C</TD><TD>3</TD><TD>25</TD></TR><TR><TD>D</TD><TD>4</TD><TD>25.7</TD></TR><TR><TD>E</TD><TD>5</TD><TD>29</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>This is just a sample set of data as the actual data file is much larger. My goal is to determine which year the employees were born if the data file was ran on June 1, 2022. I originally just subtracted the 'Age' column from '2022' with the int() function but realized that doesn't take into account the report being run in June. Can anyone help point me in the right direction?</P> Mon, 20 Feb 2023 20:42:59 GMT hovicke 2023-02-20T20:42:59Z https://communities.sas.com/t5/SAS-Programming/Calculating-birth-year-by-subtracting-age-from-date/m-p/859774#M339656 <P>Hi - I am looking for some help on how to calculate birth year given the below data and assuming the data was run on June 1, 2022:</P><P>&nbsp;</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Employee</TD><TD>YOE</TD><TD>Age</TD></TR><TR><TD>A</TD><TD>1</TD><TD>21</TD></TR><TR><TD>B</TD><TD>2</TD><TD>22.4</TD></TR><TR><TD>C</TD><TD>3</TD><TD>25</TD></TR><TR><TD>D</TD><TD>4</TD><TD>25.7</TD></TR><TR><TD>E</TD><TD>5</TD><TD>29</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>This is just a sample set of data as the actual data file is much larger. My goal is to determine which year the employees were born if the data file was ran on June 1, 2022. I originally just subtracted the 'Age' column from '2022' with the int() function but realized that doesn't take into account the report being run in June. Can anyone help point me in the right direction?</P> Mon, 20 Feb 2023 20:42:59 GMT https://communities.sas.com/t5/SAS-Programming/Calculating-birth-year-by-subtracting-age-from-date/m-p/859774#M339656 hovicke 2023-02-20T20:42:59Z https://communities.sas.com/t5/SAS-Programming/Calculating-birth-year-by-subtracting-age-from-date/m-p/859777#M339658 <P>June is 6/12 = 0.5 years</P> <P>&nbsp;</P> <P>So subtract the age from 2022.5</P> Mon, 20 Feb 2023 20:55:16 GMT https://communities.sas.com/t5/SAS-Programming/Calculating-birth-year-by-subtracting-age-from-date/m-p/859777#M339658 PaigeMiller 2023-02-20T20:55:16Z