how to write a syntax to compute 'median age' for a population using sas
example
age group population
0-4 200
5-9 250
10-14 320
15-19 600
20-24 435
@ash2000 wrote:
how to write a syntax to compute 'median age' for a population using sas
example
age group population
0-4 200
5-9 250
10-14 320
15-19 600
20-24 435
Is this an example of your input-data or the requested result?
In a case like this you don't really have a good way to find the median.
You can determine the total, which is1805, and the middle is 903ish, which means the 'median' is 15-19.
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.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.