topic Re: How to read sas data set having date extentions in Administration and Deployment

How to read sas data set having date extentions

chirumalla — Mon, 20 Jan 2014 14:30:22 GMT

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.

Re: How to read sas data set having date extentions

LinusH — Mon, 20 Jan 2014 15:43:41 GMT

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.

Re: How to read sas data set having date extentions

data_null__ — Mon, 20 Jan 2014 16:43:09 GMT

set xyz: indsname=sas-variable-name;

Re: How to read sas data set having date extentions

pradeepalankar — Mon, 20 Jan 2014 17:58:07 GMT

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;