01-20-2014 09:30 AM
I need to read sas data sets having date extension like XYZ_01_01_14, XYZ_01_02_14, XYZ_01_03_14. every month data set name will change according date and month, I wan to read XYZ data set irrespective of date extension. I don't want hardcore data set name, give me sample code will read data set.
01-20-2014 10:43 AM
You'll probably need some pre-code, perhaps macro-based based logic.
This is usually very customer dependant, so it's hard to share some code that could be useful for you. Typical part of a development project.
01-20-2014 12:58 PM
select memname into :tables separated by ' ' from
dictionary.tables where substr(memname,1,3) = "XYZ";