https://communities.sas.com/t5/SAS-Programming/Syntaz/m-p/539287#M148568 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/264477">@ash2000</a>&nbsp;wrote:<BR /> <P>how to write a syntax to compute 'median age' for a population using sas&nbsp;</P> <P>example</P> <P>age group&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;population</P> <P>0-4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;200</P> <P>5-9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;250</P> <P>10-14&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;320</P> <P>15-19&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;600</P> <P>20-24&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;435</P> <HR /></BLOCKQUOTE> <P>Is this an example of your input-data or the requested result?</P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 28 Feb 2019 13:51:32 GMT andreas_lds 2019-02-28T13:51:32Z https://communities.sas.com/t5/SAS-Programming/Syntaz/m-p/539231#M148540 <P>how to write a syntax to compute 'median age' for a population using sas&nbsp;</P><P>example</P><P>age group&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;population</P><P>0-4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;200</P><P>5-9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;250</P><P>10-14&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;320</P><P>15-19&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;600</P><P>20-24&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;435</P> Thu, 28 Feb 2019 08:17:01 GMT https://communities.sas.com/t5/SAS-Programming/Syntaz/m-p/539231#M148540 ash2000 2019-02-28T08:17:01Z https://communities.sas.com/t5/SAS-Programming/Syntaz/m-p/539287#M148568 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/264477">@ash2000</a>&nbsp;wrote:<BR /> <P>how to write a syntax to compute 'median age' for a population using sas&nbsp;</P> <P>example</P> <P>age group&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;population</P> <P>0-4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;200</P> <P>5-9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;250</P> <P>10-14&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;320</P> <P>15-19&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;600</P> <P>20-24&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;435</P> <HR /></BLOCKQUOTE> <P>Is this an example of your input-data or the requested result?</P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 28 Feb 2019 13:51:32 GMT https://communities.sas.com/t5/SAS-Programming/Syntaz/m-p/539287#M148568 andreas_lds 2019-02-28T13:51:32Z https://communities.sas.com/t5/SAS-Programming/Syntaz/m-p/539346#M148592 <P>In a case like this you don't really have a good way to find the median.&nbsp;</P> <P>&nbsp;</P> <P>You can determine the total, which is1805, and the middle is 903ish, which means the 'median' is 15-19.&nbsp;</P> <P>&nbsp;</P> <P>If you had exact ages you could do an actual calculation, but I don't believe that SAS has a method for computing medians when data is in this format.&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 28 Feb 2019 15:52:29 GMT https://communities.sas.com/t5/SAS-Programming/Syntaz/m-p/539346#M148592 Reeza 2019-02-28T15:52:29Z