Training   Developing User Friendly SAS Macros Course Overview This course will describe approaches to developing and maintaining SAS macros that are easy to use and maintain. Some of the topics covered include: effective documentation of macro header, portable code for use with different operating systems, error and warning message handling, user friendly documentation, and keeping macros simple for debugging.   About Instructor Sy Truong is the cofounder and president of MXI (Meta-Xceed, Inc.) since 1997. MXI provides software solutions within the Pharmaceutical Industry specializing in CDISC data standards, SAS validation, electronic submission, data analysis and reporting. Sy is one of the committee members of the Bay Area SAS User Group (www.basas.com). He is a frequent contributor and presenter at PharmaSUG, WUSS, SAS Global Forum and CDISC Interchange conferences.   For pricing information and a quote for a customized training course, please contact MXI . Course Introduction SAS macros are great at automating repetitive tasks as a code generator. However, there are some features of macros that make them difficult to understand and debug. The syntax of SAS macros is similar to that of traditional SAS data step but there is a level of abstraction. To accomplish its code generating function, SAS macros add percent signs (%) and ampersand (&) in front of specified commands and variables. This layer can be confusing since it requires you to resolve the macro before understanding what is being processed. This confusion is compounded when things are nested. Macro variables can be nested by resolving into other macro variables. Macros themselves can call other macros which creates a nested looping structure. Macro code can sometimes be spaghetti code. It is therefore helpful for the user and the person maintaining the macros to make the macros user friendly.

SAS Cluster SAS Grid Cluster SAS Grid SAS SAS Cluster System SAS Cluster Servers SAS Grid Computing SAS Plugin for MS Office SAS MS Office Plugin SAS Plugin for Excel SAS Plugin for MS Word SAS Excel SAS MS Word SAS Macro Interfeace for MS Office Optimize Report Generation from CDISC Standards Generate Reports from CDISC Data SDTM Reports ADaM Reports Standard SAS Reports SAS Program Library SAS Macro Library CDISC Course CDISC Class SDTM Course SDTM Class CDISC Training CDISC Implementation Training CDISC Implementation Class MedDRA Training MedDRA Class WHO Drug Training WHO Drug Class AE Coding Training AE Coding Class Drug Coding Class Drug Coding Training DEFINE.PDF Training DEFINE .XML Training Domain Documentation Training Domain Documentation Class Data Definition Training Data Definition Class SAS Validation Training SAS Validation Class SAS System Validation Training SAS System Validation Class SAS Program Validation Training SAS Program Validation Class SAS Macro Training SAS Macro Class User Friendly SAS Macro Course User Friendly SAS Macro Training Programming Macro Training Programming Macro Class SAS Excel Course SAS Excel Training SAS MSOffice Course SAS MSOffice Training SAS MSWord Training SAS MSWord Course Change Control Training SAS Change Control Training SAS Program Change Control Training SAS Macro Change Control Training SAS Change Control Class SAS Program Change Control Class MedDRA Coding WHO Drug Coding MedDRA Coding Service WHO Drug Coding Service MedDRA Service WHO Drug Service Thesaurus Dictionary Management ADaM ADaM Consulting ADaM Service Analysis Datasets Analysis Datasets Consulting Analysis Datasets Service Annotated Case Report Form Annotated Case Report Form Consulting Annotated Case Report Form Service Annotated CRF Annotated CRF Consulting Annotated CRF Service Biostatistics Consulting Biostatistics Service CDISC ADAM CDISC ADAM Consulting CDISC ADAM Service CDISC Compliance CDISC Compliance Consulting CDISC Compliance Service CDISC SDTM CDISC SDTM Consulting CDISC SDTM Service Clinical Data Management Clinical Data Management Consulting Clinical Data Management Service CRF Design CRF Design Consulting CRF Design Service Data Management Service Design Case Report Form Design Case Report Form Consulting Design Case Report Form Service Discrepancy Management Discrepancy Management Consulting Discrepancy Management Service Edit Checks Edit Checks Consulting Edit Checks Service Electronic Submission Electronic Submission Consulting Electronic Submission Service SAS Consulting SAS Development Consulting SAS Development Service SAS Program Consulting SAS Program Service SAS Service SDTM Consulting SDTM Service Statistical Consulting Statistical Service Tables Listings and Graphs Tables Listings and Graphs Consulting Tables Listings and Graphs Service TLG Consulting TLG Service Coding Methodologies Contract Research Organizations CRO Data Library Managing Thesaurus Reconciling Dictionaries SAS Macros Table of Contents TOC Biostatistics Case Report Form Case Report Form Design Case Report Form Service CFR part 11 Clinical Data Management CRF Tabulations Custom Database Custom Database Consult Custom Database Design Custom Database Service Data Analysis Data Management Data Warehouse Design Clinical Plans Electronic case report Electronic submission FDA Submission IND Medical Device Medical Writing Ndas Prepare Patient Profile Consult Patient Profile Generator Patient Profile Service RFP SAS Consulting SAS Service SOP Consulting SOP Service Code Optimizer Data Models Data Standards Data Definition Define.xml Define.PDF Domain documentation Data Definition Documentation Coded Terminology Coded Terminology Management Coded Terminology Software SAS Format SAS Format Management CDISC Coded Terminology Coded Terms Coded Terms Coded Terms Software Controlled Terminology Control Terminology Controlled Terminology Management Control Terminology Management Control Terminology Software Controlled Terminology Software CDISC Controlled Terminology CDISC Control Terminology SAS Data Viewer Data Viewer Syview View SAS without lock SAS Dataset Viewer SAS Dataset View SAS Data View Optimize Report Generation from CDISC Standards Generate Reports from CDISC Data SDTM Reports ADaM Reports Standard SAS Reports SAS Program Library SAS Macro Library