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.
dictionary.tables where substr(memname,1,3) = "XYZ";
quit;
data test;
set &tables;
run;
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.