<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic export to excel fails due to file name already exist in SAS Programming</title>
    <link>https://communities.sas.com/t5/SAS-Programming/export-to-excel-fails-due-to-file-name-already-exist/m-p/447917#M112601</link>
    <description>&lt;P&gt;can rename the old file and generate the new excel file. or create a number next to the file.&lt;/P&gt;</description>
    <pubDate>Thu, 22 Mar 2018 19:57:50 GMT</pubDate>
    <dc:creator>radha009</dc:creator>
    <dc:date>2018-03-22T19:57:50Z</dc:date>
    <item>
      <title>export to excel fails due to file name already exist</title>
      <link>https://communities.sas.com/t5/SAS-Programming/export-to-excel-fails-due-to-file-name-already-exist/m-p/447917#M112601</link>
      <description>&lt;P&gt;can rename the old file and generate the new excel file. or create a number next to the file.&lt;/P&gt;</description>
      <pubDate>Thu, 22 Mar 2018 19:57:50 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/export-to-excel-fails-due-to-file-name-already-exist/m-p/447917#M112601</guid>
      <dc:creator>radha009</dc:creator>
      <dc:date>2018-03-22T19:57:50Z</dc:date>
    </item>
    <item>
      <title>Re: export to excel fails due to file name already exist</title>
      <link>https://communities.sas.com/t5/SAS-Programming/export-to-excel-fails-due-to-file-name-already-exist/m-p/447925#M112604</link>
      <description>&lt;P&gt;Please take the time to add some more detail to your questions. Vague question = vague answers.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;So the solution to what I'm assuming is your question, is to use FEXIST to check if the file already exists and if it does then create a new name and repeat until you&amp;nbsp;have a unique name.&amp;nbsp; A common solution is to add a datetime stamp to the end to ensure uniqueness. I'm less of a fan of this option.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;BLOCKQUOTE&gt;&lt;HR /&gt;&lt;a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/192083"&gt;@radha009&lt;/a&gt; wrote:&lt;BR /&gt;
&lt;P&gt;can rename the old file and generate the new excel file. or create a number next to the file.&lt;/P&gt;
&lt;HR /&gt;&lt;/BLOCKQUOTE&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 22 Mar 2018 20:14:18 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/export-to-excel-fails-due-to-file-name-already-exist/m-p/447925#M112604</guid>
      <dc:creator>Reeza</dc:creator>
      <dc:date>2018-03-22T20:14:18Z</dc:date>
    </item>
  </channel>
</rss>

