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?
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).
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.