Use Cases

Here is a list of some use cases which can be realized by using the Cmdlets4Sas:

• Testing
  • Unit Tests
  • Stress Testing (spawn multiple server sessions and create heavy IO usage or network traffic)
  • Regression Tests (e.g. submit SAS code to a SAS 9.1 server and compare the results with migrated SAS code from a SAS 9.3 server)
  • Platform Tests (verify that your SAS macro executes successfully on a Workspace Server, Pooled Workspace Server and Stored Process Server)
• SAS metadata
  • query SAS metadata objects (e.g. for documentation)
  • extract metadata like a Stored Process and store it in a source control system like SVN, GIT or TFS
  • identify the metadata delta between the testing and the productive system
  • synchronize/compare metadata users with Active Directory or LDAP information
  • auditing (which users and groups are authorized to read/write specific metadata objects like Tables, Folders, ...)
• Software deployment
  • with one script you may deploy scripts, data, format catalogs and more to multiple servers on different machines. You may also execute SAS code to generate custom SAS formats on each server.
  • automate deployment from testing system to production (e.g. download all SAS programs from a folder in the testing environment, push all files into a source control system and upload all program files to the production environment)
• Continuous Integration
• Documentation
  • Documentation of SAS macros, metadata objects, formats, ...
  • Download SAS macros and scan the code
    • extract documentation from comment headers
    • scan for keywords like "TODO", "BUG"
• Creation of static reports. Save reports e.g. in SharePoint
• Scheduling (PowerShell scripts can be scheduled easily)
  • data quality checks (execute a script that tries to open every SAS dataset on the server to find corrupted SAS datasets)