Quiz & Certification
What is data retrieval?
This post is part of 'SAS | Definitions' series
Data retrieval is the process of obtaining data from a Database Management System.
Filter a category
List of other posts
What is MedDRA
What is WHO-DD
What is ATC classification of Drugs
Tables vs Listings in Clinical Trial Analysis
Analysis Sets in Clinical Trial Data Analysis
Validation of TFLs in Clinical Trials
Vital Signs in Clinical Trials
ECG in clinical trials
Solid tumors vs other cancers
What is 21 CFR Part 11?
The Drug development process
Overview of clinical trial process
What is a clinical trial?
What is Pinnacle 21?
Who conducts clinical trials?
Why are clinical trials conducted?
What are the phases of clinical trials?
What is a clinical trial protocol?
Case Report Form (CRF)
Database annotated CRF
What is a clinical trial registry?
Factors affecting drug metabolism and activity
Prior and Concomitant medications
Inclusion/Exclusion Criteria in a clinical trial
What happens after a clinical trial is completed?
The Investigational New Drug Process
FDA Drug Review
What is the importance of baseline characteristics in a clinical trial?
Why do we need CDISC standards?
What is a clinical development plan?
What is a clinical study report?
"Exploratory study" vs "Confirmatory study"
What is ICH?
Clinical trial registries
Efficacy data vs Safety data
What is clinical data management?
Clinical SAS Programmer
Statistical Analysis Plan
What is RECIST 1.1?
Trial design aspects
What is a crossover clinical trial?
What is blinding in clinical trials?
What is an open-label clinical trial?
What is randomization in clinical trials?
What is a cohort?
What is a computer?
What happens when we execute a SAS program?
What is software?
What is SAS?
What is data?
What is data entry?
What is data retrieval?
What is data management?
What is "Report"?
What is statistics?
What is Statistical Analysis?
How do we use SAS?
What kind of questions can SAS help us answer?
How do we provide instructions to SAS?
What is a SAS program?
What does a SAS program contain?
Attributes of a SAS dataset
Rules for SAS dataset names
Rules for SAS variable names
Rules for SAS library names
Rules for character SAS format names
Reserved SAS dataset names
Rules for numeric SAS format names
What can SAS dataset options do?
Attributes of a SAS variable
Automatic conversion of data types in SAS
How does SAS expect our data to be organized?
Introduction to SAS interface
By groups in SAS
Rules for character SAS informat names
Count the number of times a particular value occurred in a variable of a dataset
Check the list of variables in a SAS dataset
Delete all sas datasets from a library
Delete specific sas datasets from a library
Save specific sas datasets (and delete others) of a library
Rename SAS datasets using proc datasets change statement
WARNING: No matching members in directory.
What is a SAS library?
What is a libref?
What is an input statement?
What is infile statement?
What is set statement?
What is length statement?
How to derive baseline flag in SDTM
How to create SEQ variable in SDTM
New domains in SDTM IG 3.3
What is a codelist?
How to derive study day variable in SDTM
What is SDTM?
Why do we need SDTM?
What is SDTM annotated Case Report Form (acrf.pdf)
How to convert original results to standard results using conversion factors
What information does SDTM.DM (Demographics) contain?
What is causality assessment?
What information does SDTM.AE (Adverse Events) contain?
What information does SDTM.DS (Disposition) contain?
What information does SDTM.CM (Concomitant/Prior Medications) contain?
What information does SDTM.PR (Procedures) contain?
What is ADaM?
What is ADSL as per ADaM standard?
What is BDS as per ADaM standard?
What is correlation?
ANCOVA - Basic example
ANOVA - Basic example
What is Binomial test
What is chi-square test
What is 95% confidence interval
Measurements of central tendency
Measurements of spread
Alpha (Type I) error
Beta (Type II) error
Repeated measures analysis
ttest - introduction
What is Standard error
What is Fishers exact test
What is Least Squares Means
What is R?
What is an R package?
What is tidyverse?
What are the core packages of tidyverse?
What is haven package of tidyverse?
How to install tidyverse?
How to load core tidyverse packages into the R session?
Import/Read SAS dataset into R
Creating sample data
How to create some sample data in SAS and R tidyverse
Subset variables (columns)
How to select only required variables/columns in SAS and R tidyverse?
How to drop unwanted variables/columns in SAS and R tidyverse?
Subset observations (rows)
How to select/subset required rows in SAS and R tidyverse
Append two datasets in SAS and R tidyverse
Merge/full join two datasets in SAS and R tidyverse
Merge/inner join two datasets in SAS and R tidyverse
Merge/left join two datasets in SAS and R tidyverse
Sort (order) observations
Sort/order observations based on the values in a single variable in SAS and R tidyverse
Restructure/transpose long data to wide data
Restructure/transpose wide data to long data
Obtain frequencies/counts based on one variable - one-way frequencies in SAS and R tidyverse
Obtain frequencies/counts based on two variables - two-way frequencies in SAS and R tidyverse
Descriptive statistics for a numeric variable using SAS and R tidyverse
You are good! But... You can be much better!!
A little motivational post!