Import SAS data with haven

haven is an extremely easy-to-use package to import data from three software packages: SAS, STATA and SPSS. Depending on the software, you use different functions:

SAS: read_sas()
STATA: read_dta() (or read_stata(), which are identical)
SPSS: read_sav() or read_por(), depending on the file type.

All these functions take one key argument: the path to your local file. In fact, you can even pass a URL; haven will then automatically download the file for you before importing it.

You'll be working with data on the age, gender, income, and purchase level (0 = low, 1 = high) of 36 individuals (Source: SAS). The information is stored in a SAS file, sales.sas7bdat, which is available in your current working directory. You can also download the data here.

This exercise is part of the course

Intermediate Importing Data in R

Exercise instructions

Load the haven package; it's already installed on DataCamp's servers.
Import the data file "sales.sas7bdat". Call the imported data frame sales.
Display the structure of sales with str(). Some columns represent categorical variables, so they should be factors.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

# Load the haven package


# Import sales.sas7bdat: sales


# Display the structure of sales

Edit and Run Code

This exercise is part of the course

Intermediate Importing Data in R

IntermediateSkill Level

4.8+

Start Course for Free

Many companies store their information in relational databases. The R community has also developed R packages to get data from these architectures. You'll learn how to connect to a database and how to retrieve data from it.

Exercise 1: Connect to a database Exercise 2: Establish a connection Exercise 3: Inspect the connection Exercise 4: Import table data Exercise 5: List the database tables Exercise 6: Import users Exercise 7: Import all tables Exercise 8: How do the tables relate?

Importing an entire table from a database while you might only need a tiny bit of information seems like a lot of unncessary work. In this chapter, you'll learn about SQL queries, which will help you make things more efficient by performing some computations on the database side.

Exercise 1: SQL Queries from inside R Exercise 2: Query tweater (1)Exercise 3: Query tweater (2)Exercise 4: Query tweater (3)Exercise 5: Query tweater (4)Exercise 6: Join the query madness!Exercise 7: DBI internals Exercise 8: Send - Fetch - Clear Exercise 9: Be polite and ...

More and more of the information that data scientists are using resides on the web. Importing this data into R requires an understanding of the protocols used on the web. In this chapter, you'll get a crash course in HTTP and learn to perform your own HTTP requests from inside R.

Exercise 1: HTTP Exercise 2: Import flat files from the web Exercise 3: Secure importing Exercise 4: Downloading files Exercise 5: Import Excel files from the web Exercise 6: Downloading any file, secure or not Exercise 7: Reading a text file from the web Exercise 8: HTTP? httr! (1)Exercise 9: HTTP? httr! (2)

Importing data from the web is one thing; actually being able to extract useful information is another. Learn more about the JSON format to get one step closer to web domination.

Exercise 1: APIs & JSON Exercise 2: From JSON to R Exercise 3: Import JSON data from API Exercise 4: OMDb API Exercise 5: JSON & jsonlite Exercise 6: JSON practice (1)Exercise 7: JSON practice (2)Exercise 8: toJSON()Exercise 9: Minify and prettify

Next to R, there are also other commonly used statistical software packages: SAS, STATA and SPSS. Each of them has their own file format. Learn how to use the haven and foreign packages to get them into R with remarkable ease!

Exercise 1: haven Exercise 2: Import SAS data with haven

Current Exercise

Exercise 3: Import STATA data with haven Exercise 4: What does the graphic tell?Exercise 5: Import SPSS data with haven Exercise 6: Factorize, round two Exercise 7: foreign Exercise 8: Import STATA data with foreign (1)Exercise 9: Import STATA data with foreign (2)Exercise 10: Do you know your data?Exercise 11: Import SPSS data with foreign (1)Exercise 12: Excursion: Correlation Exercise 13: Import SPSS data with foreign (2)