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;
@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.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.