How to read sas data set having date extentions

[chirumalla]

Hi,

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.

[LinusH]

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.

[data_null__]

set xyz: indsname=sas-variable-name;

[pradeepalankar]

Try this:

proc sql;

select memname into :tables separated by ' ' from

dictionary.tables where substr(memname,1,3) = "XYZ";

quit;

data test;

set &tables;

run;