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).
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.