topic Re: How to extract a new version of table in a library in SAS Programming

How to extract a new version of table in a library

Pandu — Thu, 19 Jul 2018 06:28:29 GMT

Hi,

I have a library called datatime. In this library i have a dataset names like

data_history_collection_01

data_history_collection_02

data_history_collection_03

data_history_collection_04

data_history_collection_05

data_history_collection_06

data_history_collection_07

Problem: every month the above table is generating with new version.

Solution:I need to extract the new version of dataset when ever its creates. that means recent dataset.

Thanks.

LinusH — Thu, 19 Jul 2018 06:39:15 GMT

What do you mean by extract?
What have you tried so far?
A starting point could be exploring SASHELP.VTABLE and try to build some macro logic.

Kurt_Bremser — Thu, 19 Jul 2018 07:40:37 GMT

Retrieve the last dataset name from dictionary.tables:

proc sql noprint;
select max(memname) into :memname
from dictionary.tables
where libname = 'DATATIME';
quit;

After that, use &memname where needed.