topic Set dataset based on the date in file name in SAS Programming

Set dataset based on the date in file name

Aske — Tue, 09 Aug 2016 10:53:32 GMT

I would like to automatically set the dataset with the newest date.

My problem is the following:

I have a folder / directory which contains datasets with a date in the file name. The date indicates when the dataset is generated. It could for instance be called a_08AUG16 or a_09AUG16. I want to be able to set the latest dataset automatically based on the date in the file name. Is that possible?

Best regards

Aske

Re: Set dataset based on the date in file name

RW9 — Tue, 09 Aug 2016 11:11:31 GMT

Let me start by saying its never a good idea to put "data" into the structural part of the dataset - either table details or column details, it makes programming so much harder, and runs up problems like this. Put data in the rows of the dataset.

Now you can use the metadata files from sashelp.vtable, basically that has the structural parts as data elements.

data _20JAN2016;
  set sashelp.class;
run;
data _14FEB2016;
  set sashelp.cars;
run;

proc sql noprint;
  select  put(max(DTE),date9.)
  into    :DTE
  from    (select *,input(strip(compress(MEMNAME,"_","")),date9.) as DTE from SASHELP.VTABLE where libname="WORK" and substr(MEMNAME,1,1)="_");
quit;

data want;
  set work._&DTE.;
run;

Re: Set dataset based on the date in file name

Kurt_Bremser — Tue, 09 Aug 2016 11:11:40 GMT

The best solution, hands down, is to use a date format in the dataset names that sorts itself, ie YYYY-MM-DD.

With the current situation, you will have to read the dataset names from sashelp.vtable (or dictionary.tables), convert the date in the dataset name to a SAS date, and retrieve the wanted observation with max(date).

Re: Set dataset based on the date in file name

Aske — Tue, 09 Aug 2016 12:19:16 GMT

Thanks for the help!