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

Re: st: from long to wide

From   n j cox <>
Subject   Re: st: from long to wide
Date   Wed, 31 Oct 2007 12:58:59 +0000

If I understand correctly, I can only regard this constraint as
utterly stupid.

-reshape- can add no information that isn't there already.

I would fight this, and fight it hard. What's more,
I believe that StataCorp would be delighted to confirm
that -reshape- is no threat to anyone.

I don't think I want to try to answer the question otherwise.
How do I know what other commands are banned? However, one
route would involve lots of -separate- commands, -save-s
to different files and then -merge-ing.


How to reshape a data set from long form to wide form without using the
command reshape?

Say the data look like this

A 1 a
A 2 b
A 2 c
B 1 b
B 2 a

where HID and PID represent household and personal ids respectively, and
INJDAMC the damage type (eg, a=burns, b=bruising, c=..)in a person’s most recent injury.

(Recently I am working on a data set from a remote access data library.
The RADL receives STATA codes submitted by its users, it runs jobs and
returns outputs via its web interface. For confidentiality reasons, not
all the STATA commands are allowed in the RADL. One of these commands is
reshape, we know reshape a dataset won’t reveal extra information though.
I tried to program but failed. )

* For searches and help try:

© Copyright 1996–2017 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index