topic Re: proc tabulate problem unknown name in SAS Programming

proc tabulate problem unknown name

newbie69 — Sat, 15 Oct 2022 20:01:55 GMT

Hi,

I coded some really easy code but I always got the error "The type of the name(c) is unknown". could be the reason that there are some missing values in the column c? thanks for help 🙂

proc tabulate data = in;
class class1;
var var1;
table a, b*c;
quit;

Re: proc tabulate problem unknown name

Astounding — Sat, 15 Oct 2022 20:54:33 GMT

All variables being used in a table must first appear in a CLASS or VAR statement.

At the same time, variables not being used such as CLASS1 and VAR1 should not appear.

You will need to understand the purpose of CLASS and VAR.

Re: proc tabulate problem unknown name

ballardw — Sat, 15 Oct 2022 21:38:26 GMT

@newbie69 wrote:

Hi,

I coded some really easy code but I always got the error "The type of the name(c) is unknown". could be the reason that there are some missing values in the column c? thanks for help 🙂

If you have some missing values for VARIABLE C (SAS data sets have variables, not columns) and decide to use it as a CLASS variable then the default behavior by Tabulate is to drop the entire observation from the report. If you use C as a VAR variable, requesting a statistic like Sum or mean, then the missing values are ignored in the summary.

But nothing much is going to happen until you decide if B and C are Class or Var variables though the way you have B it pretty much should be a Class variable.