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: Use varlabel in expressions
From
"Trelle Sven" <[email protected]>
To
<[email protected]>
Subject
st: RE: Use varlabel in expressions
Date
Fri, 23 Mar 2012 20:47:17 +0100
One possibility that should work (I acknowledge that I haven't tested it but it should give you the direction)
Sven
* ** code starts ** *
foreach var of varlist * {
local label: var label `var'
local match = substr("`label'",1,3)
if "`match'"=="na-" {
drop `var'
}
}
* ** code ends ** *
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Marcelo Lafleur
Sent: Freitag, 23. März 2012 19:54
To: [email protected]
Subject: st: Use varlabel in expressions
I've had not luck with this and all references in this list point to use of value labels.
My question is simple: How, if possible, to drop variables based on a prefix in their varlabels?
Examples:
... des mv218 mv225 mv245 mv246
variable name value label variable label
----------------------------------------------------------------------------
mv218 number of living children
mv225 mv225 na-current pregnancy wanted
mv245 women fathered children
with
mv246 mv246 na-married to mother when first
child was born
(I edited the output a bit)
I want to drop mv225 and mv246 by testing that the variable label starts with "na-"
Having hundreds of variables in each dataset, it would be impractical to do by hand.
Any ideas?
Marcelo
*
* 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/