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