topic Re: Proc tabulate issue in SAS Procedures

Proc tabulate issue

ameey — Thu, 07 May 2015 10:27:44 GMT

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.

Re: Proc tabulate issue

RW9 — Thu, 07 May 2015 10:59:52 GMT

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.

Re: Proc tabulate issue

ameey — Thu, 07 May 2015 11:13:45 GMT

Hi RW9

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

Re: Proc tabulate issue

RW9 — Thu, 07 May 2015 12:12:34 GMT

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;

Re: Proc tabulate issue

Ksharp — Thu, 07 May 2015 12:59:25 GMT

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

Re: Proc tabulate issue

Cynthia_sas — Thu, 07 May 2015 22:53:25 GMT

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