https://communities.sas.com/t5/SAS-Programming/importing-from-excel-works-but-exporting-fails-with-error-DBMS/m-p/937587#M368400 <P>Hello,&nbsp;</P> <P>I am reading yesterday's output file from the output folder. The file is in excel .xlsx format, as next step, I am comparing today's results, removing duplicates and exporting to the same folder with today's date. My import works fine, I am able to execute the comparison but when trying to download and export data, I encounter the DBMS type XLSX not valid for export. I faced this error before and I solved it but I couldn't figure out now. Suggestions appreciated!</P> <P>p.s- I tried upper and lower cases too.</P> <PRE><CODE class=" language-sas">rsubmit; proc export data=final_result2 OUTFILE = "myfolder\output\test2_&amp;today..xlsx" DBMS = xlsx REPLACE; sheet="list" ; run; endrsubmit;</CODE></PRE> <PRE><CODE class=" language-sas">202 proc export 203 data=final_result2 204 OUTFILE = "myfolder\output\test2_&amp;today..xlsx" 205 DBMS = xlsx REPLACE; ERROR: DBMS type XLSX not valid for export. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE EXPORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 206 sheet="list"; 207 run; NOTE: Remote submit to ACXIOM complete. </CODE></PRE> Tue, 30 Jul 2024 12:40:32 GMT User_2024 2024-07-30T12:40:32Z https://communities.sas.com/t5/SAS-Programming/importing-from-excel-works-but-exporting-fails-with-error-DBMS/m-p/937587#M368400 <P>Hello,&nbsp;</P> <P>I am reading yesterday's output file from the output folder. The file is in excel .xlsx format, as next step, I am comparing today's results, removing duplicates and exporting to the same folder with today's date. My import works fine, I am able to execute the comparison but when trying to download and export data, I encounter the DBMS type XLSX not valid for export. I faced this error before and I solved it but I couldn't figure out now. Suggestions appreciated!</P> <P>p.s- I tried upper and lower cases too.</P> <PRE><CODE class=" language-sas">rsubmit; proc export data=final_result2 OUTFILE = "myfolder\output\test2_&amp;today..xlsx" DBMS = xlsx REPLACE; sheet="list" ; run; endrsubmit;</CODE></PRE> <PRE><CODE class=" language-sas">202 proc export 203 data=final_result2 204 OUTFILE = "myfolder\output\test2_&amp;today..xlsx" 205 DBMS = xlsx REPLACE; ERROR: DBMS type XLSX not valid for export. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE EXPORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 206 sheet="list"; 207 run; NOTE: Remote submit to ACXIOM complete. </CODE></PRE> Tue, 30 Jul 2024 12:40:32 GMT https://communities.sas.com/t5/SAS-Programming/importing-from-excel-works-but-exporting-fails-with-error-DBMS/m-p/937587#M368400 User_2024 2024-07-30T12:40:32Z https://communities.sas.com/t5/SAS-Programming/importing-from-excel-works-but-exporting-fails-with-error-DBMS/m-p/937589#M368402 <P>What version of SAS is running on ACXIOM?</P> Tue, 30 Jul 2024 12:51:49 GMT https://communities.sas.com/t5/SAS-Programming/importing-from-excel-works-but-exporting-fails-with-error-DBMS/m-p/937589#M368402 ChrisNZ 2024-07-30T12:51:49Z https://communities.sas.com/t5/SAS-Programming/importing-from-excel-works-but-exporting-fails-with-error-DBMS/m-p/937620#M368416 SAS 9.4 <BR /> Tue, 30 Jul 2024 14:36:13 GMT https://communities.sas.com/t5/SAS-Programming/importing-from-excel-works-but-exporting-fails-with-error-DBMS/m-p/937620#M368416 User_2024 2024-07-30T14:36:13Z https://communities.sas.com/t5/SAS-Programming/importing-from-excel-works-but-exporting-fails-with-error-DBMS/m-p/937641#M368423 <P>I fixed the issue. I tried proc export out of the remote statements and it worked. thank you.&nbsp;</P> Tue, 30 Jul 2024 15:55:57 GMT https://communities.sas.com/t5/SAS-Programming/importing-from-excel-works-but-exporting-fails-with-error-DBMS/m-p/937641#M368423 User_2024 2024-07-30T15:55:57Z