Desktop productivity for business analysts and programmers

Import xlsb SAS EG 7.1 64-bits

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 79
Accepted Solution

Import xlsb SAS EG 7.1 64-bits

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?


Accepted Solutions
Solution
‎04-25-2017 06:44 AM
Respected Advisor
Posts: 3,060

Re: Import xlsb SAS EG 7.1 64-bits

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. 

View solution in original post


All Replies
Occasional Contributor
Posts: 6

Re: Import xlsb SAS EG 7.1 64-bits

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. 

Solution
‎04-25-2017 06:44 AM
Respected Advisor
Posts: 3,060

Re: Import xlsb SAS EG 7.1 64-bits

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. 

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 129 views
  • 0 likes
  • 3 in conversation