topic Re: Ttest ERROR: The CLASS variable does not have two levels. in SAS Programming

Ttest ERROR: The CLASS variable does not have two levels.

AaronJ — Fri, 26 May 2017 17:07:14 GMT

I am running PROC Ttest withe following code:

PROC IMPORT DATAFILE=FILEREF
DBMS=XLSX
OUT=WORK.IMPORT;
GETNAMES=YES;
RUN;
data AllEvents;
set import;

RUN;
if Phase=1;
logVWC=log(VWC);

proc ttest cochran ci=equal umpu;
Class Phase;
Var logVWC;
run;

SAS gives me the following error message: ERROR: The CLASS variable does not have two levels.

In the Excel file that is imported in the first statement, Phase variables are 1 and 2, so it definitely has 2 and only 2 levels.

any insights would be appreciated

Re: Ttest ERROR: The CLASS variable does not have two levels.

PaigeMiller — Fri, 26 May 2017 17:21:42 GMT

@AaronJ wrote:

I am running PROC Ttest withe following code:

PROC IMPORT DATAFILE=FILEREF
DBMS=XLSX
OUT=WORK.IMPORT;
GETNAMES=YES;
RUN;
data AllEvents;
set import;

RUN;
if Phase=1;
logVWC=log(VWC);

proc ttest cochran ci=equal umpu;
Class Phase;
Var logVWC;
run;

SAS gives me the following error message: ERROR: The CLASS variable does not have two levels.

In the Excel file that is imported in the first statement, Phase variables are 1 and 2, so it definitely has 2 and only 2 levels.

any insights would be appreciated

SAS doesn't care about the Excel file that is imported. SAS only cares about WORK.ALLEVENTS. What is in WORK.ALLEVENTS, how many levels does PHASE have in WORK.ALLEVENTS?

Well, I think I know the answer because in your code you have

if Phase=1;

which means that the variable PHASE in WORK.ALLEVENTS has only one level ... it only has PHASE=1

Re: Ttest ERROR: The CLASS variable does not have two levels.

AaronJ — Fri, 26 May 2017 17:27:02 GMT

thanks, i think you and i caught that at the same time. I tried to delete this post, but SAS told me i didn't have sufficient privileges.
Again, thanks for pointing out the error.