Creating Crosstabulation Tables in R
Below is computer code written in the R programming language that creates crosstabulation tables between two variables in R. Just copy and paste it into R and watch it rip. Then try changing the format of the tables from SAS to SPSS. The data set for this R program can be found HERE.
# First, load a library that will build nice crosstabulation tables
library(gmodels)
# Now we get our data.
mydata < read.table("panel80.txt")
names(mydata) # This shows us all the variable names.
mynewdata < mydata[ which(mydata$VOTE <= 2), ] # This gets rid of observations where votes went to minor candidates.
# Now we create an income category variable based on the mean for use in a table.
mynewdata$incomecategories < ifelse(mynewdata$INC < mean(mynewdata$INC, na.rm = TRUE), 1, 2) # One way to recode variables.
CrossTable(mynewdata$SEX, mynewdata$VOTE, chisq=TRUE, expected = TRUE, format="SAS")
CrossTable(mynewdata$incomecategories, mynewdata$VOTE, chisq=TRUE, expected = TRUE, format="SAS")
