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.
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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.