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 ?

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

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

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

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