two decimals in percentages in proc tabulate

[dustychair]

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;

[ballardw · Accepted solution]

---

@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.

[sbxkoenk]

Hello,

Rowpctn*format=comma18.2

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

Koen

[dustychair]

thank you @ballardw