https://communities.sas.com/t5/SAS-Programming/How-to-read-xlsm-files-in-linux/m-p/747779#M234768 <P>XLSM is XLSX file with macros.</P> <P>Please try with DBMS=XLSX.<BR /><BR /></P> Mon, 14 Jun 2021 12:51:04 GMT Sajid01 2021-06-14T12:51:04Z https://communities.sas.com/t5/SAS-Programming/How-to-read-xlsm-files-in-linux/m-p/747773#M234767 <P>Hi all, how can we import xlsm files in linux environment. I had tried working with the proc import , but it throws error. Is there any method to do the same?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AntuMaria_1-1623673949067.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/60343i8CD4F5065C7697DE/image-size/medium?v=v2&amp;px=400" role="button" title="AntuMaria_1-1623673949067.png" alt="AntuMaria_1-1623673949067.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Mon, 14 Jun 2021 12:37:18 GMT https://communities.sas.com/t5/SAS-Programming/How-to-read-xlsm-files-in-linux/m-p/747773#M234767 AntuMaria 2021-06-14T12:37:18Z https://communities.sas.com/t5/SAS-Programming/How-to-read-xlsm-files-in-linux/m-p/747779#M234768 <P>XLSM is XLSX file with macros.</P> <P>Please try with DBMS=XLSX.<BR /><BR /></P> Mon, 14 Jun 2021 12:51:04 GMT https://communities.sas.com/t5/SAS-Programming/How-to-read-xlsm-files-in-linux/m-p/747779#M234768 Sajid01 2021-06-14T12:51:04Z https://communities.sas.com/t5/SAS-Programming/How-to-read-xlsm-files-in-linux/m-p/748106#M234912 Thanks for the solution . It works trying with DBMS=XLSX. Tue, 15 Jun 2021 12:40:46 GMT https://communities.sas.com/t5/SAS-Programming/How-to-read-xlsm-files-in-linux/m-p/748106#M234912 AntuMaria 2021-06-15T12:40:46Z