Help with reshape Data

Hey There,

I have a problem, I want to create a table from a data set. In the attachment is a picture of how it should look like. The data set is the following: http://farys.org/daten/sendcounty1997.dta
Does anyone have an idea how to make the data look like this? I can't get it to show me the names of the states and county....

Friendly regards

what format is a .dta file, is it a text file with some kind of delimiter ?

it's a .dta format. When I read it in, there are only numbers instead of states and county.

Its likely that these are .dta files that you can read by the foreign package

library(foreign)
contents_of_file <- read.dta("yourfile.dta")

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.