SAS Programming

Base and Advanced SAS Programming:
Base SAS Certification Exam Model Questions:
SAS® Certification: An End User’s Review
How SAS thinks
SAS Procedures Guide
SAS Programming Skills
Affordable SAS 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:
SAS statements,Procedures and Functions
Introduction to merging in SAS
How MERGE Really Works
FIRST.variable and LAST.variables:
Proc Report and Proc Tabulate

Downloads

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

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.txtlong 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.txtindexc 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.txttwo 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.datcorrelation SAS code
import: Bringing in data from Excel SAS code
Excel import file Excel export file
text fileformat 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 codemore 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

Online Study maerials: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 SASCreating and using formats and format libraries in SASUsing multidimensional arraysGood 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 AsterOutput 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. YPROC SQL:
An Introduction to Proc SqlTop Ten Reasons to Use PROC SQL OtherDebugging 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,courtesy of NESUGSAS Online Documentation:SAS 9 DocumentationVersion 9.1.3

SAS OnlineDoc 9.1.3 for the WebProc GlimmixProc QuantregVersion 9.1.2SAS OnlineDoc 9.1.2 for the WebVersion 9.1SAS OnlineDoc 9.1 for the WebSAS OnlineDoc 9.1 in PDFClinical trials:Clinical Trials Terminology for SAS ProgrammersClinical Trial Online – Running SAS on the Web without SAS/IntrNetManaging Clinical Trials Data using SAS® SoftwareClinical Trails Trial eCRF PagesEverything we should know about ICH, GCP and their GuidelinesSAS® and the CDISC (Clinical Data Interchange Standards Consortium)

SUGI Papers:

SUGI Proceedings

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

SAS Forums/Groups:

Tek-Tip SAS ForumIndeedDBASpotSAS Programming ForumITIL Community Forum