topic Re: two decimals in percentages in proc tabulate in New SAS User

two decimals in percentages in proc tabulate

dustychair — Mon, 12 Jul 2021 15:57:54 GMT

Hi all,

I have a question. I am using the below code to format the total. By using this I am getting percentages with no decimals. However, I want the N counts to have no decimals but the percentages have two decimals. How can I modify it?

Thank you,

proc tabulate data=alt501_main out=gender_grade;
class gender grade /missing;
table grade (all= 'Total'* format=comma16.) ,
gender *(N*format=comma16. Rowpctn)(all= 'Total'* format=comma16.);
run;

Re: two decimals in percentages in proc tabulate

ballardw — Mon, 12 Jul 2021 17:19:27 GMT

@dustychair wrote:

Hi all,

I have a question. I am using the below code to format the total. By using this I am getting percentages with no decimals. However, I want the N counts to have no decimals but the percentages have two decimals. How can I modify it?

Thank you,

proc tabulate data=alt501_main out=gender_grade;
class gender grade /missing;
table grade (all= 'Total'* format=comma16.) ,
gender *(N*format=comma16. Rowpctn)(all= 'Total'* format=comma16.);
run;

gender *(N*format=comma16. Rowpctn*f=6.2)(all= 'Total'* format=comma16.);

Should work. If you want different behavior for values like 100 or 0 you could create a custom format.

Re: two decimals in percentages in proc tabulate

sbxkoenk — Mon, 12 Jul 2021 17:24:53 GMT

Hello,

Rowpctn*format=comma18.2

I guess your decimals will be .00 as otherwise 2 decimals would have been displayed.

Koen

Re: two decimals in percentages in proc tabulate

dustychair — Mon, 12 Jul 2021 17:41:00 GMT

thank you @ballardw