Problem with Excel-Import

[deleted_user]

hi,

i am quite new to the enterprise guide and have some problems getting started my first projects.

i try to import an Excel-Sheet that contains only two columns. The content of the columns is mixed: both some alphanumerical and some numerical values but without any other formats.

Example:
Row A | Row B
Z03 | 3
Z06 | (A)

What are the correct settings for importing that data?
With my try i only manage to import the content of row A correctly. Importing Row B alphanumerical values like "(A)" are not included.

What can i do ? Message was edited by: Chris55

[Doc_Duke]

Chris,

I don't know the direct answer for your question, but have some ideas for debugging.

-- What version of EGuide? EGuide 4.2 has significant improvements in Excel imports.
-- In general, SAS looks through the beginning of the data set to determine the SAS data type for an Excel column. SAS may be treating "Row B" as numeric if "(A)" is deep in the data set. EGuide 4.2 has nice overrides on the "guessing".
-- File --> Import works differently from File --> Open. Try the other and see if it works.
-- Look through the forum for "excel import" for other people's question that may have your answer.
-- Read "SAS for Dummies" on the topic (first edition for 4.1, second for 4.2+).
-- google search

Doc Muhlbaier
Duke

[deleted_user]

hi duke,

thanks for your ideas ...i currently use EG 4.1
Looking through the forums probably i have found a solution for my problem by using an IMPORT Procedure as follows:

PROC IMPORT OUT = COUNTRY_INFO
DBMS = EXCEL REPLACE
FILE = "C:\SGF2009\COUNTRY_INFO.XLS";
SHEET = "COUNTRY";
MIXED = YES;
RUN;

Unfortunenatly i get an error message "DBMS type Excel is not valid for import" while executing.

I havent found any workarounds for solving this problem so far.
Any ideas?

[ChrisHemedinger]

Here is the SAS note about that option:

http://support.sas.com/kb/13/526.html

You need SAS/ACCESS to PC Files to use PROC IMPORT with Excel files.

Chris