<?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 Re: reading multiple files but for each file read add a date .simialrly when reading next file again add date in SAS Programming</title>
    <link>https://communities.sas.com/t5/SAS-Programming/reading-multiple-files-but-for-each-file-read-add-a-date/m-p/216454#M39899</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Have a look at data _null_'s post here: &lt;A __default_attr="273223" __jive_macro_name="message" class="jive_macro jive_macro_message active_link" href="https://communities.sas.com/" modifiedtitle="true" title="Re: How to import several .csv files at once into SAS"&gt;&lt;/A&gt;&lt;/P&gt;&lt;P&gt;Once you have the filename in a variable then you can scan(filename,2,"_") to get the date.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Mon, 18 May 2015 13:03:58 GMT</pubDate>
    <dc:creator>RW9</dc:creator>
    <dc:date>2015-05-18T13:03:58Z</dc:date>
    <item>
      <title>reading multiple files but for each file read add a date .simialrly when reading next file again add date</title>
      <link>https://communities.sas.com/t5/SAS-Programming/reading-multiple-files-but-for-each-file-read-add-a-date/m-p/216453#M39898</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;reading multiple files but for each file read add a date .simialrly when reading next file again add date &lt;/P&gt;&lt;P&gt;eg:&lt;/P&gt;&lt;P&gt;file place in a directory : XX\zz_20150515,&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 13.3333330154419px;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; XX\zz_20150516&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 13.3333330154419px;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;SPAN style="font-size: 13.3333330154419px;"&gt;XX\zz_20150517&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;read each file and for each file read. Add date in all the records &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;acct_id , unique, date&lt;/P&gt;&lt;P&gt;------------ ----------- -------&lt;/P&gt;&lt;P&gt;1212&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; asdasd 2015&lt;SPAN style="font-size: 13.3333330154419px;"&gt;0515&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 13.3333330154419px;"&gt;1233&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; asdasd &lt;/SPAN&gt;&lt;SPAN style="font-size: 13.3333330154419px;"&gt;2015&lt;/SPAN&gt;&lt;SPAN style="font-size: 13.3333330154419px;"&gt;0515&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;3444&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; asdadad &lt;SPAN style="font-size: 13.3333330154419px;"&gt;20150516&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 13.3333330154419px;"&gt;1313&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; dsfsdfssf &lt;SPAN style="font-size: 13.3333330154419px;"&gt;20150516&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 13.3333330154419px;"&gt;4323&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; sszzsscz &lt;SPAN style="font-size: 13.3333330154419px;"&gt;20150516&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;6568&amp;nbsp;&amp;nbsp;&amp;nbsp; asddasdw&amp;nbsp; &lt;SPAN style="font-size: 13.3333330154419px;"&gt;20150517&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 13.3333330154419px;"&gt;132&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; sfdfsfsdfsd&amp;nbsp; &lt;SPAN style="font-size: 13.3333330154419px;"&gt;20150517&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;please help&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 18 May 2015 12:37:23 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/reading-multiple-files-but-for-each-file-read-add-a-date/m-p/216453#M39898</guid>
      <dc:creator>dennis_oz</dc:creator>
      <dc:date>2015-05-18T12:37:23Z</dc:date>
    </item>
    <item>
      <title>Re: reading multiple files but for each file read add a date .simialrly when reading next file again add date</title>
      <link>https://communities.sas.com/t5/SAS-Programming/reading-multiple-files-but-for-each-file-read-add-a-date/m-p/216454#M39899</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Have a look at data _null_'s post here: &lt;A __default_attr="273223" __jive_macro_name="message" class="jive_macro jive_macro_message active_link" href="https://communities.sas.com/" modifiedtitle="true" title="Re: How to import several .csv files at once into SAS"&gt;&lt;/A&gt;&lt;/P&gt;&lt;P&gt;Once you have the filename in a variable then you can scan(filename,2,"_") to get the date.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 18 May 2015 13:03:58 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/reading-multiple-files-but-for-each-file-read-add-a-date/m-p/216454#M39899</guid>
      <dc:creator>RW9</dc:creator>
      <dc:date>2015-05-18T13:03:58Z</dc:date>
    </item>
  </channel>
</rss>

