I am a student and new to SAS. I have a pretty large dataset in Excel and I am trying to duplicate some analyses my advisor ran after typing her dataset right into excel.
This is how I imported my data from Excel:
PROC IMPORT OUT= WORK.dissertation
DATAFILE = "C:\Documents and Settings\Me\My Documents\dissertation.xls"
DBMS=EXCEL REPLACE; stopover;
SHEET="Sheet1;
GETNAMES=YES;
MIXED=NO;
SCANTEXT=YES;
USEDATE=YES;
SCANTIME=YES;
This is her data statements that she ran before doing ANOVAS:
DATA rate0 ;
INFILE 'H:\Data\ms-ratings-dats.TXT'' ;
INPUT var1 1-3 var2 5 var3 7-8 var4 10-12 var5 14 var6 16 var7 18 var8 20;
From there, it looks like she sets the value of some of the variables and then runs the ANOVA.
Is there a comparable INFILE statement I should be running with my Excel data that would make my data ready for analysis?
eta: when I just replace the TXT file name with my excel file, I get errors; it reads none of the variables.
Message was edited by: trb