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.

SAS rename

SAS Day 52 Once I use SAS proc import  a Special Adverse Event dataset, everything looks good, except the variable name was directly from excel and has space and special characters like “/” (EOI/ Search)  Little Challenge: How to Rename a variable with space or special characters? Basic Rename Syntax: *1. within dataset data a; set a; rename old_name=new_name; run;…


ADaM day 7 ADDV protocol deviation dataset identifies occurrences of sponsor-defined deviations, which is a list specified for every study.  For example, the description of deviation can be Positive Drug Screen, PK labs not drawn in the proper window. A Sample ADDV Dataset key variables:subjid, dvstdt, dvcatcd, dvdeter, dvdesc , dvdact, dvact1, dvtype, dvstype. Key variable indications: dvcatcd=”DV Category Code”…

Proc Contents

SAS day 51:  Proc Contents Background story: One day, we need to search for a particular variable from 90 datasets. It would be a mission possible without Yajnes’s trick of Proc Contents.

SAS Where Like

SAS day 49: Background story: Where doing safety analysis, sometimes we need to look into the drug relations with Special Interest Adverse Events, which are similar, such as “Glaucoma”  and “Glaucosis”. While investigating into these special interest events, instead of using AESI in (“x”, “y”,”z” ) we prefer a more robust way.

No Observation

SAS Day 48: Challenge: How to create a label for “No Observation” when there is no observation? Approach: We know SQL is the best tool for Counting and macro for generating all 0 counts 

Nadir Value

SAS day 47: Nadir value Definition: Nadir value is the lowest value of best response prior to current assessment or the shortest SLD (sum lesion diameter) along with the tumor measurement progress. Example: Measurements: 28,29,27,30,35. Nadir:28,28,27,27,27 Measurements:28,28,27,27,27.  Nadir:28,28,27,27,27

SAS Noodle Plot

SAS day 46: Noodle plots are line plots that may involve many overlapping lines. The line plot enables us to track the lab result for 1 patient over time, noodle plot shows the lab results for serval patients including the Median (Red Line).

SAS Dummy Dataset by Do Loop

SAS day 45: Do Loop While creating Tables in SAS, generate a dummy dataset for shell is necessary sometimes. All Roads lead to Rome, there are many ways to create the dummy shell dataset, but can we find an elegant way? Desired Dummy Dataset:   DO Loop+ Array Approach: We can use the Do Loop to create dummy observations (Rows)…

Social media & sharing icons powered by UltimatelySocial