Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
st: RE: From: [email protected]
From
"Martin Weiss" <[email protected]>
To
<[email protected]>
Subject
st: RE: From: [email protected]
Date
Fri, 13 Aug 2010 22:00:12 +0200
<>
You can -sort- on the variable to assemble all the values other than
missings at the top. But the other variables will move as well...
***********
clear*
inp x
0.998
.
.
.
0.658
.
7.801
.
end
gen byte othervar=_n
so x
list, noo
***********
HTH
Martin
-----Original Message-----
From: [email protected]
[mailto:[email protected]]
Sent: Freitag, 13. August 2010 21:48
To: Stata List
Subject: st: From: [email protected]
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/
*
* 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/