BookmarkSubscribeRSS Feed
DJ
Calcite | Level 5 DJ
Calcite | Level 5
Hi
I need to import an excel file. My excel file contains column which has numeric as well as character values. Alhough I have mentioned "MIXED=YES", the column is read as numeric so my character values became period(.). I know that sas will read first some rows and decide the type of variable.

Is there any proc import statement which tells sas to scan all the values and then decide variable type???

Note: I dnt want to change my registry for this.

Thanks in advance.
DJ
4 REPLIES 4
Doc_Duke
Rhodochrosite | Level 12
The way you change it is by changing the "typeguessrows" parameter in the registry. How you do it is SAS version dependent. Search support.sas.com for it and your SAS version. Message was edited by: Doc@Duke
DJ
Calcite | Level 5 DJ
Calcite | Level 5
Thanks for reply.

I am using SAS v9.2 and I dnt want to change registry settings for this. I am searching an option like GUESSROWS= for importing excel spread sheet. This option works fine with other file types.

any thoughts???
Doc_Duke
Rhodochrosite | Level 12
Other suggestions: I'm afraid that you are outta luck. Because SAS uses Micro$oft tools to read Excel, you have to do it the Micro$oft way.

[I hate doing it this way as it can't be controlled through programing and is not portable, but I think that we are stuck with it.] Message was edited by: Doc@Duke
DJ
Calcite | Level 5 DJ
Calcite | Level 5
Thanks anyway for your input.

DJ

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
  • 4 replies
  • 1467 views
  • 0 likes
  • 2 in conversation