BookmarkSubscribeRSS Feed
Marilyn
Calcite | Level 5
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;
1 REPLY 1
Doc_Duke
Rhodochrosite | Level 12
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

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1010 views
  • 0 likes
  • 2 in conversation