Hello, I am a brand new user of SAS and I have a couple of questions about reading in my data. Everyday there is a new .txt or .csv file created and placed in a folder for me to read-in. The name is usually the current date (dd/mm/yy, ex. 5-22-15.txt), in which the file was created. There is a lot of data in each file. I would really like write a SAS program that would pull in each day's data and add it to the prior day's data. I could then delete that individual text file each day because it has been added to my main SAS program file. So on to my questions: 1) Is there any way that place the .txt in the temporary libref (work.xxxx) using the libname statement so that SAS can automatically deletes it once I am done with the session, or would deleting the actual .txt always be my responsibility? 2) Is there a way to set up an indexing counter that would always read-in the text file with today's date, or a function that pulls in the newest text file? Thanks for the help!!
... View more