Architecting, installing and maintaining your SAS environment

Proc Tabulate

Accepted Solution Solved
Reply
Contributor
Posts: 71
Accepted Solution

Proc Tabulate

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


Accepted Solutions
Solution
‎09-19-2013 01:55 AM
Contributor
Posts: 71

Re: Proc Tabulate

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

View solution in original post


All Replies
Super User
Posts: 11,343

Re: Proc Tabulate

option at the end of the table statement

/ misstext='0';

Solution
‎09-19-2013 01:55 AM
Contributor
Posts: 71

Re: Proc Tabulate

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 338 views
  • 3 likes
  • 2 in conversation