topic Re: Table Programming- get total column at the bottom in SAS Programming

Table Programming- get total column at the bottom

HitmonTran — Thu, 17 Dec 2020 01:11:23 GMT

Hi,

New to SAS. I need to create a table, that shows total count across all variables and across all obs. I am stuck on how to get that, thanks.

data (where Age_Group 1= 18-50yo, Age_Group 2=51-65yo , Age_Group 3= 65+yo):

Site    Age     Age_Group
1       18      1
1       18      1
1       18      1
2       20      1
2       55      2
2       55      2
3       55      2
3       70      3
3       75      3

want (table shell):

Re: Table Programming- get total column at the bottom

Reeza — Thu, 17 Dec 2020 01:15:15 GMT

Have you tried using PROC TABULATE? That will likely get you the closest to the image shown.

https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=proc&docsetTarget=n128ae2fqm2jcwn10k5hye2u7f2x.htm&locale=en

@HitmonTran wrote:

Hi,

New to SAS. I need to create a table, that shows total count across all variables and across all obs. I am stuck on how to get that, thanks.

data (where Age_Group 1= 18-50yo, Age_Group 2=51-65yo , Age_Group 3= 65+yo):
Site    Age     Age_Group
1       18      1
1       18      1
1       18      1
2       20      1
2       55      2
2       55      2
3       55      2
3       70      3
3       75      3
want (table shell):

Re: Table Programming- get total column at the bottom

HitmonTran — Thu, 17 Dec 2020 01:24:56 GMT

how do i get the %?

Re: Table Programming- get total column at the bottom

Reeza — Thu, 17 Dec 2020 01:43:41 GMT

Example 12 shows the methods to calculate the percentages. If you want it formatted EXACTLY as shown you have to manually create that table via pre-calculations and then display it using PROC REPORT.

Here's a way to get the data but you'll then need to use PROC REPORT to display the data.
https://gist.github.com/statgeek/0c4aeec9053cf8050be18a03b842c1b9