Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

RE: st: reshape error


From   "Rodrigo Martell" <rodrigo.martell@frontier-economics.com.au>
To   <statalist@hsphsun2.harvard.edu>
Subject   RE: st: reshape error
Date   Tue, 13 Mar 2007 11:27:42 +1100

Ah! Yes! It's always something simple.
Cheers David!

Rodrigo

Rodrigo Martell

 <http://www.frontier-economics.com> 	
Frontier Economics Pty. Ltd.
395 Collins Street
Melbourne VIC 3000
Australia
www.frontier-economics.com 	
switch:
direct:
fax:
mobile:
email:


+61 (0)3 9620 4488
+61 (0)3 9613 1518
+61 (0)3 8614 2711
+61 (0)407 909 811
rodrigo.martell@frontier-economics.com <mailto:rodrigo.martell@frontier-economics.com> 


This e-mail, including any attachments, may contain confidential and privileged information for the sole use of the intended recipient(s). Any review, use, disclosure or distribution by others is strictly prohibited. If you are not the intended recipient (or authorised to receive information for the recipient), please contact the sender by reply e-mail and delete all copies of this message. Thank you.

	



-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu]On Behalf Of David Kantor
Sent: Tuesday, 13 March 2007 11:27 AM
To: statalist@hsphsun2.harvard.edu
Subject: Re: st: reshape error


At 07:12 PM 3/12/2007, Rodrigo Martell wrote:
>I have a dataset that looks like this:
>SETTLEMENTDATE qld_p nsw_p
>1/01/2004 4:30 14.90673 14.67833
>1/01/2004 5:00 14.74838 14.58328
>1/01/2004 5:30 14.54922 14.6783
>1/01/2004 6:00 14.16048 14.59497
>1/01/2004 6:30 13.8505 14.69998
>1/01/2004 7:00 13.09797 14.6587
>1/01/2004 7:30 14.8116 15.92572
>
>
>I've reshape things like this before using something like
>
>-reshape long _p, i(SETTLEMENTDATE) j(State) string-
>
>However, this command now gives me an error (r(111)), "no xij 
>variables found". Can anyone see what's going wrong?
>(settlementdate is stored as a string by the way)
>
>Thanks,
>
>Rodrigo
>
>Rodrigo Martell
>
>  <http://www.frontier-economics.com>
>Frontier Economics Pty. Ltd.
>395 Collins Street
>Melbourne VIC 3000
>Australia
>www.frontier-economics.com

Looks to me that the variables you are attempting to reshape are 
qld_p nsw_p, which share a common suffix.
-reshape- expects the variables to share a common prefix.

Try renaming them to p_qld and p_nsw; then,...
-reshape long p_, i(SETTLEMENTDATE) j(State) string-

HTH
--David

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   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   |   What's new   |   Site index