June 2017

How to retrieve comments from word document using VBA

J.L. - Jun 29, 2017 Comments Off

Tables, figures and listings must be bundled together and sent out to Statisticians for review. They usually add some comments. Programmers need to extract those comments and put them in

SAS

Programming SAS anywhere at anytime with SAS Studio

J.L. - Jun 25, 2017 Comments Off

It is well known that SAS software is expensive and most of us cannot offord. Moreover, installation can take us a lot of time. At least it is a horible

ADaM

Introduction on how to create ADaM

J.L. - Jun 24, 2017 Comments Off

In this post, I will make an introduction on the process of creating ADaM (Analysis Data Model) , CDISC documents and then make a summary of some tips. Flowchart of

GTL

Relationship between SAS Statistical Graphics/SAS Analytical produre and Graph Template Language (GTL)

J.L. - Jun 21, 2017 Comments Off

SAS Statistical Graphics (SG) Procedures such as PROC PLOT, PROC CHART, PROC GPLOT, PROC GCHART are used by most of us when creating a graph. What we only need to

SAS TFL

Novel approach to create both two types of shift table for safety evaluations (LB, EG, VS)

J.L. - Jun 17, 2017 Comments Off

Shift table are required to be produced for safety measurements such as Laboratory evaluations, Electrocadiograms and Vital signs in almost all clinical studies. It displays the number of subjects with

Statistics

How to apply two sample test using SAS

J.L. - Jun 15, 2017 Comments Off

In clinical trial, two-sample hypothesis testing is usually applied when testing if there is a difference between two means from two different populations receiving different treatments like placebo treatment and

SAS TFL

Smart way to deal with decimal places when computing summary statistics for LB paramters

J.L. - Jun 10, 2017 1

In clinical trial, we have to develop summary tables for safety measures like vital signs and laboratory examinations. Descriptive summary statistics such as the number of observations (n), mean, standard

SAS SDTM

SDTM TV – How to consolidate all timing variables within a library into one variable

J.L. - Jun 3, 2017 1

Trial Visits (TV) dataset in the Trial Design model describe the planned visits of the study, but it is also necessary to collect corresponding actual data in Subject Visits (SV)