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
Comments: To: Gaston Zolla <gzolla@YAHOO.COM>
Content-Type: text/plain; charset="iso-8859-1"

Hi Gaston,

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.
Biostatistician
Science Team
Vitatron B.V.
Meander 1051
6825 MJ  Arnhem
Tel: +31/0 26 376 7365
Fax: +31/0 26 376 7305
Jim.Groeneveld@Vitatron.com
www.vitatron.com

My computer didn't see Venus better than I did, but I didn't see it in reality.

[common disclaimer]


-----Original Message-----
From: Gaston Zolla [mailto:gzolla@YAHOO.COM]
Sent: Wednesday, June 09, 2004 16:02
To: SAS-L@LISTSERV.UGA.EDU
Subject: proc import


Hi all!!!!

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

Data AAA;
Input Trata Repet Y1 - Y50;
Cards;
Proc Import datafile="auto.xls" out=auto replace;
Proc Print  data=auto;
Proc Anova;
Class Trata Repet;
Model Y1 - Y50 = Trata;
Means Trata/ Duncan;
Run;

thanks in advance

Gaston





__________________________________
Do you Yahoo!?
Friends.  Fun.  Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/