topic Re: proc report error: There is no statistic associated with tot_per in SAS Procedures

proc report error: There is no statistic associated with tot_per

gzr2mz39 — Tue, 21 Jan 2014 23:42:33 GMT

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.

Re: proc report error: There is no statistic associated with tot_per

data_null__ — Wed, 22 Jan 2014 00:00:07 GMT

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.

Re: proc report error: There is no statistic associated with tot_per

gzr2mz39 — Wed, 22 Jan 2014 00:38:03 GMT

That works.

Will a compute block allow me to show blank cells as 0%, 0?

Or is there a better way?

Thank you.

Re: proc report error: There is no statistic associated with tot_per

data_null__ — Wed, 22 Jan 2014 01:47:47 GMT

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.

Re: proc report error: There is no statistic associated with tot_per

gzr2mz39 — Wed, 22 Jan 2014 18:27:36 GMT

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.

Re: proc report error: There is no statistic associated with tot_per

data_null__ — Wed, 22 Jan 2014 18:40:27 GMT

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.