05-07-2015 06:27 AM
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.
05-07-2015 06:59 AM
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.
05-07-2015 08:12 AM
proc tabulate data=xyz out=results;
if decision_column="Something" then result_column="";
ods pdf file=...;
proc report data=results...;
ods pdf close;
05-07-2015 08:59 AM
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 .
05-07-2015 06:53 PM
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..