topic Re: proc tabulate decimal places with dummy variable percentn in SAS Programming

proc tabulate decimal places with dummy variable percentn

Cruise — Fri, 10 Aug 2018 18:44:29 GMT

Hi guys,

It must be very simple but I couldn't find solution online. How to achieve decimal place with percentn. format below? ob is 0 vs 1 dummy variable.

proc tabulate data=l.mydata order=internal;
var ob;
class durcat agecat race1 assist fam_size hh_smoking area;
tables (All agecat race1 assist fam_size hh_smoking area), 
	   (durcat)*(ob)*(mean*f=percentn.)/nocellmerge printmiss;
where agecat=5; 
run;

Thanks!

Re: proc tabulate decimal places with dummy variable percentn

Kurt_Bremser — Fri, 10 Aug 2018 18:54:15 GMT

Try percentn7.2

Re: proc tabulate decimal places with dummy variable percentn

Astounding — Fri, 10 Aug 2018 18:54:25 GMT

You have to provide more detail in the format. For example, use the format:

percentn5.1

Re: proc tabulate decimal places with dummy variable percentn

Cruise — Fri, 10 Aug 2018 18:57:07 GMT

I tried percentn5.1 , percentn5.2, percentn5.3, but never thought of 7. I don't why 7 worked but 5

Re: proc tabulate decimal places with dummy variable percentn

Kurt_Bremser — Fri, 10 Aug 2018 19:09:16 GMT

You need space for the % character, an optional sign, the decimal dot, and at least 2 digits left of the dot.