topic PCT from total for each field in SAS Programming

PCT from total for each field

Ronein — Tue, 09 Mar 2021 20:16:14 GMT

Hello

I would like to get the following summary table which calculate percent from total for each category of each field.

May anyone show the code that can create it?

Cherers

Data Rawtbl;
input ID field $  category  year ;
cards;
1 x 1 2020 
1 w 2 2020
1 z 2 2020
2 x 2 2020
2 w 3 2020
2 z 2 2020
3 x 2 2020
3 w 2 2020
3 z 2 2020
4 x 1 2020
4 w 2 2020
4 z 1 2020
5 x 3 2020
5 w 2 2020
5 z 2 2020
6 x 2 2021 
6 w 3 2021
6 z 1 2021
2 x 1 2021
2 w 1 2021
2 z 1 2021
3 x 2 2021
3 w 2 2021
3 z 3 2021
4 x 3 2021
4 w 2 2021
4 z 1 2021
;
run;

Re: PCT from total for each field

Ksharp — Wed, 10 Mar 2021 12:03:27 GMT

Data Rawtbl;
input ID field $  category  year ;
cards;
1 x 1 2020 
1 w 2 2020
1 z 2 2020
2 x 2 2020
2 w 3 2020
2 z 2 2020
3 x 2 2020
3 w 2 2020
3 z 2 2020
4 x 1 2020
4 w 2 2020
4 z 1 2020
5 x 3 2020
5 w 2 2020
5 z 2 2020
6 x 2 2021 
6 w 3 2021
6 z 1 2021
2 x 1 2021
2 w 1 2021
2 z 1 2021
3 x 2 2021
3 w 2 2021
3 z 3 2021
4 x 3 2021
4 w 2 2021
4 z 1 2021
;
run;

proc format ;
picture fmt
low-high='009.99%';
run;
proc tabulate data=rawtbl;
class category field year;
table field*(category all),year*pctn<category all >='PCT'*f=fmt8.2 /printmiss;
run;

Re: PCT from total for each field

Cynthia_sas — Wed, 10 Mar 2021 16:29:31 GMT

Hi:
Is this a new requirement for THIS same question and data? https://communities.sas.com/t5/SAS-Programming/proc-tabulate-percent-from-total-column-per-each-group/m-p/725059#M225161

Cynthia