Date: Wed, 9 Jun 2004 16:39:35 +0200
Reply-To: "Groeneveld, Jim" <jim.groeneveld@VITATRON.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Groeneveld, Jim" <jim.groeneveld@VITATRON.COM>
Subject: Re: proc import
Content-Type: text/plain; charset="iso-8859-1"
Not quite I think.
First of all your dataset AAA is never used and thus redundant. If you intended to define the variables from the Excel file that would be redundant as you get them along from Excel. Besides, the subsequent lines are interpreted as data for the INPUT statement. So nothing happens except for quite a number of error reports on reading character values into numeric variables.
Secondly, your MODEL specification under PROC ANOVA should be reversed.
Thirdly, your MEANS statement should specify one or more of Y1 to Y50, not Trata.
Fourth, you have a variable Repet with 2 different values, which you use as a CLASS variable. Has your design a repeated character? Are two subsequent records repetitions of each other (within the same subject), or are the (50) repetitions indicated by the variables Y1 to Y50? You should indicate the repeated character, if any, somewhere.
Regards - Jim.
. . . . . . . . . . . . . . . .
Jim Groeneveld, MSc.
6825 MJ Arnhem
Tel: +31/0 26 376 7365
Fax: +31/0 26 376 7305
My computer didn't see Venus better than I did, but I didn't see it in reality.
From: Gaston Zolla [mailto:gzolla@YAHOO.COM]
Sent: Wednesday, June 09, 2004 16:02
Subject: proc import
If I have for example on excel speadsheet auto.xls
with the following data and I need to use this
information in Completely Randomized Design
Trata Repet Y1 ..... Y50
1 1 5 ..... 8
1 2 6 ..... 2
2 1 8 ..... 6
2 2 4 ..... 2
. . . ..... .
. . . ..... .
Is the code that I wrote okay? because never before
use proc import
Input Trata Repet Y1 - Y50;
Proc Import datafile="auto.xls" out=auto replace;
Proc Print data=auto;
Class Trata Repet;
Model Y1 - Y50 = Trata;
Means Trata/ Duncan;
thanks in advance
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.