Profiling SAS Programs

[sasstar]

We are trying to help users do a mass movement of the code from a legacy data system to the new data supply chain. In that reference we are looking to see if there is any SAS Utility / Command / Product that can profile the program for data connections, dataset names, attributes within the dataset and attribute details, and formulae used within the program.

The idea is to run many programs through this and quickly get a output or report for us to review.

Any suggestions  please let us know.

[RW9]

Yes, if your running SAS 9.2 upwards you can use proc scaproc:

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a003199745.htm

This is a source code analyser.  My recommendation however is to have a migration plan whereby code is assessed based on requirements, otherwise you are just dumping all the old system - which may not be appropriate to the new system - into your new system - hence ruining any chance of the "clean slate".  Migration should always be a part of any new system plan (you do have plan for the new system, processes, tools, validation etc.?) and as that is quite a rarity its a really good chance to "do things right".