topic Re: Create customized tables in SAS in New SAS User

Create customized tables in SAS

skhan9 — Thu, 13 Jun 2024 21:09:37 GMT

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!

Re: Create customized tables in SAS

Ksharp — Fri, 14 Jun 2024 01:27:33 GMT

data have;
infile datalines expandtabs truncover;
input Year	Gender $	Age &$40.	Frequency	Rate;
datalines;
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
;
proc report data=have nowd;
columns Gender Age	Year,(Frequency	Rate);
define gender/group noprint;
define age/group  'Gender and Age';
define year/across;
define Frequency/analysis sum;
define Rate/analysis sum;
compute before gender/style={just=l};
line gender $80.;
endcomp;
run;

Re: Create customized tables in SAS

skhan9 — Fri, 14 Jun 2024 15:35:23 GMT

Thank you @Ksharp for the solution, it worked!