Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: From: D.Ronayne@warwick.ac.uk


From   owner-statalist@hsphsun2.harvard.edu
To   "Stata List" <statalist@hsphsun2.harvard.edu>
Subject   st: From: D.Ronayne@warwick.ac.uk
Date   Fri, 13 Aug 2010 20:47:57 +0100

Dear all,

I wish to delete "cells" (not observations, aka rows) that have missing
values for variable x only within x. Hence,

"drop if x==."

would not work because it will delete the observations across all
variables, to explain graphically, I want something that looks like this:

variable x
0.998
.
.
.
0.658
.
7.801
.

to become:
0.998
0.658
7.801

without disturbing the other variables in the dataset. Manually
manipulating in Excel is not an option because this is done half way
through a do file and must be done by written commands. Stata is very easy
to use to drop variables and observations, but can it delete specific
"cells"?

Can anyone help here?

Any advice much appreciated,
David
*
*   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–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index