Category: SASpphire 蓝宝石

ArtsyBee / Pixabay

I have met so many wonderful people along my SAS journey, they are precious like Sapphire to me. Thanks to Wan, 0, Renee5, 77, 99, Little Rain family,  David,  Yue, Vincent, Mounika, Jie Chen, Charlie, Lemeng. P, June, Tony.L, Bonnie.B, Kevin Gu,  Shirish. N, XueyingJ, Jillian. P, Steve, Ocean, Jenny, Daniel.H, John W, Henry G, Xu lan, Ju Zhang, Yao Lei, Joe Wang  …. :)

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.

SDTM.VS

SDTM day 6: Vital Sign Introduction: the Vital Sign domain captures all the measurements of body’s most basic functions, such as height, weight, blood pressure, heart rate… VS is a critical dataset in Drug Safety Analysis.

SDTM.EX

SDTM Day 5: SDTM.EX   Introduction: Exposure dataset contains the details of subjects’ study treatment information, it is one of the key safety datasets, and it is critical to efficacy analysis. The EX domain is intended for “protocol-specified study treatments” including placebo dosing. The EX dataset would present a complete and accurate of subjects’ exposure in one record per constant dosing to the reviewers.

SDTM.AE

SDTM Day 4 : SDTM.AE Adverse Event is an event that results in unintended harm to the patient by an act of commission or omission rather than by the underlying disease or condition of the patient, thus AE Dataset is very important to Safety analysis for drug testing. It captures Adverse Event dates and various Adverse Event information for each patient. The…

SAS LOCF

SAS Day 18: LOCF   Background: Clinical trial studies often spanned several years. What happens if patients did not participate the check such as Vital Sign(blood pressure, weight) or Lab value(white blood cell count, red blood cell count) on some of the time points and caused the missing data?  The pharmaceutical industry standard method for imputing missing data is LOCF (Last Observation…

SAS Proc Phreg

SAS day 17: Proc Phreg   One day, my boss took a glance at a table with Hazard Ratio and Median Survival Time then he told me the program set the reference group in Proc Phreg flipped. It turns out he was correct after validating the program. However, I was very curious about how did he figure it out by an…

SAS 11.11

In China, 11.11 is Single’s Day. I found this day very interesting, although 1111 looks like a solitude date on the calendar. It is not! It has a prime factorization 1111=101*11,  and both 11 and 101 are primes. Therefore I think 1111 is a cute number and a Prime relationship day! Some people may be like Composite Numbers, always have…

SDTM LB2

SDTM Day 3 : LB, Laboratory Dataset   Last Time we introduced SDTM.LB for laboratory Test Results in Finding General Observation Class and Showed an example of how to merge with SV(Subject Visit) to get Epoch. SDTM.LB is one of the most crucial datasets for Drug Safety Analysis, it could be challenging due to the vast amount of records. This…

SAS Proc SQL 1

SAS Day 16: Proc SQL 1 Case When Problem: Suppose we need to merge the SDTM.VS (Vital Sign) dataset with SDTM.SE (Subject Element) for Epoch Infomation. We will assign the EPOCH to VS if the VSDY is between SESTDY and SEENDY.  Example: Usubjid=TF-001-001-001, VISIT=SCREENING, VSDY=-6, EPOCH=SCREENING   Background: SAS Merge is perfect for 1 to 1 merge or many to 1…

SAS Proc Compare

SAS Day 15: Proc Compare   Problem: Suppose we need to compare the dataset Prod and QC.   Background: We use Proc Compare to compare the value of two datasets. The report will give us the summary of two dataset.  Proc compare has many options, the ones I like the most are: Criterion, Var…. With, Listall, Id, Out. Criterion: Set…

SDTM QS

SDTM Day 2: QS Background: As the novice treatments for Cancer therapy have been developed, not only we care about prolonging the lives of patients, scientists also put their endeavor to improve the life qualities. SDTM.QS is designed for capturing the patients’ questions info. Definition: QS domain is a questionaries domain that contains a variety of patient information about different questionnaires. Such…

Social media & sharing icons powered by UltimatelySocial