Desktop productivity for business analysts and programmers

Problem with Excel-Import

Reply
N/A
Posts: 0

Problem with Excel-Import

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
Trusted Advisor
Posts: 2,114

Re: Problem with Excel-Import

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
N/A
Posts: 0

Re: Problem with Excel-Import

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?
Community Manager
Posts: 2,889

Re: Problem with Excel-Import

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
Ask a Question
Discussion stats
  • 3 replies
  • 117 views
  • 0 likes
  • 3 in conversation