Pipe it! Extract it! Build it!

smitha Krishnamurthy1 and Sofia Shamas2
1Roche Molecular Solution, 2


A process improvement tool developed using FILENAME statement with PIPE option in SAS to create study related validation tracker with key information captured from individual SAS program headers within a folder. The validation tracker is an excel document with hyperlinks to the actual RTF output and serves as a guideline for the developer and the validator during validation. Additionally, this macro creates a validation issue document in excel where we verify accuracy of the program header by comparing details of the RTF outputs listed against the actual outputs created. This macro does require the user to follow a standard header structure across all codes and execute it as a batch process. The use of PIPE option limits the code use with SAS Enterprise Guide. Macro was run in SAS 9.4.