book

Getting Started with SAS Programming

Name: Getting Started with SAS Programming
Author: Ron Cody
ISBN: 9781953329189

by Ron Cody

February 2021

Beginner

316 pages

6h 49m

English

SAS Institute

Read now

Unlock full access

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 AcademicsRegistering for ODAConclusion
Chapter 2: The SAS Studio Interface
IntroductionExploring the Built-In Data SetsSorting Your Data Switching between Column Names and Column LabelsResizing TablesCreating FiltersConclusion
Chapter 3: Importing Your Own Data
IntroductionUploading Data from Your Local Computer to SAS StudioListing the SAS Data SetImporting an Excel Workbook with Invalid SAS Variable NamesImporting an Excel Workbook That Does Not Have Variable NamesImporting Data from a CSV FileConclusion
Chapter 4: Creating Reports
IntroductionUsing the List Data Task to Create a Simple ListingFiltering DataSorting DataOutputting HTML and PDF FilesJoining Tables (Using the Query Window)Conclusion
Chapter 5: Summarizing Data Using SAS Studio
IntroductionSummarizing Numeric VariablesAdding a Classification VariableSummarizing Character VariablesConclusion

Chapter 6: Graphing Data
IntroductionCreating a Frequency Bar ChartCreating a Bar Chart with a Response VariableAdding a Group VariableCreating a Pie ChartCreating a Scatter PlotConclusion
Part II: Learning How to Write Your Own SAS Programs
Chapter 7: An Introduction to SAS Programming
SAS as a Programming LanguageThe SAS Studio Programming WindowsYour First SAS ProgramDATA StatementINILE StatementINPUT StatementAssignment StatementHow the DATA Step WorksHow the INPUT Statement WorksReading Delimited DataHow Procedures (PROCs) WorkHow SAS Works: A Look Inside the “Black Box”Conclusion
Chapter 8: Reading Data from External Files
IntroductionReading Data Values Separated by DelimitersReading Comma-Separated Values FilesReading Data Separated by Other DelimitersReading Data in Fixed ColumnsReading Data in Fixed Columns Using Column InputReading Data in Fixed Columns Using Formatted InputConclusionProblems
Chapter 9: Reading and Writing SAS Data Sets
What’s a SAS Data Set?Temporary Versus Permanent SAS Data SetsCreating a Library by Submitting a LIBNAME StatementUsing the Library Tab to Create a Permanent LibraryReading from a Permanent SAS Data SetConclusionProblems
Chapter 10: Creating Formats and Labels
What Is a SAS Format and Why Is It Useful?Using SAS Built-in FormatsMore Examples to Demonstrate How to Write FormatsDescribing the Difference between a FORMAT Statement in a Procedure and a FORMAT Statement in a DATA StepMaking Your Formats PermanentCreating Variable LabelsConclusionProblems
Chapter 11: Performing Conditional Processing
IntroductionGrouping Age Using Conditional ProcessingUsing Conditional Logic to Check for Data ErrorsDescribing the IN OperatorUsing Boolean Logic (AND, OR, and NOT Operators)A Special Caution When Using Multiple OR OperatorsConclusionProblems
Chapter 12: Performing Iterative Processing: Looping
IntroductionDemonstrating a DO GroupDescribing a DO LoopUsing a DO Loop to Graph an EquationDO Loops with Character ValuesLeaving a Loop Based on Conditions (DO WHILE and DO UNTIL Statements)DO WHILECombining an Iterative Loop with a WHILE ConditionDO UNTILDemonstrating That a DO UNTIL Loop Executes at Least OnceCombining an Iterative Loop with an UNTIL ConditionLEAVE and CONTINUE StatementsConclusionProblems
Chapter 13: Working with SAS Dates
IntroductionReading Dates from Text DataCreating a SAS Date from Month, Day, and Year ValuesDescribing a Date ConstantExtracting the Day of the Week, Day of the Month, Month, and Year from a SAS DateAdding a Format to the Bar ChartComputing Age from Date of Birth: The YRDIF FunctionConclusionProblems
Chapter 14: Subsetting and Combining SAS Data Sets
IntroductionSubsetting (Filtering) Data in a SAS Data SetDescribing a WHERE= Data Set OptionDescribing a Subsetting IF StatementA More Efficient Way to Subset Data When Reading Raw DataCreating Several Data Subsets in One DATA StepCombining SAS Data Sets (Combining Rows)Adding a Few Observations to a Large Data Set (PROC APPEND)Interleaving Data SetsMerging 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 MergeMerging Two Data Sets with Different BY Variable Names Merging Two Data Sets with One Character and One Numeric BY VariableUpdating a Master File from a Transaction File (UPDATE Statement)ConclusionProblems
Chapter 15: Describing SAS Functions
IntroductionDescribing Some Useful Numeric FunctionsFunction Name: MISSINGFunction Name: NFunction Name: NMISSFunction Name: SUMFunction Name: MEANFunction Name: MINFunction Name: MAXFunction Name: SMALLESTFunction Name: LARGESTProgramming Example Using the N, NMISS, MAX, LARGEST, and MEAN FunctionsFunction Name: INPUTCALL Routine: CALL SORTNFunction Name: LAGFunction Name: DIFDescribing Some Useful Character FunctionsFunction Names: LENGTHN and LENGTHCFunction Names: TRIMN and STRIPFunction Names: UPCASE, LOWCASE, and PROPCASE (Functions That Change Case)Function Name: PUTFunction Name: SUBSTRN (Newer Version of the SUBSTR Function)Function Names: FIND and FINDCFunction Names: CAT, CATS, and CATXFunction Names: COUNT and COUNTCFunction Name: COMPRESSFunction Name: SCANCALL Routine: CALL MISSINGFunction Names: NOTDIGIT, NOTALPHA, and NOTALNUMFunction Names: ANYDIGIT, ANYALPHA, and ANYALNUMFunction Name: TRANWRDConclusionProblems
Chapter 16: Working with Multiple Observations per Subject
IntroductionUseful Tools for Working with Longitudinal DataDescribing First. and Last. VariablesComputing Visit-to-Visit DifferencesComputing Differences between the First and Last VisitsCounting the Number of Visits for Each PatientConclusionProblems
Chapter 17: Describing Arrays
IntroductionWhat Is an Array?Describing a Character ArrayPerforming an Operation on Every Numeric Variable in a Data SetPerforming an Operation on Every Character Variable in a Data SetConverting a Data Set with One Observation per Subject into a Data Set with Multiple Observations per SubjectConverting a Data Set with Multiple Observations per Subject into a Data Set with One Observation per SubjectConclusionProblems
Chapter 18: Displaying Your Data
IntroductionProducing a Simple Report Using PROC PRINTUsing Labels Instead of Variable Names as Column HeadingsIncluding a BY Variable in a ListingIncluding the Number of Observations in a ListingConclusionProblems
Chapter 19: Summarizing Data with SAS Procedures
IntroductionUsing PROC MEANS (with the Default Options)Using PROC MEANS Options to Customize the Summary ReportComputing Statistics for Each Value of a BY VariableUsing a CLASS Statement Instead of a BY StatementIncluding Multiple CLASS Variables with PROC MEANSStatistics Broken Down Every WayUsing PROC MEANS to Create a Summary Data SetLetting PROC MEANS Name the Variables in the Output Data SetCreating a Summary Data Set with CLASS VariablesUsing a Formatted CLASS VariableDemonstrating PROC UNIVARIATEConclusionProblems
Chapter 20: Computing Frequencies
IntroductionCreating a Data Set to Demonstrate Features of PROC FREQUsing PROC FREQ to Generate One-Way Frequency TablesCreating Two-Way Frequency TablesCreating Three-Way Frequency TablesUsing Formats to Create Groups for Numeric VariablesConclusionProblems

Overview

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.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 9781953329189

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills