topic Re: Proc ttest output? in SAS Programming

Proc ttest output?

Maisha_Huq — Mon, 18 May 2015 19:45:05 GMT

Hi:

Is there a way to create an output dataset from a proc ttest?

Thank you!

Re: Proc ttest output?

stat_sas — Mon, 18 May 2015 20:00:29 GMT

Put

ods output ttests=ttests;

before proc ttest

then

proc print data=ttests;

run;

Re: Proc ttest output?

Maisha_Huq — Tue, 19 May 2015 13:06:05 GMT

Thanks! if I do a proc contents, however, it tells me that the dataset doesn't exist. Is there no way, then, to create a data set from a proc ttest?

Is there another way to do a ttest and create an output dataset?

778 ods output ttests=ttest;

779 proc ttest data=sample_amp;

780 class control ;

781 var fns ;

782 run;

NOTE: The data set WORK.TTEST has 2 observations and 6 variables.

NOTE: PROCEDURE TTEST used (Total process time):

real time 28.54 seconds

cpu time 1.29 seconds

783 proc contents data =ttests varnum; run;

ERROR: File WORK.TTESTS.DATA does not exist.

NOTE: Statements not processed because of errors noted above.

NOTE: PROCEDURE CONTENTS used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

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

Re: Proc ttest output?

PaigeMiller — Tue, 19 May 2015 13:47:34 GMT

proc contents data =ttests varnum; run;

With the code you used, the data set is named ttest and not ttests

Re: Proc ttest output?

SteveDenham — Wed, 20 May 2015 12:06:58 GMT

As Paige points out, the dataset is named ttest.

I have always found it unusual that the equals sign in the ODS OUTPUT statement works exactly the opposite to the way I was taught. Here it assigns left to right, and I had always been taught 'right to left': whatever is on the left hand side already exists and is assigned to the right hand side. It still catches me at least half of the time when I am using a new table to dataset output statement.

Steve Denham

Re: Proc ttest output?

Rick_SAS — Thu, 21 May 2015 14:52:03 GMT

Steve,

Try thinking of it as akin to the syntax used to specify a data set in a SAS procedure. In the DATA= option, the OUT= option, the OUTEST= option, etc,the name of the data set is specified on the right. It doesn't matter if the data already exist (DATA=) or if the syntax will create a new data set (OUT=).