Home page
Company Info Services Our products Publiccation Associations
CLINICAL ANALYTIC SOFTWARE SOLUTIONS SAS SOFTWARE DEVELOPMENT AND CONSULTING BIOTECH PHARMACEUTICAL EXPERTISE SAS CFR PART 11 COMPLIANCE EFFECIENCY  ACCURACY EXPEDIENCY
Training
 
Developing User Friendly SAS Macros
Live Web Training
Course Overview
This course will describe approaches to developing and maintaining SAS macros that are easy to use. Some of the topics covered include: effective documentation of macro header, portable code for use with different OS, error and warning message handling, paper and online documentation, use of nested macros and nested macro variables, and keeping macros simple for debugging.

    coupon code
 
Prerequisites
The following software is required prior to attending the class. Some of the software will be supplied by the instructor while others is required on the student's machine.

Student's Requirements

  • Windows XP 
  • Internet Explorer or Mozilla Firefox 
  • SAS version 8.12 or higher 
  • Microsoft Office: Word and Excel 

Download Available

  • Team Viewer - Desk sharing software for viewing course 

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, and SUGI conferences. He's currently writing a book for SAS Publishing entitled Becoming a SAS Clinical Trials Programmer.

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.



 
     Meta-Xceed Inc. © 2006

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