I was wandering if there are any SAS in-built tools for data Archive process. If anyone has implemented it then can you please let me know, how to implement it.
Also if there are any 3rd party tools available, can you please let me know which one might be good.
I recently did something like that. Selection is done in SAS, and then the resulting filenames are handed to the TSM (Spectrum Protect) commandline tool.
We have timestamped SAS datasets (indicating when a dataset was pulled from the production DB), and there exist business rules for when a dataset needs to go to the archive.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.