Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


[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" <agreenla@purdue.edu>
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
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: owner-statalist@hsphsun2.harvard.edu [owner-statalist@hsphsun2.harvard.edu] On Behalf Of Nick Cox [njcoxstata@gmail.com]
Sent: Wednesday, September 21, 2011 2:41 AM
To: statalist@hsphsun2.harvard.edu
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" <agreenla@purdue.edu>
wrote:

> Yes,
>
> They're attached in a .txt file
>
> Thanks for the help!
> ________________________________________
> From: owner-statalist@hsphsun2.harvard.edu [owner-
> statalist@hsphsun2.harvard.edu] On Behalf Of Kieran McCaul
> [Kieran.McCaul@uwa.edu.au]
> Sent: Tuesday, September 20, 2011 7:09 PM
> To: statalist@hsphsun2.harvard.edu
> Subject: st: RE: Corrected Creating multiple observations from mixed
> observation?
>
> ...
>
> Can you provide a couple lines of real data?
>
>
>
> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Greenland,
> Andrew N
> Sent: Wednesday, 21 September 2011 6:04 AM
> To: statalist@hsphsun2.harvard.edu
> 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/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index