Help using Base SAS procedures

import from Excel

Reply
Contributor
Posts: 20

import from Excel

Why does SAS pull in a numeric or general formatted column as character when it is formatted as something else in Excel? I am just using the general proc import:
PROC IMPORT OUT= WORK.EMPLIST
DATAFILE= "S:\emplist.xls"
DBMS=EXCEL REPLACE;
RANGE="EMP$";
GETNAMES=YES;
MIXED=NO;
SCANTEXT=YES;
USEDATE=YES;
SCANTIME=YES;
RUN;
Trusted Advisor
Posts: 2,113

Re: import from Excel

You probably need to take this to Tech Support for a definitive answer. I will hazard a couple of observations.

First, the behavior you see will vary significantly by version of SAS. SAS 9.2 is much more robust about importing Excel than is 9.1.3 than is 8.2. SAS has made many improvements with 9.2.

I think that, for general formatting, SAS looks at all or some of the observations to determine type. If there is any character in the column, then SAS brings it in as text (BTW, a leading space before a number is text)

Doc
Ask a Question
Discussion stats
  • 1 reply
  • 106 views
  • 0 likes
  • 2 in conversation