Design and create databases
Demonstrate ability to design and create databases for collecting and storing study data, including structures and tools to simplify the process
Use SQL
Be able to use SQL queries from SAS, R, and database tools to work wit databases and extract data for analysis
Use SAS/IML
Use SAS/IML to work with matrices and compute summaries of data including importing data from SAS datasets and exporting results to SAS datasets
Regular expression matching
Use regular expression matching in SAS, R, and other tools to extract relavent parts of data or manipulate text to make data analysis simpler
Write custom R functions
Write custom R functions to analyze data and to pass to other processing tools
Create and run basic simulations
Create and run basic simulations in R and SAS to explore the bahavior or routines and do basic power studies
Additional Tools
Demonstrate knowledge about additional tools in SAS, R, and stand alone tools that could aid in preparing data for analysis
