|Date: ||Fri, 29 Sep 2000 15:51:19 -0700|
|Reply-To: ||"Deppman, Laurie M" <Laurie.Deppman@DOH.WA.GOV>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||"Deppman, Laurie M" <Laurie.Deppman@DOH.WA.GOV>|
|Subject: ||Creating SAS data sets from Excel data|
|Content-Type: ||text/plain; charset="iso-8859-1"|
Does anyone know why I got these error messages when I tried to create a SAS
data set from an excel spreadsheet? I have 39 worksheets in one excel file.
Eventually I want to concatenate all 39 sheets into one data set. Is it
necessary to create a separate SAS data set for each one or is there an
23 filename adams
24 dde 'excel|adams!r1ca:r19cbi';
26 data adamsx;
27 infile adams;
28 input age 80t 80m 80f 81t 81m 81f 82t 82m 82f 83t 83m 83f
29 84t 84m 84f 85t 85m 85f 86t 86m 86f 87t 87m 87f
30 88t 88m 88f 89t 89m 89f 90t 90m 90f 91t 91m 91f
31 92t 92m 92f 93t 93m 93f 94t 94m 94f 95t 95m 95f
32 96t 96m 96f 97t 97m 97f 98t 98m 98f 99t 99m 99f;
NOTE: The infile ADAMS is:
ERROR: DDE session not ready.
FATAL: Unrecoverable I/O error detected in the execution of the data step
Aborted during the EXECUTION phase.
NOTE: 1 record was read from the infile ADAMS.
The minimum record length was 0.
The maximum record length was 0.
NOTE: SAS went to a new line when INPUT statement reached past the end of a
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.ADAMSX may be incomplete. When this step was
stopped there were 0
observations and 4 variables.
WARNING: Data set WORK.ADAMSX was not replaced because this step was
NOTE: DATA statement used:
real time 0.05 seconds