topic Re: Import xlsb SAS EG 7.1 64-bits in SAS Enterprise Guide

Import xlsb SAS EG 7.1 64-bits

ayin — Thu, 20 Apr 2017 01:30:42 GMT

Have: a xlsb file.

Want: import part of the data to SAS EG.

Code used:

%macro Import;
			proc import datafile = "&_folderpath&_filepath&_filename" /* pre-defined, no error here */
						out =  work.test
						replace
						dbms= xlsb; /* changes were made here*/
						range='Sheet1$A3:Z900000'n;
						getnames=yes;
			run;
%mend Import;
%Import;
run;

One error reported:

ERROR: DBMS type XLSB not valid for import.

Tried to change the code to

dbms= ExcelCS;

One error reported:

ERROR: Statement or Option "GETNAMES" not valid for EXCELCS IMPORT.

The column names come from A3:Z3. Definitely need it.

How to fix the codes?

Re: Import xlsb SAS EG 7.1 64-bits

CliftonDenning — Thu, 20 Apr 2017 16:07:06 GMT

Have you tried with dbms=excelcs? Getnames unfortunately isn't supported with that dbms from what I can see.

You could specify the range to ensure you have the right variable columns with range='a5:e21'n for example. Alternatively if you can have the range named it works even better.

Re: Import xlsb SAS EG 7.1 64-bits

SASKiwi — Thu, 20 Apr 2017 20:05:45 GMT

What about DBMS = EXCEL or XLS? If you have the bitness problem then you can download the 64-bit ACE engine software from Microsoft as an alternative to using the SAS PC File Server.