Proc Import Issues in Unix Environment

[Reeza]

See this paper:

http://www2.sas.com/proceedings/sugi31/020-31.pdf

[EarlyCode]

Ultimately still the same issue.

That paper uses the SAS LIBNAME engine EXCEL. Which I can get to run just fine on my machine. However, when operating on a UNIX environment, you have to use the XLSX engine. But options such as "mixed=yes" aren't valid options.

[ballardw]

Possibly a command line Excel to csv file converter. You can issue commands from SAS using the X command if needed.

Here were a couple of quick results searching for conversion methods

http://unix.stackexchange.com/questions/23726/convert-a-xlsx-ms-excel-file-to-csv-on-command-line-wi...

http://stackoverflow.com/questions/10557360/convert-xlsx-to-csv-in-linux-command-line

http://www.unix.com/shell-programming-and-scripting/222095-perl-script-convert-xlsx-xls-files-csv-fi...

not that I speak Unix very well

[EarlyCode]

I have never used that before, but it's worth researching.

[Reeza]

What version of SAS do you have?

[EarlyCode]

9.3, though I think it's 9.4 that runs on the UNIX server.