Hello, I am writing an import code to turn some files into SAS data sets. The data set will be updated weekly and the new files are appended to the existing data set. I am using a wildcard on the FILENAME statement but one of my fields needs to be the original file where the observation came from. I shortened the code for the sake of brevity but I can provide more details if necessary. It looks something like this: Files to be loaded: file1, file2, file3, file4 etc FILENAME files "/my/path/*file*.csv"; DATA append; format file_name $100. update_date $8.f; INFILE files lrecl=512 pad; (import code for each field goes here...) file_name = ??? This is where I need to create a field specifying the file name that each obs came from for example if the row came from file1 I would need this field to say field_name = 'file1' Is there any way for sas to do this? Also, is there a way to list everything that is in 'files' from FILENAME files "/my/path/*file*.csv"; ? thanks for your help 🙂
... View more