# 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… ## 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…