BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
pallis
Fluorite | Level 6

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

1 ACCEPTED SOLUTION

Accepted Solutions
pallis
Fluorite | Level 6

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

2 REPLIES 2
ballardw
Super User

option at the end of the table statement

/ misstext='0';

pallis
Fluorite | Level 6

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

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

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