BookmarkSubscribeRSS Feed
Quentin
Super User

Hi All,

I'm reading Excel 2003 files using SAS 9.3 on 64 bit linux, and have PC Files Server.

I would like to replicate the functionality of the  mixed=YES option which is available when using the EXCEL engine (causes an Excel column which is a mix of character and numeric cells to be imported as a character variable, with all values maintained, rather than a numeric variable ,with character values set to null).

I've been reading the docs, but can't see a way to do this.  (Unless perhaps changing registry keys ImportMixedTypes=Text and TypeGuessRows=0 could help, if I could get access to that???).

Is there a way to read an Excel file from SAS running on linux, and avoid the problem of having disappearing character data when SAS or the ACE engine or whatever guesses incorrectly that a column is all numeric?  At this point, I'd be happy even if I could just force *every* column to be imported as character.  But it seems like the limitation is with the ACE engine, so things like DBSASTYPE can't help.

Thanks,

-Q.

BASUG is hosting free webinars Next up: Jane Eslinger presenting PROC REPORT and the ODS EXCEL destination on Mar 27 at noon ET. Register now at the Boston Area SAS Users Group event page: https://www.basug.org/events.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Discussion stats
  • 0 replies
  • 874 views
  • 0 likes
  • 1 in conversation