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 Row Sum

SAS day 30: Row Sum In a statistical report, Total Columns and Total Rows are very useful to show the integrity of the data. This raises the question, how do we generate the Total Column or the Total Row? We know the SUM function (sum(., c1-cn)) or Proc SQL SUM are great ways to produce the Column Sum. Today we will…

Proc Lifetest 1- Kaplan Meier graph

SAS day 28: Proc Lifetest 1 What are the foundations for FDA or NDA to approve a new medication besides its safety concerns? Many of us would think about the efficacy of the drug. If we dig in the question a bit further, how do we evaluate the efficacy then?


ADaM Day 1 In clinical trials, ADSL(Subject-Level Analysis Dataset) is the foundation of all ADaM analysis dataset, it is one record per subjects; it captures subjects’ population flag 🚩, treatment-related info, vital sign info♂, baseline disease info, and other info respect to different study designs.

SAS Proc Means

SAS Day 27: Proc Means We use Statistical summary to demonstrate the mean, median, max, min, Q1, Q3..  In SAS we can either use Proc Means or Proc Univariate to achieve the goals. Today we will introduce how to generate statistical summary using Proc Means. Basic Syntax: proc means data= dummy noprint; var age; /*Any continuous variable: age, weight, height*/…

SAS Column Output

SAS Day 26: Column Output Background: For table outputs, some times we want both the count and an overall percentage for each category rather than a simple number count. E.g. 75( 74): 75 count represents 74% of the total number in this group. In order to generate this output format, we need the variable count(c1,c2..) and group total (&n1, &n2..). 

SAS Macro Space

  SAS Day 25: Marco Space Trick Background: Last time, we did a little summary of the Space Function in SAS. Generally, it is enough, however, what if we want to manipulate the space inside a Macro? the general space function such as Trim, Compress, Compbl, Strip would NOT work sometime.   Problem:  We want to remove the extra empty…

SAS Space

SAS Day 24: Space Trick Background: My boss has a motto “Devil in the details“. I think all the Space- Related issues are the “Devil” in SAS. Today, we will go over the function and tricks I used to deal with Space. Remove Space: Compress, Compbl, Strip, Trim Concatenate with Remove Space: ||, CAT, CATS, CATX, CATT

Basic Oncology 101

  Today I will share some Basic Oncology Knowledge I found in my old notebook:  RECIST 1.1: Complete Response (CR): Disappearance of all non-nodal target lesion Partial Response (PR) : At least 30% decrease in the sum of diameters of target lesions compared with the baseline sum diameters.

ISS & ISE Info

  Background Story:       Once my friend said her team members cried during a meeting, i thought it was funny then. However, when I started to work in their team, I wanted to cry, too. What was the challenge? It was ISS/ ISE related work!  

Social media & sharing icons powered by UltimatelySocial