Hi all,
I have over 50 tables in my SAS work library that look something like this:
Year | Gender | Age | Frequency | Rate |
2015 | Female | 0 to <18 Years | 23000 | 10 |
2015 | Female | 18 to <65 Years | 16000 | 8 |
2015 | Female | >=65 Years | 45000 | 12 |
2015 | Male | 0 to <18 Years | 20000 | 9 |
2015 | Male | 18 to <65 Years | 15000 | 7 |
2015 | Male | >=65 Years | 50000 | 14 |
2016 | Female | 0 to <18 Years | 24000 | 11 |
2016 | Female | 18 to <65 Years | 17000 | 8 |
2016 | Female | >=65 Years | 46000 | 13 |
2016 | Male | 0 to <18 Years | 21000 | 10 |
2016 | Male | 18 to <65 Years | 16000 | 7 |
2016 | Male | >=65 Years | 51000 | 15 |
2017 | Female | 0 to <18 Years | 25000 | 11 |
2017 | Female | 18 to <65 Years | 18000 | 8 |
2017 | Female | >=65 Years | 48000 | 13 |
2017 | Male | 0 to <18 Years | 22000 | 10 |
2017 | Male | 18 to <65 Years | 17000 | 7 |
2017 | Male | >=65 Years | 53000 | 15 |
I have been exporting the dataset into excel and then manually formatting the tables to something like this:
| Year |
| 2015 | 2015 | 2016 | 2016 | 2017 | 2017 |
Gender and Age | Frequency | Rate | Frequency | Rate | Frequency | Rate |
Female | | | | | | |
0 to <18 yrs | 23000 | 10 | 24000 | 11 | 25000 | 11 |
18 to <65 Years | 16000 | 8 | 17000 | 8 | 18000 | 8 |
>=65 years | 45000 | 12 | 46000 | 13 | 48000 | 13 |
Male | | | | | | |
0 to <18 yrs | 20000 | 9 | 21000 | 10 | 22000 | 10 |
18 to <65 Years | 15000 | 7 | 16000 | 7 | 17000 | 7 |
>=65 years | 50000 | 14 | 51000 | 15 | 53000 | 15 |
I am wondering if there is a way to create customized tables in SAS so that I don't have to manually create these in Excel/Word to avoid errors and save time?
Thank you!