Re: st: using reshape

["Michael Blasnik" <michael.blasnik@verizon.net>]

Maybe I don't understand the problem, but if ir2 is the number of injuries 
reported and injnum is number for each injury created by reshape, why can't 
you just:

drop if injnum>ir2

immediately after the reshape?

Michael Blasnik
michael.blasnik@verizon.net

----- Original Message ----- 
From: <frone@ria.buffalo.edu>
To: <statalist@hsphsun2.harvard.edu>
Sent: Tuesday, September 12, 2006 12:52 PM
Subject: Re: st: using reshape



> Svend,
>
> Thanks again for your suggestions.
>
> You're right that I could create a set of -drop- statements to remove all
> null records (where all reshaped variables are missing) so that -reshape-
> would create the unbalanced data set I need.  Despite my general aversion
> to using SPSS, I took a look at their version of -reshape-, called
> -restructure-.  There is a handy option to drop all null records, which
> easily creates unbalanced data sets.  It would be nice if Stata's
> -reshape- command had such an option.  Given the likelihood of adding new
> variables as the data analysis progresses, I will likely use SPSS to
> reshape my data.
>
> Mike Frone
>
> ****************************************************************
> Michael R. Frone, Ph.D.
> Senior Research Scientist
> Research Institute on Addictions
> State University of New York at Buffalo
> 1021 Main Street
> Buffalo, New York 14203
*
*   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/