topic Proc Import for Excel files in SAS Procedures

Proc Import for Excel files

DJ — Thu, 14 Jan 2010 01:05:33 GMT

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

Re: Proc Import for Excel files

Doc_Duke — Thu, 14 Jan 2010 02:12:13 GMT

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

Re: Proc Import for Excel files

DJ — Thu, 14 Jan 2010 17:29:16 GMT

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???

Re: Proc Import for Excel files

Doc_Duke — Thu, 14 Jan 2010 18:53:53 GMT

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

Re: Proc Import for Excel files

DJ — Fri, 15 Jan 2010 17:30:37 GMT

Thanks anyway for your input.

DJ