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: RE: RE: Corrected Creating multiple observations from mixed observation?
From
"Greenland, Andrew N" <[email protected]>
To
"[email protected]" <[email protected]>
Subject
RE: st: RE: RE: Corrected Creating multiple observations from mixed observation?
Date
Wed, 21 Sep 2011 08:32:22 -0400
Nick,
This is roughly the pattern. Occasionally the second line will read before the first, etc.
Assuming I can identify which pattern goes where, How do I insert a new blank observation and fill it with the
extracted info.
Andrew
________________________________________
From: [email protected] [[email protected]] On Behalf Of Nick Cox [[email protected]]
Sent: Wednesday, September 21, 2011 2:41 AM
To: [email protected]
Subject: Re: st: RE: RE: Corrected Creating multiple observations from mixed observation?
Your example implies that some lines of data are as wished and some
are not. Also, your example seems to contradict your pattern. This
might be fixable by some programming, or you might be better advised
to go back to your source and indicate that the data structure is a
mess.
Nick
On 21 Sep 2011, at 02:56, "Greenland, Andrew N" <[email protected]>
wrote:
> Yes,
>
> They're attached in a .txt file
>
> Thanks for the help!
> ________________________________________
> From: [email protected] [owner-
> [email protected]] On Behalf Of Kieran McCaul
> [[email protected]]
> Sent: Tuesday, September 20, 2011 7:09 PM
> To: [email protected]
> Subject: st: RE: Corrected Creating multiple observations from mixed
> observation?
>
> ...
>
> Can you provide a couple lines of real data?
>
>
>
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]] On Behalf Of Greenland,
> Andrew N
> Sent: Wednesday, 21 September 2011 6:04 AM
> To: [email protected]
> Subject: st: Corrected Creating multiple observations from mixed
> observation?
>
> I need to insert a new observation into the dataset I am working on.
> Multiple row's from a spreadsheet have been read into the same column
> and I need to separate them and insert them into the dataset.
>
> The data should Look as follows:
> var1 var2 var3
> NAME1 Price1 Price2
> NAME2 Price3 Price4
>
> Instead they look take on a pattern like this:
> var1 var2 var3
> NAME1NAME2 Price1Price3 Price2Price4
>
*
* 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/