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]
RE: st: AW: Reshaping a Dataset
From
"Nick Cox" <[email protected]>
To
<[email protected]>
Subject
RE: st: AW: Reshaping a Dataset
Date
Fri, 23 Jul 2010 15:29:37 +0100
Still not clear to mee either. Please show us the results of
. describe
. list in 1/2
Nick
[email protected]
[email protected]
Yes, that is correct.
Martin Weiss <[email protected]>
>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?
[email protected]
>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.
*
* 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/