DATA Step, Macro, Functions and more

reading multiple files but for each file read add a date .simialrly when reading next file again add date

Reply
Occasional Contributor
Posts: 14

reading multiple files but for each file read add a date .simialrly when reading next file again add date

reading multiple files but for each file read add a date .simialrly when reading next file again add date

eg:

file place in a directory : XX\zz_20150515,

                                    XX\zz_20150516

                                    XX\zz_20150517

read each file and for each file read. Add date in all the records

acct_id , unique, date

------------ ----------- -------

1212      asdasd 20150515

1233      asdasd 20150515

3444     asdadad 20150516

1313     dsfsdfssf 20150516

4323     sszzsscz 20150516

6568    asddasdw  20150517

132     sfdfsfsdfsd  20150517

please help

Super User
Super User
Posts: 7,991

Re: reading multiple files but for each file read add a date .simialrly when reading next file again add date

Posted in reply to dennis_oz

Have a look at data _null_'s post here:

Once you have the filename in a variable then you can scan(filename,2,"_") to get the date.

Ask a Question
Discussion stats
  • 1 reply
  • 171 views
  • 0 likes
  • 2 in conversation