SAS Macro Tool Development A deeper plunge into broad ranges of oncology trials data


Life sciences



The customer is a global biopharmaceutical company developing innovative medicines in thefields of proprietary commercial products focused on addiction and schizophrenia, along witha pipeline of product candidates in development for schizophrenia, bipolar disorder,neurodegenerative disorders and cancer.


  • Difficulty in analysing input of different database structures from paper CRF, eCRF, inhouse and outsourced data management, and local investigator files
  • Existing standard programs were only study/client specific and lacked key variables for broader use
  • Non-availability of Macros for derived responses and efficacy endpoints on RECIST criteria
  • Creation of Kaplan Meier graphs for end points was going through a lot of manual programming
  • Study Integration efforts were experiencing untimely hick-ups because of no standards across studies


Icon-SAS Macro Tool Development 01




Maximized the functionalities of end output production to have submission ready outputs like Kaplan Meier graphs for PFS, OS, ORR, DOR endpoints

Icon-SAS Macro Tool Development 02




Drastic reduction in timeline to derive all the information needed in terms of content and layout

Icon-SAS Macro Tool Development 03




Creation of a standard norm in terms of handling RECIST data that improved the efficiency and consistency across all projects

Icon-SAS Macro Tool Development 04




Considerable reduction in programming resources used for manual programming