Getting Started with SAS Programming: Using SAS Studio in the Cloud (Hardcover edition)

✍ Scribed by Ron Cody

• Publisher: SAS Institute
• Year: 2021
• Tongue: English
• Leaves: 385
• Category: Library

✦ Synopsis

Get up and running with SAS using Ron Cody's easy-to-follow, step-by-step guide.

Aimed at beginners, Getting Started with SAS Programming: Using SAS Studio in the Cloud uses short examples to teach SAS programming from the basics to more advanced topics in the point-and-click interactive environment of SAS Studio. To begin, you will learn how to register for SAS OnDemand for Academics, an online delivery platform for teaching and learning statistical analysis that provides free access to SAS software via the cloud.

The first part of the book shows you how to use SAS Studio built-in tasks to produce a report, summarize data, and create charts and graphs. It also describes how you can perform basic statistical tests using the interactive point-and-click environment.

The second part of the book uses easy-to-follow examples to show you how to write your own SAS programs and how to use SAS procedures to perform a variety of tasks. This part of the book also explains how to read data from a variety of sources: text files, Excel workbooks, and CSV files. In order to get familiar with the SAS Studio environment, this book also shows you how to access dozens of interesting data sets that are included with the SAS OnDemand for Academics platform.

✦ Table of Contents

Contents
About This Book
About The Author
Acknowledgements
Part I: Getting Acquainted with the SAS Studio Environment
Chapter 1: Introduction to SAS OnDemand for Academics
Introduction: An Overview of SAS OnDemand for Academics
Registering for ODA
Conclusion
Chapter 2: The SAS Studio Interface
Introduction
Exploring the Built-In Data Sets
Sorting Your Data
Switching between Column Names and Column Labels
Resizing Tables
Creating Filters
Conclusion
Chapter 3: Importing Your Own Data
Introduction
Uploading Data from Your Local Computer to SAS Studio
Listing the SAS Data Set
Importing an Excel Workbook with Invalid SAS Variable Names
Importing an Excel Workbook That Does Not Have Variable Names
Importing Data from a CSV File
Conclusion
Chapter 4: Creating Reports
Introduction
Using the List Data Task to Create a Simple Listing
Filtering Data
Sorting Data
Outputting HTML and PDF Files
Joining Tables (Using the Query Window)
Conclusion
Chapter 5: Summarizing Data Using SAS Studio
Introduction
Summarizing Numeric Variables
Adding a Classification Variable
Summarizing Character Variables
Conclusion
Chapter 6: Graphing Data
Introduction
Creating a Frequency Bar Chart
Creating a Bar Chart with a Response Variable
Adding a Group Variable
Creating a Pie Chart
Creating a Scatter Plot
Conclusion
Part II: Learning How to Write Your Own SAS Programs
Chapter 7: An Introduction to SAS Programming
SAS as a Programming Language
The SAS Studio Programming Windows
Your First SAS Program
DATA Statement
INILE Statement
INPUT Statement
Assignment Statement
How the DATA Step Works
How the INPUT Statement Works
Reading Delimited Data
How Procedures (PROCs) Work
How SAS Works: A Look Inside the “Black Box”
Conclusion
Chapter 8: Reading Data from External Files
Introduction
Reading Data Values Separated by Delimiters
Reading Comma-Separated Values Files
Reading Data Separated by Other Delimiters
Reading Data in Fixed Columns
Reading Data in Fixed Columns Using Column Input
Reading Data in Fixed Columns Using Formatted Input
Conclusion
Problems
Chapter 9: Reading and Writing SAS Data Sets
What’s a SAS Data Set?
Temporary Versus Permanent SAS Data Sets
Creating a Library by Submitting a LIBNAME Statement
Using the Library Tab to Create a Permanent Library
Reading from a Permanent SAS Data Set
Conclusion
Problems
Chapter 10: Creating Formats and Labels
What Is a SAS Format and Why Is It Useful?
Using SAS Built-in Formats
More Examples to Demonstrate How to Write Formats
Describing the Difference between a FORMAT Statement in a Procedure and a FORMAT Statement in a DATA Step
Making Your Formats Permanent
Creating Variable Labels
Conclusion
Problems
Chapter 11: Performing Conditional Processing
Introduction
Grouping Age Using Conditional Processing
Using Conditional Logic to Check for Data Errors
Describing the IN Operator
Using Boolean Logic (AND, OR, and NOT Operators)
A Special Caution When Using Multiple OR Operators
Conclusion
Problems
Chapter 12: Performing Iterative Processing: Looping
Introduction
Demonstrating a DO Group
Describing a DO Loop
Using a DO Loop to Graph an Equation
DO Loops with Character Values
Leaving a Loop Based on Conditions (DO WHILE and DO UNTIL Statements)
DO WHILE
Combining an Iterative Loop with a WHILE Condition
DO UNTIL
Demonstrating That a DO UNTIL Loop Executes at Least Once
Combining an Iterative Loop with an UNTIL Condition
LEAVE and CONTINUE Statements
Conclusion
Problems
Chapter 13: Working with SAS Dates
Introduction
Reading Dates from Text Data
Creating a SAS Date from Month, Day, and Year Values
Describing a Date Constant
Extracting the Day of the Week, Day of the Month, Month, and Year from a SAS Date
Adding a Format to the Bar Chart
Computing Age from Date of Birth: The YRDIF Function
Conclusion
Problems
Chapter 14: Subsetting and Combining SAS Data Sets
Introduction
Subsetting (Filtering) Data in a SAS Data Set
Describing a WHERE= Data Set Option
Describing a Subsetting IF Statement
A More Efficient Way to Subset Data When Reading Raw Data
Creating Several Data Subsets in One DATA Step
Combining SAS Data Sets (Combining Rows)
Adding a Few Observations to a Large Data Set (PROC APPEND)
Interleaving Data Sets
Merging Two Data Sets (Adding Columns)
Controlling Which Observations Are Included in a Merge (IN= Data Set Option)
Performing a One-to-Many or Many-to-One Merge
Merging Two Data Sets with Different BY Variable Names
Merging Two Data Sets with One Character and One Numeric BY Variable
Updating a Master File from a Transaction File (UPDATE Statement)
Conclusion
Problems
Chapter 15: Describing SAS Functions
Introduction
Describing Some Useful Numeric Functions
Function Name: MISSING
Function Name: N
Function Name: NMISS
Function Name: SUM
Function Name: MEAN
Function Name: MIN
Function Name: MAX
Function Name: SMALLEST
Function Name: LARGEST
Programming Example Using the N, NMISS, MAX, LARGEST, and MEAN Functions
Function Name: INPUT
CALL Routine: CALL SORTN
Function Name: LAG
Function Name: DIF
Describing Some Useful Character Functions
Function Names: LENGTHN and LENGTHC
Function Names: TRIMN and STRIP
Function Names: UPCASE, LOWCASE, and PROPCASE (Functions That Change Case)
Function Name: PUT
Function Name: SUBSTRN (Newer Version of the SUBSTR Function)
Function Names: FIND and FINDC
Function Names: CAT, CATS, and CATX
Function Names: COUNT and COUNTC
Function Name: COMPRESS
Function Name: SCAN
CALL Routine: CALL MISSING
Function Names: NOTDIGIT, NOTALPHA, and NOTALNUM
Function Names: ANYDIGIT, ANYALPHA, and ANYALNUM
Function Name: TRANWRD
Conclusion
Problems
Chapter 16: Working with Multiple Observations per Subject
Introduction
Useful Tools for Working with Longitudinal Data
Describing First. and Last. Variables
Computing Visit-to-Visit Differences
Computing Differences between the First and Last Visits
Counting the Number of Visits for Each Patient
Conclusion
Problems
Chapter 17: Describing Arrays
Introduction
What Is an Array?
Describing a Character Array
Performing an Operation on Every Numeric Variable in a Data Set
Performing an Operation on Every Character Variable in a Data Set
Converting a Data Set with One Observation per Subject into a Data Set with Multiple Observations per Subject
Converting a Data Set with Multiple Observations per Subject into a Data Set with One Observation per Subject
Conclusion
Problems
Chapter 18: Displaying Your Data
Introduction
Producing a Simple Report Using PROC PRINT
Using Labels Instead of Variable Names as Column Headings
Including a BY Variable in a Listing
Including the Number of Observations in a Listing
Conclusion
Problems
Chapter 19: Summarizing Data with SAS Procedures
Introduction
Using PROC MEANS (with the Default Options)
Using PROC MEANS Options to Customize the Summary Report
Computing Statistics for Each Value of a BY Variable
Using a CLASS Statement Instead of a BY Statement
Including Multiple CLASS Variables with PROC MEANS
Statistics Broken Down Every Way
Using PROC MEANS to Create a Summary Data Set
Letting PROC MEANS Name the Variables in the Output Data Set
Creating a Summary Data Set with CLASS Variables
Using a Formatted CLASS Variable
Demonstrating PROC UNIVARIATE
Conclusion
Problems
Chapter 20: Computing Frequencies
Introduction
Creating a Data Set to Demonstrate Features of PROC FREQ
Using PROC FREQ to Generate One-Way Frequency Tables
Creating Two-Way Frequency Tables
Creating Three-Way Frequency Tables
Using Formats to Create Groups for Numeric Variables
Conclusion
Problems