Table Programming- get total column at the bottom

[HitmonTran]

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):

HitmonTran_0-1608167128115.png

[Reeza]

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=n128ae2...

---

@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):

HitmonTran_0-1608167128115.png

---

[HitmonTran]

how do i get the %?

[Reeza]

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