DATA Step, Macro, Functions and more

How to extract a new version of table in a library

Reply
Occasional Contributor
Posts: 9

How to extract a new version of table in a library

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.

 

Super User
Posts: 5,916

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

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.
Data never sleeps
Super User
Posts: 10,557

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

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Ask a Question
Discussion stats
  • 2 replies
  • 56 views
  • 0 likes
  • 3 in conversation