Page 3

A VBA macro to convert all RTF files within one folder into PDF files

T.Y. - May 13, 2018 Comments Off

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

RTF

A SAS macro to combine portrait and landscape rtf files into one single file

T.Y. - May 12, 2018 Comments Off

The day before yesterday, I posted a paper on how to combine PDF files via Excel VBA. Then I got a comment from reader who’d like to combine Portrait rtf

VBA

A VBA macro for you to retrieve name of all PDF files within a folder and then combine them together

T.Y. - May 10, 2018 5

Time from time, you may need to combine PDF file together. For example, you are not familiar with scanner and cannot scan multiple pages into one file. In this situation,

RTF SAS

Two macros that can help you easily batch run your programs

T.Y. - May 9, 2018 1

As project lead programmer, you need to re-run all programs in sequence to make sure that any updates to raw data or any revisions to programs can be reflected in

SDTM

Two Common Programming Issues When Pooling Data from Multiple Studies

T.Y. - Apr 11, 2018 Comments Off

In clinical trial industry, we need to pool data across several trials and combine data from multiple studies into a single dataset. And analyses can be run on the new

GTL

How to Add Code-Driven Graphics Elements to Your Graph

T.Y. - Apr 6, 2018 Comments Off

GTL draw statements enable you to add text, arrows (or lines), geometric shapes (such as ovals, rectangles, polylines, polygons) and images to your graph. You can also use GTL draw

Statistics

ORR (Objective Response Rate) and related statistics – Part 2 Odds Ratio

T.Y. - Dec 31, 2017 Comments Off

In last post, I described how to compute ORR (Overall Response Rate) for each group, usually treatment group in clinical trial industry. Here let’s move forward and see how to

SAS Statistics

ORR (Objective Response Rate) and related statistics – Part 1

T.Y. - Dec 31, 2017 Comments Off

For oncology studies, we need to compute ORR which stands for Overall Response Rate. It is one of efficacy endpoints for the approval of cancer drugs and biologics. And it

SAS TFL

Smart way to deal with decimal places when computing summary statistics for LB test with ROUND function

T.Y. - Sep 27, 2017 Comments Off

Several months ago, I wrote a post on how to deal with decimal places when computing summary statistics for safety assessements like LB test, EG test and VS test. Comparing

GTL

How to create and customize legend using GTL (Graphical Template Language)

T.Y. - Sep 26, 2017 3

When a plot contains grouped markers or contains lines that differ by color, marker symbol or line pattern, a legend should be added into the plot. Plus, a legend also