Category: SASpphire 蓝宝石

ArtsyBee / Pixabay

I have met so many wonderful people along my SAS journey, they are precious like Sapphire to me.

Now I am trying to organize the common SAS functions and procedures I have used on a daily basis, summarize the different CDISC domains that I have worked on and some statistical method I have encountered.

One Factor Designs

Factorial Design allows the investigation of sets of categorical predictors, and the interaction between them. Today we will go over some basics of One Fixed Factor and One Random Factor Design. Keywords: Factor: categorical predictors Fixed Factors: Estimate the difference in means between groups defined by specified categorical predictors. e.x. ANOVA model, one measurement per subject. Random Factors: Estimate the variance…

Non-inferiority Trial

Background Movie: Based on my taste, 我不是药神 Drug Deal/Dying to Survive is one of the best movies in 2018. It was based on a true story that some cancer patients use a kind of cheap Indian medicine (Veenat 100) as a substitution of the authentic Novartis Glivec 400 to prolong their lives. Besides the touching story, Veenat 100 is a…

Interim Analysis

Background Story: Once, we need to do an Interim Analysis, I didn’t understand why we need to do it. Later I learned in Clinical Trial studies, our ultimate goal is trying to get approval for FDA submission at the end of studies. While exhausting and long progress, sometimes we perform Interim Analysis before the completed trial to access Safety, Futility,…

Open Cdisc Report

Background Story: Once my boss asked me to review an Open CDISC report for SDTM dataset packages. I wasn’t sure what to do at first. With the help of my colleagues, I gradually develop a sense of how to review the CDISC report. I’d like to share some review processes and common Open CDISC Summary from PINNACLE21.

Unix Command

Today I want to share some basic Unix commands I use recently in Putty.     Directory: Direct the path to a certain location cd /… cd – {home directory} pwd {show current working directory} Files: List current files  ls {path} ls -l {date,size, permission} Check/Change Access: Read is 4. Write is 2. Execute is 1. ls -lah xyz(u,group,everyone else)…

Variable Types in Statistics

In data science, we usually classify variables into two big types: Continuous(age), Categorical(sex). What about the variables in clinical trials/statistics? How many different types do we have? Little goal: Today we will learn the six common types of variable in statistics? How to use and present them in clinical trials?


SAS day 56: ANYALPHA  Background Story: Once we had an excel sheet with an extreme variety of date formats that don’t make sense. Is there a method to clean the data so they will be meaningful dates? Raw Data: Solutions Ideas: After observing the data structure, we notice it either starts with a letter or number. Therefore, we will apply…

Proc Export +Proc Report to Fancy Excel Output

SAS day 55 Background Story: Once we need to generate an Adverse Event listing for the medical team to review in excel, I was amazed by my colleague’s colorful output from SAS. I was just simply happy to look at the output! Example: I will use to generate the output   SAS Code:   *—————————–*; * To generate excel…

Social media & sharing icons powered by UltimatelySocial