https://communities.sas.com/t5/ODS-and-Base-Reporting/ods-excel-ERROR-ZIP-entry-duplicate-name-rels-rels/m-p/651028#M24129 <P>HI Kurt,</P><P>The OS is UNIX server. I am using SAS EG 8.2 . And i tried the test code you shared after changing the file path. I am still getting the sam eerror. Thanks!!</P> Wed, 27 May 2020 10:22:48 GMT Lazygeek 2020-05-27T10:22:48Z https://communities.sas.com/t5/ODS-and-Base-Reporting/ods-excel-ERROR-ZIP-entry-duplicate-name-rels-rels/m-p/651016#M24127 <P>Hi ,</P><P>&nbsp;</P><P>I am trying to use ODS excel to have a dataset written to excel as is. I had tried proc export it works but has got some formatting issues. So i thought of trying ODS excel.</P><P>Below is my test code : Any suggestions/ solutions much appreciated.</P><P>&nbsp;</P><P>ods _all_ close;<BR />data _null_;<BR />x "mkdir -p /RiskModel4/Projects/ALTA_2020/IPT/regdata/sample329/ARM/Log/Checks";<BR />x "chmod -R 777 /RiskModel4/Projects/ALTA_2020/IPT/regdata/sample329/ARM/Log/Checks";<BR />run;<BR />ods excel file="/RiskModel4/Projects/ALTA_2020/IPT/regdata/sample329/ARM/Log/Checks/temptest2.xlsx" options(start_at="3,3"<BR />frozen_headers="5"<BR />frozen_rowheaders="3"<BR />autofilter="1-5"<BR />sheet_name="Sales Report"<BR />row_repeat="2"<BR />embedded_titles="yes");<BR /><BR />proc print data=lib.REGDATA2_T3C_329;<BR />title "Test";<BR />run;<BR /><BR />ods excel close;</P><P>In the&nbsp; log i get the below erorr</P><P>ERROR: ZIP entry duplicate name: _rels/.rels.</P><P>&nbsp;</P> Wed, 27 May 2020 09:09:01 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/ods-excel-ERROR-ZIP-entry-duplicate-name-rels-rels/m-p/651016#M24127 Lazygeek 2020-05-27T09:09:01Z https://communities.sas.com/t5/ODS-and-Base-Reporting/ods-excel-ERROR-ZIP-entry-duplicate-name-rels-rels/m-p/651025#M24128 <P>Which SAS version are you on, and which operating system?</P> <P>A quick test:</P> <PRE><CODE class=" language-sas">ods excel file="/folders/myfolders/test.xlsx" options( start_at="3,3" frozen_headers="5" frozen_rowheaders="3" autofilter="1-5" sheet_name="Sales Report" row_repeat="2" embedded_titles="yes" ) ; proc print data=sashelp.class; title "Test"; run; ods excel close;</CODE></PRE> <P>on SAS UE caused no visible problem in the log, and the file could be opened with LibreOffice (Mac). It might be something in your data.</P> Wed, 27 May 2020 10:01:51 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/ods-excel-ERROR-ZIP-entry-duplicate-name-rels-rels/m-p/651025#M24128 Kurt_Bremser 2020-05-27T10:01:51Z https://communities.sas.com/t5/ODS-and-Base-Reporting/ods-excel-ERROR-ZIP-entry-duplicate-name-rels-rels/m-p/651028#M24129 <P>HI Kurt,</P><P>The OS is UNIX server. I am using SAS EG 8.2 . And i tried the test code you shared after changing the file path. I am still getting the sam eerror. Thanks!!</P> Wed, 27 May 2020 10:22:48 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/ods-excel-ERROR-ZIP-entry-duplicate-name-rels-rels/m-p/651028#M24129 Lazygeek 2020-05-27T10:22:48Z https://communities.sas.com/t5/ODS-and-Base-Reporting/ods-excel-ERROR-ZIP-entry-duplicate-name-rels-rels/m-p/651128#M24133 <P>Show your full log please.&nbsp;</P> Wed, 27 May 2020 16:18:06 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/ods-excel-ERROR-ZIP-entry-duplicate-name-rels-rels/m-p/651128#M24133 Reeza 2020-05-27T16:18:06Z https://communities.sas.com/t5/ODS-and-Base-Reporting/ods-excel-ERROR-ZIP-entry-duplicate-name-rels-rels/m-p/717772#M24851 <P>Did you get solution for this problem? I am exactly facing some issues in my new organization and not sure if this is related to SAS package/they have disabled few features etc?</P><P>&nbsp;</P><P>&nbsp;</P><P>Cheers,</P> Tue, 09 Feb 2021 03:03:50 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/ods-excel-ERROR-ZIP-entry-duplicate-name-rels-rels/m-p/717772#M24851 SASuser1987 2021-02-09T03:03:50Z https://communities.sas.com/t5/ODS-and-Base-Reporting/ods-excel-ERROR-ZIP-entry-duplicate-name-rels-rels/m-p/717773#M24852 Did you get solution for this problem? I am exactly facing some issues in my new organization and not sure if this is related to SAS package/they have disabled few features etc? Tue, 09 Feb 2021 03:04:18 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/ods-excel-ERROR-ZIP-entry-duplicate-name-rels-rels/m-p/717773#M24852 SASuser1987 2021-02-09T03:04:18Z https://communities.sas.com/t5/ODS-and-Base-Reporting/ods-excel-ERROR-ZIP-entry-duplicate-name-rels-rels/m-p/717900#M24853 <P>This has likely to do with the SAS version being used. Please show the result of the following code:</P> <P>%put NOTE: &amp;sysvlong4;</P> <P>&nbsp;</P> <P>ODS EXECL destination is production since:&nbsp;</P> <DIV id="app" class="app h-full ng-scope" aria-hidden="false"> <DIV class="app-wrapper ng-scope"> <DIV id="app-bottom-wrapper" class="app-b-wrapper"> <DIV id="document-panel" class="pos-r h-full" aria-hidden="false"> <DIV class="overflow-h ng-scope"> <DIV id="document" class="document scrollable ng-scope" role="main"> <DIV id="pageContent" class="document-body wrapper" lang="en" tabindex="0" aria-live="polite"> <DIV class="xis-eDocBody ng-scope"> <DIV id="n14c8glgh3j7hxn1b1byjs3sqnvz" class="xis-topic"> <DIV id="n0fmlrozdoz9e0n1o33ikqbsjgz6" class="xis-subTopic"> <DIV id="n1lzki80nz2r1jn137noiaw2bi96" class="xis-subSubTopic"> <DIV id="n1mdp1rukur9rsn1x3iykms09j2f" class="xis-topicContent"> <DIV id="p14aac2ylceycfn1o8qck07mtcif" class="xis-paragraph"> <DIV id="n0u8mfp6z8oti9n1o9r18r53lg8f" class="xis-paraLeadIn">SAS 9.4M3 (July 2015) has these enhancements:</DIV> </DIV> <DIV class="xis-listUnordered"> <UL> <LI> <DIV id="n0u9q14k1cd1sun1wrlvg54qaknk" class="xis-item"> <DIV id="p1s3bt5meyvcecn12zle1ux1i89d" class="xis-paraSimpleFirst">Support for Microsoft Excel that uses the ODS EXCEL statement.</DIV> </DIV> </LI> </UL> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> Tue, 09 Feb 2021 14:08:54 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/ods-excel-ERROR-ZIP-entry-duplicate-name-rels-rels/m-p/717900#M24853 BrunoMueller 2021-02-09T14:08:54Z https://communities.sas.com/t5/ODS-and-Base-Reporting/ods-excel-ERROR-ZIP-entry-duplicate-name-rels-rels/m-p/718499#M24859 <P>Hey, sorry for the delayed response. I did not dig much into the issue further as one of my teammate had found a work around. We used SAS for data prep and we used VBA for creating reports that we needed.</P> <P>But i think there are some issues while working on UNIX grid through SAS EG on windows platform.&nbsp;</P> <P>Try using the same code on BASE SAS on windows OS.</P> Thu, 11 Feb 2021 07:55:56 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/ods-excel-ERROR-ZIP-entry-duplicate-name-rels-rels/m-p/718499#M24859 Lazygeek 2021-02-11T07:55:56Z https://communities.sas.com/t5/ODS-and-Base-Reporting/ods-excel-ERROR-ZIP-entry-duplicate-name-rels-rels/m-p/724361#M24895 Note: 9.04.01M0P06192013 Mon, 08 Mar 2021 05:46:17 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/ods-excel-ERROR-ZIP-entry-duplicate-name-rels-rels/m-p/724361#M24895 SASuser1987 2021-03-08T05:46:17Z https://communities.sas.com/t5/ODS-and-Base-Reporting/ods-excel-ERROR-ZIP-entry-duplicate-name-rels-rels/m-p/724405#M24896 <P>That is the 7+ years old M0. Upgrade ASAP.</P> Mon, 08 Mar 2021 07:25:07 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/ods-excel-ERROR-ZIP-entry-duplicate-name-rels-rels/m-p/724405#M24896 Kurt_Bremser 2021-03-08T07:25:07Z