Hi,    I'm trying to set data in a table by reading a file. However, SAS is not able to recognize the file. Any suggestion is highly appreciated.   File: ABCD_062018 (This is monthly file with a date stamp, therefore I want to use a wild card to read the file and make it date independent)   File Location: C:\Desktop\Folder   Now in SAS I'm creating a lib as follows:   Libname Path C:\Desktop\Folder   Data Table; Set Path."ABCD_%"; Run;   Error: ABCD_% is not a valid name (I've tried replacing % by *, moving the quotes, changing to single quotes but nothing works.   Any thoughts on how to resolve this issue? ... View more

Hi All,   First off, I'm a Tableau professional finding his foot in SAS world. So if my questions are naive, I apologize in advance to the group.   I've a requirement where I have to read latest file from last from a folder. So the requirements is something like this:   Requirements: 1. Folder A stores files for sales as:            Sales_062018_06102018.txt            Sales_062018_06132018.txt            Sales_062018_06152018.txt            Sales_062018_06182018.txt   2. I've to go to the folder and pick the latest file (In this case Sales_062018_06182018.txt)   3. Any suggestions on how I should go and read the files and get the latest file? The number of files in the folder can be more than four.    Any pseudo code or code structure would be very helpful. Thank you            ... View more

Hello All,   I've started some basic coding with SAS and need help from the group on the following:   Requirement: 1. Every Monday, I've to run a SAS script to read SAS data set for the last week (Sunday to Saturday) and append to a master table, XYZ. Every Monday, last week's data needs to be extracted and appended to the master table XYZ 2. The dataset is stored as sas dataset with daily time stamp (so that I know which data row belongs to what date). Example - Sales20180701.sas7bdat, Sales20180702.sas7bdat and so on   Question: How can I read the dataset every Monday for the last week and then append it to a Master table, XYZ with a datestamp?   I apologize if the question is very basic. Thanks.      ... View more

Hi All,   I've a requirement to read files from a folder every month. So for example if I run the program in June, it should read the file from May. Likewise if I run the program in July, it should read the file from June.   The data file (Excel worksheet) is stored as: XYZ_050118 XYZ_040118 XYZ_030118   Can anyone suggest how I can read the latest file based on the "timestamp" on the file and choose the latest file every month?   Any help is greatly appreciated. Thank you!  ... View more