- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 08-31-2015 01:00 AM
(2090 views)
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?
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Have you tried DMBS=ExcelCS or DBMS-PCFILES/PCFS
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
What is the error?