Attempting to split data set by specific data to run proc ttest. Keep getting errors.

[MarvelJJ]

I am attempting to test the actual average goal differential of the East conference is different form that of the West conference with proc ttest.  I was able to get it to work in R (I can include my code for that if needed).  I don't know if I am not splitting the data correctly into east and west or if something else is wrong with my code.

data work.NHL1819;
set work.Hockey;
run;

data work.hockey;
	set work.nhl(where=(Conference='Eastern'));
run;
data work.hockey;
	set work.nhl(where=(Conference='Western'));
run;

proc ttest h0=0 side=u;
	class Eastern;
	var DIFF;
run;

proc ttest h0=0;
	class Eastern;
	var DIFF;
Run;

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

72

73 proc ttest h0=0 side=u;

74 class Eastern;

ERROR: Variable EASTERN not found.

75 var DIFF;

76 run;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE TTEST used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

77

78 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

90

[PGStats · Accepted solution]

Looks like you are trying to do:

proc ttest h0=0 side=u data=NHL1819;
	class Conference;
	var DIFF;
run;

[MarvelJJ]

Thank you!  I am still pretty novice, so sometimes I make things harder than they should be.