Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
st: AW: Reshaping a Dataset
From
"Martin Weiss" <[email protected]>
To
<[email protected]>
Subject
st: AW: Reshaping a Dataset
Date
Fri, 23 Jul 2010 14:55:47 +0200
<>
The first table does not wrap well, so it is hard to tell what the -varname-s really are. It looks as if the columns contain both strings, to hold the site and county names, and numeric data, correct?
HTH
Martin
-----Ursprüngliche Nachricht-----
Von: [email protected] [mailto:[email protected]] Im Auftrag von [email protected]
Gesendet: Freitag, 23. Juli 2010 14:47
An: Statalist
Betreff: st: Reshaping a Dataset
I've been working on this for a while now, but obviously I do not yet understand what -reshape- needs to do its work.
Here is some data from the dataset:
site Crouse Garinger Arrowood County Line Rockwell Enochville Monroe
county Lincoln Burton Burton Burton Chance Chance Union
date
20050701 0.082 0.083 0.08
20050709 0.076 0.076
20050720 0.084 0.079
20050721 0.08 0.085
20050722 0.078
20050724 0.08
20050725 0.101 0.081 0.095 0.078 0.087 0.079
I want to reshape the dataset to look like:
date county site conc
20050701 Lincoln Crouse .
20050701 Burton Garinger 0.082
20050701 Burton Arrowood .
20050701 Burton County Line 0.083
20050701 Chance Rockwell .
20050701 Chance Enochville 0.08
20050701 Union Monroe .
etc. etc.
Can anyone assist me with this? Thanks much.
reg
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/