Skip to Main Content
Learning SAS by Example
book

Learning SAS by Example

by Ron Cody
July 2018
Beginner content levelBeginner
536 pages
12h 32m
English
SAS Institute
Content preview from Learning SAS by Example

Chapter 6: Reading and Writing Data from an Excel Spreadsheet

6.1  Introduction

6.2  Using the Import Wizard to Convert a Spreadsheet to a SAS Data Set

6.3  Creating an Excel Spreadsheet from a SAS Data Set

6.4  Using an Engine to Read an Excel Spreadsheet

6.5  Using the SAS Output Delivery System to Convert a SAS Data Set to an Excel Spreadsheet

6.6  A Quick Look at the Import Utility in SAS Studio

6.7  Problems

 

6.1  Introduction

It is quite common to be given a Microsoft Office Excel spreadsheet as your data source. Luckily, SAS has several methods to easily convert a spreadsheet into a SAS data set. One way is to convert the spreadsheet into a comma-separated values (CSV) file and to read the file using INFILE statements (using the DSD ...

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.
Start your free trial

You might also like

Learning SAS by Example

Learning SAS by Example

EdD Ron Cody
SAS in Practice

SAS in Practice

Ekta Saraogi
SQL for Data Analysis

SQL for Data Analysis

Cathy Tanimura

Publisher Resources

ISBN: 9781635266566