topic Re: Duplicate percent column in Frequency table, missing decimal in percent column in ODS and Base Reporting

Duplicate percent column in Frequency table, missing decimal in percent column

LNEW — Thu, 31 Aug 2017 21:09:29 GMT

ODS RTF FILE =   'S:\blahblah\frequencies.RTF'
STYLE = BARRETTSBLUE STARTPAGE = NO;
ODS NOPROCTITLE;

%MACRO PRINTFREQ (VAR =  );
PROC FREQ DATA =dat._3_subset;
TABLES &VAR.;
WHERE &VAR. NOT IN ('7', '8', '9', '77', '88', '99');
RUN;
%MEND PRINTFREQ;

%PRINTFREQ (VAR=Q1)
%PRINTFREQ (VAR=Q2)
%PRINTFREQ (VAR=Q3)

I am using 9.4

X64_7PRO platform

X64_7PRO WIN 6.1.7601 Service Pack 1 Workstation

As you can see in the attachment my output has two percent columns. Can someone tell me why I am getting two percent columns in the output and also why I am not getting a decimal in the percent column? Is it a settings issue? Can you assist me in resetting if needed?

Thanks. L

Re: Duplicate percent column in Frequency table, missing decimal in percent column

Reeza — Thu, 31 Aug 2017 22:15:49 GMT

Try using PROC TABULATE instead of FREQ. You get a lot more control over your output.

Re: Duplicate percent column in Frequency table, missing decimal in percent column

WarrenKuhfeld — Fri, 01 Sep 2017 02:00:43 GMT

Have you changed the template? Run the step below. If you have a copy outside of sashelp, delete it.

proc template;
list base.freq.onewayfreqs;
quit;

https://support.sas.com/documentation/cdl/en/statug/63347/HTML/default/viewer.htm#statug_odsgraph_sect054.htm

Re: Duplicate percent column in Frequency table, missing decimal in percent column

LNEW — Fri, 01 Sep 2017 12:00:05 GMT

Thanks so much. This is what I ran and the results were spot on.

ods path sashelp.tmplmst(read) sasuser.templat(update);

ods path sashelp.tmplmst(read);
proc datasets library=sasuser nolist;
delete templat(memtype=itemstor);
run;
ods path sasuser.templat(update) sashelp.tmplmst(read);

proc template;
list base.freq.onewayfreqs;
quit;

Re: Duplicate percent column in Frequency table, missing decimal in percent column

LNEW — Fri, 01 Sep 2017 12:01:14 GMT

This is what I ran and the results were spot on. Thank you.

ods path sashelp.tmplmst(read) sasuser.templat(update);

ods path sashelp.tmplmst(read);

proc datasets library=sasuser nolist;

delete templat(memtype=itemstor);

run;

ods path sasuser.templat(update) sashelp.tmplmst(read);

proc template;

list base.freq.onewayfreqs;

quit;