Proc Tabulate

[pallis]

Hi,

1 )When I try to run the proc tabulate there is missing data in some of columns. Those columns are numeric which is populated by '.'.

   I  need to replace '.' with 0. I tried missing in

    PROC TABULATE DATA= Bncd_aug13_test  missing;

    But It didn't worked for me

2) When I display output Im getting the 'N"

       BOU     ‚    CLR     ‚    NCL     ‚

          N      ‚     N      ‚     N.

Is there any way to hide 'N'.

regards,

venky

[ballardw]

option at the end of the table statement

/ misstext='0';

[pallis · Accepted solution]

I got output. I just want to update it may helpful for some who is looking for similar kind of solution.

{code}

PROC TABULATE DATA= Bncd_Emp   ;

Class a  b;

TABLE a, b*n=''/ misstext='0' ;

  RUN;

We can supress the n in output by placing n=''.

As @ballardw said in case of missing text in output you can replace with 0 by using misstext='0'

Regards,

venky