04-22-2014 05:40 AM
I have a program in SAS Data Integration that will extract a .txt file named TBDET_MMDDYYYY (MM=Month, DD=DAY, YYYY=Year. Example TBDET_04212014) to create a new table named NEW
Below are the steps that I did:
The properties of TBDET_MMDDYYYY under File Location Tab is indicated below
Everytime I run this program, I need to edit the properties of TBDET_MMDDYYYY under File Location Tab by renaming TBDET_MMDDYYYY.txt under File name.
For example, if the latest .txt file is TBDET_04222014.txt I need to rename the file name from E:\Personal\RAW\TBDET_04212014.txt to E:\Personal\RAW\TBDET_04222014.txt.
Is there a way in SAS DI wherein I don't need to update the file name anymore everytime there is a new data? Creating a macro perhaps?
04-22-2014 06:47 AM
You said the magic word - macro (as in macro variable). Be sure to e select "Double quotes around file name" in the File Location tabs. How to set the macro variable to a proper value depends on you application.
If you wish to import multiple files in one go you might want to take a look at the loop transform (where you feed the file name from an outer job to the existing job).