topic Re: Importing .xlsb file into SAS EG 6.1 in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Importing-xlsb-file-into-SAS-EG-6-1/m-p/224434#M16479 <P>Have you tried DMBS=ExcelCS or DBMS-PCFILES/PCFS</P><P>&nbsp;</P> Tue, 08 Sep 2015 16:05:51 GMT Reeza 2015-09-08T16:05:51Z Importing .xlsb file into SAS EG 6.1 https://communities.sas.com/t5/SAS-Enterprise-Guide/Importing-xlsb-file-into-SAS-EG-6-1/m-p/210375#M15777 <HTML><HEAD></HEAD><BODY><P> Hi,</P><P></P><P>I am trying to import .xlsb file into SAS EG 6.1 using proc import command.</P><P>The code works fine for xlsx file but throws an error for .xlsb file.</P><P></P><P>proc import datafile="test/import1.xlsb"</P><P>out=output_test</P><P>dbms=xlsx replace;</P><P>sheet="test1";</P><P>getnames=yes;</P><P>datarow=2;</P><P>run;</P><P></P><P>I have tried using dbms=excel also but it is not working</P><P></P><P style="font-size: 13.3333330154419px;">Can you help me know the workaround for this?</P></BODY></HTML> Mon, 31 Aug 2015 05:00:11 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Importing-xlsb-file-into-SAS-EG-6-1/m-p/210375#M15777 ankit_agrawal 2015-08-31T05:00:11Z Re: Importing .xlsb file into SAS EG 6.1 https://communities.sas.com/t5/SAS-Enterprise-Guide/Importing-xlsb-file-into-SAS-EG-6-1/m-p/224434#M16479 <P>Have you tried DMBS=ExcelCS or DBMS-PCFILES/PCFS</P><P>&nbsp;</P> Tue, 08 Sep 2015 16:05:51 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Importing-xlsb-file-into-SAS-EG-6-1/m-p/224434#M16479 Reeza 2015-09-08T16:05:51Z Re: Importing .xlsb file into SAS EG 6.1 https://communities.sas.com/t5/SAS-Enterprise-Guide/Importing-xlsb-file-into-SAS-EG-6-1/m-p/224489#M16480 <P>What is the error?</P> Tue, 08 Sep 2015 19:56:56 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Importing-xlsb-file-into-SAS-EG-6-1/m-p/224489#M16480 SASKiwi 2015-09-08T19:56:56Z