Desktop productivity for business analysts and programmers

Importing .xlsb file into SAS EG 6.1

Reply
N/A
Posts: 1

Importing .xlsb file into SAS EG 6.1

Hi,

I am trying to import .xlsb file into SAS EG 6.1 using proc import command.

The code works fine for xlsx file but throws an error for .xlsb file.

proc import datafile="test/import1.xlsb"

out=output_test

dbms=xlsx replace;

sheet="test1";

getnames=yes;

datarow=2;

run;

I have tried using dbms=excel also but it is not working

Can you help me know the workaround for this?

Super User
Posts: 19,080

Re: Importing .xlsb file into SAS EG 6.1

Have you tried DMBS=ExcelCS or DBMS-PCFILES/PCFS

 

Super User
Posts: 3,233

Re: Importing .xlsb file into SAS EG 6.1

What is the error?

Ask a Question
Discussion stats
  • 2 replies
  • 628 views
  • 0 likes
  • 3 in conversation