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.
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.
Hi RW9
I have to use only proc tabulate and SAS ODS only. Sorry to say I did not get your answer.
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;
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
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.