Help using Base SAS procedures

Proc tabulate issue

Reply
Occasional Contributor
Posts: 19

Proc tabulate issue

Hi Cynthia/All

Please guide me how can I keep the value of total column for a particular indicator as a blank cell in proc tabulate. As given below i have enclosed a the requirement sheet where we have to put blank cell in a total column for a particular indicators only and rest should come  with the sum of all months.  I have attached a small Data set and sas code. Anyone can reply me with correct solution.

print screen.png

Attachment
Super User
Super User
Posts: 7,401

Re: Proc tabulate issue

Cynthia probably has a great way via just tabulate (I personally rarely use it), however from most of these procedures you can store the dataset they create with an out=.  Then you can post-process that dataset in any way you like, finally reporting the output.  So you can do your tabulate, and output to a dataset.  Then a datastep to blank certain row values using base SAS.  Then proc report the dataset out.

Occasional Contributor
Posts: 19

Re: Proc tabulate issue

Hi RW9

I have to use only proc tabulate and SAS ODS only. Sorry to say I did not get your answer.

Super User
Super User
Posts: 7,401

Re: Proc tabulate issue

No probs.

proc tabulate data=xyz out=results;

     ,,,

run;

data results;

     set results;

     if decision_column="Something" then result_column="";

     ...

run;

ods pdf file=...;

proc report data=results...;

run;

ods pdf close;

Super User
Posts: 9,681

Re: Proc tabulate issue

Since you are calling Cynthia out , you 'd better post it at ODS and REPORT forum , so She could see it .

One way I can think is using proc format , it is under condition TOTAL has different value .

Xia Keshan

SAS Super FREQ
Posts: 8,743

Re: Proc tabulate issue

Since the OP posted this same question in several places, it would be a good idea to check ALL the places and find the one where I *did* respond before calling me out about NOT responding. With duplicate posts, I generally don't search out ALL the possible variations of the question that somebody posted just so I can post the same number of the same response..

cynthia

Ask a Question
Discussion stats
  • 5 replies
  • 284 views
  • 2 likes
  • 4 in conversation