Bookmark and Share

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   Nick Cox <[email protected]>
To   "[email protected]" <[email protected]>
Subject   Re: st: RE: RE: Corrected Creating multiple observations from mixed observation?
Date   Wed, 21 Sep 2011 07:41:14 +0100

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/


© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index