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

MarvelJJ — Sat, 03 Aug 2019 03:11:39 GMT

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;

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

78 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

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

PGStats — Sat, 03 Aug 2019 03:58:15 GMT

Looks like you are trying to do:

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

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

MarvelJJ — Sat, 03 Aug 2019 04:02:41 GMT

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

topic Re: Attempting to split data set by specific data to run proc ttest. Keep getting errors. in SAS Programming

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

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

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