book

An Introduction to SAS University Edition

Name: An Introduction to SAS University Edition
Author: Ron Cody
ISBN: 9781629600079

by Ron Cody

February 2018

Beginner

366 pages

7h 2m

English

SAS Institute

Read now

Unlock full access

List of Programs
About This Book
About the Author
Acknowledgments
Part 1: Getting Acquainted with the SAS Studio Environment
Chapter 1: Introduction: An Overview of SAS and SAS University Edition
Obtaining Your Free Copy of SASStep 1: Download VirtualBox and Create the "myfolders" Folder on your ComputerStep 2: Download SAS University EditionStep 3: Configure VirtualBox and Set up the Shared FolderStep 4: Use - Start University EditionConclusion
Chapter 2: The SAS Studio Interface
IntroductionExploring the Built-In Data SetsSorting Your DataSwitching Between Column Names and Column LabelsResizing TablesCreating FiltersConclusion
Chapter 3: Importing Your Own Data
IntroductionExploring the Utilities TabImporting Data from an Excel WorkbookListing 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 PDF and RTF 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 2: 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 ProgramHow 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 ColumnsColumn InputFormatted InputReading Excel FilesReading from an Excel Workbook where Column Headings Are Invalid SAS Variable NamesConclusionProblems
Chapter 9: Reading and Writing SAS Data Sets
What's a SAS Data Set?Temporary versus Permanent SAS Data SetsShared Folders: Communicating between Your Virtual Computer and Your Real ComputerCreating a Shared Folder and Reading Data from ItCreating a Permanent SAS Data SetReading 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, 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 NamesMerging 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
Appendix: Solutions to the Odd-Numbered Problems
Index

Content preview from An Introduction to SAS University Edition

Chapter 3: Importing Your Own Data

Introduction

Exploring the Utilities Tab

Importing Data from an Excel Workbook

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

Introduction

In the last chapter, you saw how to use some of the features of SAS Studio to manipulate data from the built-in SAS data sets in Sashelp. In this chapter, you will see how easy it is to import your own data from Excel workbooks, CSV files, and many other file formats such as Access and SPSS to create SAS data sets.

Exploring the Utilities Tab

If you open up your Tasks tab in the navigation pane, you will see the following:

Figure 3.1: ...

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

Essential Statistics Using SAS University Edition

Publisher Resources

ISBN: 9781629600079

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

An Introduction to SAS University Edition

by Ron Cody