tot_per=catx("% ,",per_task,tot) where per_task and tot are both numeric values.
I'm trying to create the following table:
proc report data=task_groups1 nowd contents="Claims" out=test
style(header)=[font_weight=bold background=CX90D9D7];
options missing='0';
column task_grp bu, (tot_per);
define task_grp / group 'Task' order=data;
define bu / across '';
define tot_per / '' style(column)={just=c};
run;
How do I fix the following error?
"ERROR: There is no statistic associated with tot_per."
Thank you.
Data would be helpful.
I think this is a case where you need a dummy variable, something like...
column task_grp bu, (tot_per) dummy;
define dummy / noprint;
I could test this if you supplied some data.
Data would be helpful.
I think this is a case where you need a dummy variable, something like...
column task_grp bu, (tot_per) dummy;
define dummy / noprint;
I could test this if you supplied some data.
That works.
Will a compute block allow me to show blank cells as 0%, 0?
Or is there a better way?
Thank you.
I would format the character data cells to look exactly like I want them to look, in the data step where you create tot_per.
I don't have missing information in the data step. Only when proc report creates the table do I have blank cells due to combinations being created that don't exist in the data step. I could manually create these combinations in the data step, but that would be quite a bit of manual coding.
It wont be to hard to create the "missing" cells. I think that is easier that using CALL DEFINE espically on an across variable. Show some data.
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.