topic Re: Removing periods from output table in SAS Programming

Removing periods from output table

Batman — Tue, 29 Nov 2022 20:19:42 GMT

I'm using code similar to the following. However, my output is printing periods in some cells with missing values. How can I change the format so those cells displays either "0" or are blank?

proc format;                           
   picture mypct (round) low-high='009.99%';   
run; 

proc tabulate data=sashelp.class;
   class age sex;
   var weight height; 
   table age, sex*(weight height)*(pctsum*f=mypct.);
run;

Re: Removing periods from output table

PaigeMiller — Tue, 29 Nov 2022 20:39:47 GMT

options missing=0;
proc format;                           
   picture mypct (round) low-high='009.99%';   
run; 

proc tabulate data=sashelp.class;
   class age sex;
   var weight height; 
   table age, sex*(weight height)*(pctsum*f=mypct.);
run;
options missing=.; /* This step is optional, it re-sets the default appearance of missing values */