topic Re: one way freq table in SAS Programming

one way freq table

Ronein — Tue, 10 Sep 2019 05:50:29 GMT

Hello

In following code i am trying to change format of one way proc freq.

For example :

For Make=Hummer frequency=1 and Relative Frequency should be 1/428=0.23%

But in the output we get 23%

What is the way to solve it?

I guess that something is wrong with pctfmt format

proc format; 
picture pctfmt low-high='000.00%';
run; 


ods path work.templat(update) sashelp.tmplmst(read); 
proc template; 
edit Base.Freq.OneWayList;
edit Percent;     
header="; Relative Frequency ;"; 
format=pctfmt.;   
justify= on;
end;
edit CumPercent; 
header = ";Cumulative;
Relative Frequency;"; 
format=pctfmt.;
justify= on;
end;   
end;
run;


proc freq data=sashelp.cars;
tables Make  / list;
run;

Re: one way freq table

Rick_SAS — Tue, 10 Sep 2019 11:47:40 GMT

If it is helpful, SAS supports the PERCENTw.d format.

Try PERCENT8.2. If you have negative percentages, you can also use the PERCENTN8.2 format.

Re: one way freq table

ballardw — Tue, 10 Sep 2019 14:34:53 GMT

@Ronein wrote:

Hello

In following code i am trying to change format of one way proc freq.

For example :

For Make=Hummer frequency=1 and Relative Frequency should be 1/428=0.23%

But in the output we get 23%

What is the way to solve it?

I guess that something is wrong with pctfmt format
proc format; 
picture pctfmt low-high='000.00%';
run; 


ods path work.templat(update) sashelp.tmplmst(read); 
proc template; 
edit Base.Freq.OneWayList;
edit Percent;     
header="; Relative Frequency ;"; 
format=pctfmt.;   
justify= on;
end;
edit CumPercent; 
header = ";Cumulative;
Relative Frequency;"; 
format=pctfmt.;
justify= on;
end;   
end;
run;


proc freq data=sashelp.cars;
tables Make  / list;
run;

Digit selectors in Picture formats don't always work the way you think they will until you have worked with them a lot.

Typically the formats suggest by @Rick_SAS are likely what you want.

I also think this is the format you may have intended to basically duplicate that 8.2 (or similar range) would be:

proc format library=work; 
picture pctfmt low-high='009.99%';
run;

The non-zero values in the string will force a character before the decimal, 0 if no actual value of 1 or greater in the data, and the non-zero after the decimal will always display 2 characters as appropriate (data will be truncated not rounded). Without any non-zero characters in the display string values that are less than 1 , such as your .23 don't really have a good alignment with the picture.