[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
Re: st: reshape error
At 07:12 PM 3/12/2007, Rodrigo Martell wrote:
I have a dataset that looks like this:
Looks to me that the variables you are attempting to reshape are
qld_p nsw_p, which share a common suffix.
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)
Frontier Economics Pty. Ltd.
395 Collins Street
Melbourne VIC 3000
-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-
* For searches and help try: