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
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…
SAS Day 37 In previous days, we discussed generating Statistical Summary using Proc Means and Proc Univariate for Continuous Variables(Age, BMI, Height, Weight). Now, there is a question, what procedure should we apply to generate Categorical Variables (Sex, Race, Country)? Today we will show how to use Proc Freq to summarize the Categorical Variables. Proc Freq: Sample dataset: Subjid ID:…
SAS Day 36 In SAS Day 27, we showed using Proc Means to generate the statistical summaries for Continuous Variable such as (Age, BMI, Height, Weight). As an old idiom stated, “All Roads lead to Rome”. Today we will introduce Proc Univariate to create the Summary Statistics. Task: Proc Univariate Sample for Statistical Summaries Sample Dataset…