topic Proc Tabulate in SAS Procedures

Proc Tabulate

MohamedS — Sun, 24 Feb 2008 13:42:06 GMT

Hi,

I'm trying to create summary table using DI, but when I submit the report job I recieve an error "the type of name (course_name) is unkknow".

also, I downloaded the hotfix eb9bb81 to solve this problem and it is still as is. is there anyone can help in this issue.

N.B. course name is the first field name that I use. the table statement (table course_name, department*section*tot_cost;)

Re: Proc Tabulate

Cynthia_sas — Sun, 24 Feb 2008 17:39:49 GMT

Hi:
Generally, every variable used in the TABLE statement must have the variable usage DEFINED in either a CLASS or VAR statement. This is because TABULATE will build "buckets" based on the crossings of the CLASS variables and in the "buckets" it will calculate the requested statistics based on the ANALYSIS variables listed in the VAR statement.

Based on the table statement you showed:
[pre]
table course_name, department*section*tot_cost;
[/pre]
I figure that COURSE_NAME, DEPARTMENT and SECTION will be your CLASS variables, and will appear in a CLASS statement and that TOT_COST will be your ANALYSIS variable and will appear in a VAR statement:
[pre]
class course_name department section;
var tot_cost;
table course_name, department*section*tot_cost;
[/pre]

Double check your syntax to make sure your TABULATE code has CLASS and VAR statements. If you do have CLASS and VAR statements in the code and you are still having problems, then your best bet for help is to contact SAS Tech Support.

cynthia

Re: Proc Tabulate

MohamedS — Mon, 25 Feb 2008 08:17:01 GMT

Hi Cynthia,

thank you, it worked