How to enable PROC REPORT use full width of page
SAS technical support confirms that PROC REPORT can not use the full width of page. It is a known bug and still has not been addressed. This post will describe
Author: T.Y.
How to reference special characters produced by RTF code via VBA
Once upon a time, I was requested to extract TFL titles, TFL layout orientation from individual RTF files into Excel file. It is not difficult as there are tons of
Three Ways (PROC FORMAT or Dynamic BY Variable or SG ANNOTATION) to Display Axis Values
It is well known that detailed visit information is usually displayed as X axis values in graphics. This leads to a problem of how to display character values in axes.
An Example Showing How to customize your GTL graph using annotation
GTL can enable you to add graphics elements to a graph using ODS Statistical Graphics (SG) annotation instructions which are stored in a SAS dataset. It enables you to separate
A simple approach to calculate most recent dosing date before start date of an AE
Sometimes, we have to calculate most recent dosing date before start of a specified adverse event. This post will introduce how to fulfill the task by applying Do-While loop. Sample
Sample SAS code covering all required knowledge of PROC REPORT
In clinical industry, almost every companied would like to use PROC REPORT procedure to develop rtf output. This post will show you tricks that will be used in PROC REPORT.
How to create Hyperlink and Bookmark using PROC RERORT
By clicking on associated hyperlink, word can direct you quickly to a specific point identified by bookmark in a word document. As a programmer, you may would like to create
How to turn off “Microsoft Excel is waiting for another application to complete an OLE action” in VBA
Sometimes, we might need to manipulate a bunch of RTF or PDF files using Excel VBA. As number of RTF or PDF files to be combined goes larger, the chance
A brief Introduction on ClinicalTrials.gov (PRS) and EU Clinical Trials Register (EudraCT)
US Food and Drug Administration Amendments Act (FDAAA) and European Medicines Agency (EMA) require that clinical trial results should be made publicly available through ClinicalTrial.gov and EU Clinical Trials Register
A VBA macro to convert all RTF files within one folder into PDF files
Once upon a time, we were required to convert all RTF files into PDF files. And there were hundreds of files which should be converted. It was obviously a headache