topic Re: Proc Tabulate in Administration and Deployment

Proc Tabulate

pallis — Wed, 18 Sep 2013 15:37:23 GMT

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 — Wed, 18 Sep 2013 15:39:15 GMT

option at the end of the table statement

/ misstext='0';

pallis — Thu, 19 Sep 2013 05:55:47 GMT

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