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 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)…
SAS Day 44： Last time, we showed an example of Spider Plot for subjects response over time. Waterfall plot visualizes the best overall response in tumor size in each participating subjects oncology studies. Each of the bars in the plot describes the percentage of change (growth or reduction) in the target lesions as compared to the baseline measurements for each…
SAS Day 43: Spider Plot 🕷 Spider Plot is a powerful graph to visualize the change in percentage for critical values, such as Tumor size, lab values for individual patients over time. In the graph, each leg of the spider represents an individual patient, the horizontal reference time, Y-axis shows the baseline relative values. It demonstrates the percent change across…
SAS Day 42: Proc Transpose Proc Transpose is a powerful procedure for reshaping the data structures (i.e.Row observations to Column Variables or Vice Versa). Key options: VAR, BY, ID, Prefix, name
ADaM DAY 2 : ADLB Abstract: ADLB stands for Laboratory Test Result Analysis dataset is an important safety dataset, it captured all the Lab test results for each treatment cycle per patient. We can the Lab dataset to visualize the change of lab test results based on the time change for each patient (Spider Plot) or the overall lab-test distribution…
ADaM day 1: ADaM.ADAE stands for Adverse Event Analysis dataset : This dataset is crucial for safety analysis in a new drug development progress as well as in post-market safety updates. it contains the information of ADSL, AE, SUPPAE. The dataset ADAE captured adverse event’s name, length, start and end date, relation to the drugs, actions to resolve the adverse…
SAS Day 41 Background Story: Most of the time we use Proc Freq binomial to generate confidence interval for 2-level categorical variable compairson, such as, Success or Failure. We also use CI interval to represent the proportion estimated in the dataset (Upper Limit, Lower Limit). Once instead of directly applying the Upper Limit and Lower Limit, my boss asked me…
SAS Day 40: Forest Plot Tired looking across many overall response tables while comparing the same rate? The forest plot is a perfect solution to summarise data from multiple resources and convert it into a single reader-friendly graph. Ideal Forest Plot: When taking all the relevant studies, ask the same question with the same statistical model, identifies a common…
SAS Day 39: When I was in Bogota, Colombia, Martha showed me how her son used a Mind-map to create a holiday schedule. I really loved it. As I m summarizing the applications of SQL. I decide to use a Mind-map for an overview and provide a detailed example for each category in the future. SAS Proc SQL Overview: …
SAS day 38 SAS Merge is a good data step to join couple datasets together, nonetheless, SQL join is a fancier one, not necessarily easy to use, but definitely more sophisticated! Today we will show a SQL Full Join with 3 datasets, respectively, a, b, c. Full join for Two Datasets: proc sql noprint; create table all as select…