Importing data from statistical

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;havenwill then automatically download the file for you before importing it.

# Load the haven package

library(haven)

# Import sales.sas7bdat: sales

sales<-read_sas("sales.sas7bdat")

# Display the structure of sales

str(sales)

When inspecting the result of the read_dta() call, you will notice that one column will be imported as a labelled vector, an R equivalent for the common data structure in other statistical environments. In order to effectively continue working on the data in R, it's best to change this data into a standard R class. To convert a variable of the classlabelledto a factor, you'll need haven's as_factor() function.

# Import the data from the URL: sugar

sugar<-read_dta("http://assets.datacamp.com/production/course_1478/datasets/trade.dta")

# Structure of sugar

str(sugar)

# Convert values in Date column to dates

sugar$Date<-as.Date(as_factor(sugar$Date))

# Structure of sugar again

str(sugar)

# Import person.sav: traits

traits<-read_sav("person.sav")

# Summarize traits

summary(traits)

# Print out a subset

subset(traits,Extroversion>40&Agreeableness>40)

# Import SPSS data from the URL: work

work<-read_sav("http://s3.amazonaws.com/assets.datacamp.com/production/course_1478/datasets/employee.sav")

# Display summary of work$GENDER

summary(work$GENDER)

# Convert work$GENDER to a factor

work$GENDER<-as_factor(work$GENDER)

# Display summary of work$GENDER again

summary(work$GENDER)

Foreign

Data can be very diverse, going from character vectors to categorical variables, dates and more. It's in these cases that the additional arguments of read.dta()    will come in handy.

The arguments you will use most often are convert.dates , convert.factors ,missing.type and convert.underscore . Their meaning is pretty straightforward, as Filip explained in the video. It's all about correctly converting STATA data to standard R data structures. Type?read.dtato find out about about the default values.

# Load the foreign package

library(foreign)

# Import florida.dta and name the resulting data frame florida

florida<-read.dta("florida.dta")

# Check tail() of florida

tail(florida,n=6)

# Specify the file path using file.path(): path

path<-file.path("worldbank","edequality.dta")

# Create and print structure of edu_equal_1

edu_equal_1<-read.dta(path)

str(edu_equal_1)

# Create and print structure of edu_equal_2

edu_equal_2<-read.dta(path,convert.factors=F)

str(edu_equal_2)

# Create and print structure of edu_equal_3

edu_equal_3<-read.dta(path,convert.underscore=T)

str(edu_equal_3)

# Import international.sav as a data frame: demo

demo<-read.spss("international.sav",to.data.frame=T)

# Create boxplot of gdp variable of demo

boxplot(x=demo$gdp)

# Import international.sav as demo_1

demo_1<-read.spss("international.sav",to.data.frame=T)

# Print out the head of demo_1

head(demo_1)

# Import international.sav as demo_2

demo_2<-read.spss("international.sav",to.data.frame=T,use.value.labels=F)

# Print out the head of demo_2

head(demo_2)