SAS 9 online training and info links

SAS Programming

Base and Advanced SAS Programming:
Base SAS Certification Exam Model Questions:
SAS 9 Programming Basics
SAS 9 Programming Enhancements
SAS® Certification: An End User’s Review
Learning SAS is easy :
SAS I: Getting Started
SASII:Inferential Statistics

My SAS Manuals: 1. Basic and 2. Applications (Preliminary Version) ZIP file (about 400meg)

SAS Programming Code Examples:
SAS NOTES 1:
SAS NOTES 2:


SAS Tutorials
Learning SAS from another perspective. These tutorials provide SAS programming fundamentals within the context of Quantitative Methods I. (.pdf files)
Introduction for Quantitative Methods I students
Tutorial 1: The Basics
Tutorial 2: Understanding Data
Tutorial 3: SAS Programs, Program Logs, and Data Sets
Tutorial 4: SAS Procedure Steps
Tutorial 5: SAS Data Steps and how they work
Tutorial 6a: Measures of Central Tendency & Dispersion, Nominal and Ordinal Data
Tutorial 6b: Measures of Central Tendency & Dispersion, Interval-Ratio Data
Appendix A: SAS Operators
Appendix B: The Output Delivery System (ODS)
Appendix C: SAS System Options
Stata & SAS Review: Reporting on Data (.pdf) (New February 2007)
SAS Methods for Combining Data Sets (.pdf)

SAS®'s Various Varying Variables,or 1000+ Ways to Manipulate SAS Variables

Introduction to SAS Informats and Formats
How SAS thinks
Where to Go From Here: Learning More about SAS® Software
SAS Procedures Guide
SAS Programming Skills
Affordable SAS tips
Some SAS Useful Tips
Advanced SAS Programming Techniques
Creative Uses of SAS Functions
Data Summarization Methods in Base SAS Procedures
The SAS Debugging Primer
SAS Model resumes and SAS Tips and Tricks
SAS UNIX commands:
Using SAS on UNIX:
SAS statements,Procedures and Functions
Introduction to merging in SAS
How MERGE Really Works
FIRST.variable and LAST.variables:
Proc Report and Proc Tabulate
SAS projects
How to write a Macro to Transport SAS Data Sets to and from UNIX

Downloads
SAS eBOOKs
Base and Avanced SAS certification Materials and Practice Exams...........

Validation:
http://www.thedatagroup.com/downloads/pgm_validation_plan.ppt#390,4,Slide 4


SAS Video Tutorials:
Class Notes
Entering Data, view movie
Exploring Data, view movie
Modifying Data, view movie
Managing Data, view movie
Analyzing Data, view movie (part 1) and movie (part 2)

Data step:
getting started 1: windows SAS code
getting started 2: data step SAS code
automatic _N_ variable SAS code
drop & delete SAS code
formating: dates and numbers SAS code date sal.txt (also see the format procedure below to create your own formats)
functions SAS code
import: Bringing in data from Excel SAS code Excel import file Excel export file text file
input: length statement SAS code infile options.txt
long SAS code long.txt
missing data SAS code
output option SAS code
pointers SAS code ex7.txt ex8.txt ex9.txt
more about pointers SAS code pointers.SAS ex10.txt
missover & delimiter SAS code delimiter.txt
more on the delimiter SAS code
retain SAS code
set SAS code
simulations: random numbers SAS code
sum SAS code
statistical functions SAS code

Logic:
do loops SAS code
more about do loops SAS code
nested do loops SAS code
if then statements SAS code score.txt

Combining Data sets:
concatenating and interleaving SAS code
one-to-one merging SAS code
match merging SAS code
updating SAS code

Character functions:
substring function SAS code
trim and left functions SAS code
compress and index functions SAS code record.txt
indexc and indexw functions SAS code
implicit character-to-numeric conversion SAS code
explicit character-to-numeric conversion SAS code
implicit and explicit numeric-to-character conversion SAS code

Arrays:
introduction to arrays SAS code
using arrays to count SAS code
using arrays to order observations SAS code
using arrays to transpose data SAS code ratsdose.txt
two dimensional arrays SAS code temp.txt fin.txt

Permanent SAS Data sets: (great for large data sets)
introduction: using libname SAS code
put and file statements SAS code survey.dat data1.dat data2.dat data3.txt fruit.dat data4.dat data5.dat income.dat

Procedures:
ANOVA SAS code incommed.dat
analysis of equal vars: B-P for anova SAS code
contents: Great for large data sets SAS code sheep.dat
correlation SAS code
import: Bringing in data from Excel SAS code Excel import file Excel export file text file
format SAS code incommed.dat (also see formating above for SAS' date and number formats)
frequency tables SAS code incommed.dat freq.xls
means SAS code incommed.dat
more about means SAS code incommed.dat
gcharts: Bar and Pie charts SAS code incommed.dat
gplot: a prettier plot SAS code
more about gplot SAS code
plot SAS code
print SAS code account.txt
sort SAS code account.txt more about sorting SAS code compt.txt t-test SAS code incommed.dat transpose SAS code univariate SAS code test.dat


Programming outside the Data step or Procedures:
Getting started 3: options SAS code
more options SAS code

Macros:
introduction: macro variables (%let statement) SAS code number.dat contest.dat
%put statement SAS code score.dat
basic macros SAS code
macros with parameters SAS code ranks.dat
macro do loops SAS code
macro if/then/else statements SAS code makeup.dat
nested macros SAS code
simulations example SAS code reg.dat

Video Tutorials:

Intro_to_SAS.wmv ( 7.3 MB)
Introduction_to_the_SAS_Data_Step.wmv ( 8.2 MB)
Importing_Data_into_SAS.wmv ( 13.3 MB)
Introduction_to_PROC_UNIVARIATE.wmv ( 8.1 MB)
Introduction_to_the_Output_Statement_in_SAS.wmv ( 5.1 MB)
Introduction_to_Boxplots_in_SAS.wmv ( 3.3 MB)
Intro_to_Scatterplots.wmv ( 4.6 MB)
Introduction_to_Proc_Corr_in_SAS.wmv ( 3.4 MB)
Introduction_to_Proc_Reg_in_SAS.wmv ( 6.4 MB)
Assessing_Regression_Models_in_SAS.wmv ( 5.4 MB)Testing_for_Normality_in_Regression_Models.wmv ( 5.8 MB)
Testing_for_Constant_Variance_in_Regression_using_SAS.wmv ( 7.4 MB)
Introduction_to_Proc_GLM_in_SAS.wmv ( 5.2 MB)
Testing_for_Normality_in_ANOVA_models_using_SAS.wmv ( 4.6 MB)
Testing_for_Constant_Variance_in_ANOVA_models_using_SAS.wmv ( 4.1 MB)
Multiple_Comparisons_in_SAS.wmv ( 5.4 MB)



Online Study materials:
Fundamentals of Using SAS (part I)
Introduction to SAS
Descriptive information and statistics
An overview of statistical tests in SAS
Exploring data with graphics

Fundamentals of Using SAS (part II)
Using where with SAS procedures
Missing values in SAS
Common SAS options
Overview of SAS syntax of SAS procedures
Common error messages in SAS

Reading Raw Data into SAS
Inputting raw data into SAS
Reading dates into SAS and using date variables

Basic Data Management in SAS
Creating and recoding variables
Using SAS functions for making/recoding variables
Subsetting variables and observations
Labeling data, variables, and values
Using PROC SORT and the BY statement
Making and using permanent SAS data files (version 8)

Data Management:
How do I make unique anonymous ID variables for my data?
How can I create an enumeration variable by groups?
How can I see the number of missing values and patterns of missing values in my data file?
How can I count the number of missing values for a character variable?
How can I increment dates in SAS?
How can I find things in a character variable in SAS?
How do I standardize variables (make them have a mean of 0 and sd of 1)?
Is there a quick way to create dummy variables?

Reading/Writing Data Files
How do I read a file that uses commas, tabs or spaces as delimiters to separate variables?
How do I read a delimited file with missing values?
How do I read a delimited file that has delimiters embedded in the data?
What are some common infile options for reading a raw data file?
How do I read raw data files compressed with gzip (.gz files) in SAS?
How do I write a data file that uses commas, tabs or spaces as delimiters between variables?
How do I read/write Excel files in SAS version 8?

Reading/Writing SAS Files with Formats
How do I use a SAS data file with a format library?
How do I use a SAS data file when I don't have its format library?

Other:
How can I change the way variables are displayed in proc freq?
How can I put a value from a data file to a macro variable?
How can I create tables using proc tabulate?

Procedures
PROC MEANS More than just your average procedure(PDF) by Peter R. Welbrock
The power of PROC FORMAT(PDF) by Jonas V. Bilenas
Ten Things You Should Know About PROC FORMAT(PDF) by Jack Shoemaker
PROC SQL for DATA Step Die-Hards(PDF) by Christianna S. Williams
An Introduction to the SQL Procedure(PDF) by Chris Yindra
Alternatives to Merging SAS Data Sets … But Be Careful(PDF) by Michael J. Wieczkowski
Handling Missing Values in the SQL Procedure(PDF) by Danbo Yi & MA Lei Zhang
Creating and using indexes in SAS
Creating and using formats and format libraries in SAS
Using multidimensional arrays

Good Programming Practices
Bulletproofing Your SAS Results(PDF) by Vanessa Hayden
Clean-up, Comments and Code - Making it Maintainable(PDF) by Clay and Lori Martin
SAS Program Efficiency for Beginners(PDF) by Bruce Gilsen
Coding for Posterity(PDF) by Rick Aster

Output Delivery System(ODS)
ODS, YES! Odious, NO! – An Introduction to the SAS Output Delivery System(PDF) by Lara Bryant, Sally Muller & Ray Pass
ODS for Data Analysis: Output As-You-Like-It in Version 7(PDF) by Christopher R. Olinger and Randall D. Tobias, from SUGI Proceedings, 1998, courtesy of SAS.
Making the SAS Output Delivery System (ODS) work for you(PDF) by William Fehlner, from SUGI Proceedings, 1999, courtesy of SAS.
Twisty Little Passages All Alike, Output Delivery System (ODS) Templates Exposed(PDF) by Chris Olinger, from SUGI Proceedings, 1999, courtesy of SAS.

SAS Macros
Getting Started with Macros(PDF) by Ian Whitlock
Moving from Macro Variables to Macros(PDF) by Lisa Sanbonmatsu
Macros from Beginning to Mend A Simple and Practical Approach to the SAS Macro Facility(PDF) by Michael G. Sadof
An Introduction to Macro Variables and Macro Programs(PDF) by Mike S. Zdeb
Creating Macro Variables via PROC SQL(PDF) by Mike S. Zdeb
More About “INTO:Host-Variable” in PROC SQL: Examples(PDF) by John Q. Zhang
Macro Quoting Functions, Other Special Character Masking Tools, and How To Use Them(PDF) by Arthur L. Carpenter
Secrets of Macro Quoting Functions – How and Why(PDF) by Susan O’Connor
&&&, ;;, and Other Hieroglyphics Advanced Macro Topics(PDF) by Chris Yindra, C. Y
Developing, Managing, and Evaluating a Standard Macro System by Albert Mo


PROC SQL:
An Introduction to Proc Sql
Top Ten Reasons to Use PROC SQL

Other
Debugging 101(PDF) by Peter Knapp
Those Missing Values in Questionnaires(PDF) by John R. Gerlach & Cindy Garra
Avoiding Mayhem in the New Millennium: Working with Missing Data(PDF) by JoAnn Matthews
Simplifying Complex Character Comparisons by Using the IN Operator and the Colon (:) Operator Modifier(PDF) by Paul Grant
Arrays: In and Out and All About(PDF) by Marge Scerbo
Complex Arrays Made Simple(PDF) by Mary McDonald, PaineWebber Incorporated
You Could Look It Up: An Introduction to SASHELP Dictionary Views(PDF) by Michael Davis, The 'SKIP' Statement(PDF) by Paul Grant
Indexing and Compressing SAS Data Sets: How, Why, and Why Not(PDF) Andrew H. Karp,
Automating the Creation of a Single Bookmarked PDF Document
from Multiple SAS® ASCII and PostScript® Output Files
Be Careful When You Merge SAS Datasets!

courtesy of NESUG

SAS Online Documentation:
SAS 9 Documentation
Version 9.1.3
SAS OnlineDoc 9.1.3 for the Web
Proc Glimmix
Proc Quantreg
Version 9.1.2
SAS OnlineDoc 9.1.2 for the Web
Version 9.1
SAS OnlineDoc 9.1 for the Web
SAS OnlineDoc 9.1 in PDF

SAS TIPS and TRICS:
SAS TIPS AND TRICKS part1:
SAS TIPS AND TRICKS part2:

Clinical trials:
Clinical Trials Terminology for SAS Programmers
Clinical Trial Online – Running SAS on the Web without SAS/IntrNet
Managing Clinical Trials Data using SAS® Software
Clinical Trails
Quality Control and Quality Assurance in Clinical Research: SAS
Everything we should know about ICH, GCP and their Guidelines
Data Integrity through DEFINE.PDF and DEFINE.XML
SAS® and the CDISC (Clinical Data Interchange Standards Consortium)
An Introduction to CDISC:
CDISC: Why SAS® Programmers Need to Know
CDISC Implementation Step by Step: A Real World Example
CDISC standards
Supporting the CDISC standards
How to test CDISC Operation data Model (ODM) in SAS
Can Coding MedDRA and WHO Drug be as Easy as a Google Search?
The Use of CDISC Standards in SAS from Data Capture to Reporting
Clinical Data Model and FDA/CDISC Submissions
Implementing an Audit Trail within a Clinical Reporting Tool

Annotation of CRFs:
Trial eCRF Pages
Using SAS to Speed up Annotating Case Report Forms in PDF Format
ANNOTATED CASE REPORT FORM AUTOMATION SYSTEM
Annotated CRF 1: Download
(CTN0008_SDTM_annotation_20070413.pdf - 2179Kb)
Annotated CRF 2: Download
(CTN001_SDTM_ANNOTATION_20070330.pdf - 564Kb)
Annotated CRF 3: Download
(CTN002_SDTM_ANNOTATION_20070403.pdf - 560Kb)

Study Protocol 1: Download
(NIDA-CTN-0001_Bup_Nx_vs_Clonidine_Inpatient_Protocol_v.5b_112700.pdf - 192Kb)
SDTM-annotated CRFs
The CDISC ODM Study Designer :User Manual
Creating Case Report Tabulations (CRTs) for an NDA Electronic Submission to the FDA
XML Basics for SAS Programmers
A SAS
MACRO FOR PRODUCING CLINICAL LABORATORY SHIFT TABLE
Some Statistical Programming Considerations for e-Submission

SUGI Papers:
SUGI Proceedings for SUGI 22, 23, 24, 25, 26, 27
SGF 2008 SGF 2007 SUGI 31 SUGI 30 SUGI 29 SUGI 28 SUGI 27 SUGI 26
SUGI 25 SUGI 24 SUGI 23 SUGI 22 SUGI 21 SUGI 20 SUGI 13 SUGI 12 SUGI 09

SAS Forums/Groups:
Roland SAS Tips
UNC SAS Topics
Yorku SAS
Devenzia SAS
Members Tripod SAS
Pubhealth SAS
PSU SAS
Mac SAS
Mayo SAS
Clinstreport SAS
SAS Programming Forum
ITIL Community Forum


Interview:
SAS Interview Questions:Base SAS

SAS interview questions:General

SAS interview questions:Macros

SAS Interview :UNIX Commands

SAS interview Q&A: PROC SQl, SAS GRAPH, UNIX and ODS

SAS Interview Q&A:Clinical trials

SAS Cheat Sheat

What to think and what to learn about SAS interview