Bookmark and Share

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]

RE: st: How to rename value label names to match variable names?


From   "Martin Weiss" <[email protected]>
To   <[email protected]>
Subject   RE: st: How to rename value label names to match variable names?
Date   Sun, 16 May 2010 11:40:40 +0200

<>

You can also use NJC`s -labvalclone-, in combination with the -h extended_fcn-s:


***********
sysuse nlsw88, clear

//see initial state
d

capt which labvalclone
if _rc ssc inst labutil

//get all vars with value labels
ds, has(vallabel)

//cycle thru list and change val label name
foreach var of varlist `r(varlist)'{
	labvalclone "`:val lab `var''" "`var'"
	la val `var' `var' 
}

//see changes
d

//see whether labels are intact
ta race
ta occupation
***********


HTH
Martin


-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Tirthankar Chakravarty
Sent: Sonntag, 16. Mai 2010 11:13
To: [email protected]
Subject: Re: st: How to rename value label names to match variable names?

Martin,

Well-spotted. A simple fix is to use the -labmask, decode- option.
***********
sysuse auto
des
labmask foreign, values(foreign) decode
des
tab foreign
la li
***********

T

2010/5/16 Martin Weiss <[email protected]>:
>
> <>
>
> But T, after your code the name of the -value label- has been changed, but the labels ("domestic", "foreign") are gone as well. Anna declared herself satisfied, but I am not sure whether this is what she really wants.
>
>
> ***********
> sysuse auto
> des
> labmask foreign, values(foreign)
> des
> tab foreign
> la li
> ***********
>
>
> HTH
> Martin
>
>
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On Behalf Of Tirthankar Chakravarty
> Sent: Sonntag, 16. Mai 2010 08:45
> To: [email protected]
> Subject: Re: st: How to rename value label names to match variable names?
>
> You can easily change the name of the value label of a variable after
> you have renamed the variable, to match the new variable name, using
> Nick Cox's -labmask- utility, part of the -labutil- package (SSC):
> ***********************************
> sysuse auto
> des
> labmask foreign, values(foreign)
> des
> ***********************************
>
> T
>
>
> 2010/5/16 Anna Reimondos <[email protected]>:
>> Hello,
>> And thank you both for your suggestions.  I find it a bit hard to
>> articulate problems sometimes when it comes to variable names, value
>> names and value labels so my question was perhaps not very clear.
>>
>> I would like to rename the name of the labels rather than the names of
>> the variables.
>>
>> For example
>> sysuse, auto
>> des
>>
>> *Here I would want the value label called 'origin' to change to be
>> called 'foreign' to match the name of the variable name it is attached
>> to.
>>
>> As Phillip pointed out this is not necessary thing do to, but I must
>> do this because I am cleaning a survey dataset that has very
>> particular rules about how the variable names and value labels are
>> defined and they have asked me to do this....
>>
>> Thanks,
>> Anna
>>
>>
>>
>>
>> On Sun, May 16, 2010 at 12:46 PM, Tim Wade <[email protected]> wrote:
>>> I'm not 100% certain what you are asking but if you want to relabel
>>> the newly generated variables so that the labels are the same as the
>>> new variable names, this should work:
>>>
>>>
>>> sysuse auto.dta, clear
>>> rename make make1
>>> rename price price1
>>> desc make1 price1
>>> foreach var of varlist make1 price1 {
>>> label variable `var' "`var'"
>>> }
>>> desc make1 price1
>>>
>>>
>>>              storage  display     value
>>> variable name   type   format      label      variable label
>>> ----------------------------------------------------------------------------------------------------------------------------------------------------------------
>>> make1           str18  %-18s                  make1
>>> price1          int    %8.0gc                 price1
>>>
>>>
>>> Tim
>>>
>>> On Sat, May 15, 2010 at 10:06 PM, Anna Reimondos <[email protected]> wrote:
>>>> Hello,
>>>> The following problem has me stumped.
>>>> I have a dataset with variables which have been labelled with value
>>>> labels. Currently the variables are names as "a1, a2, a3" etc, and  I
>>>> need to rename all my variables so that they are listed as "V1, V2,
>>>> V3" etc. This I can easily do. The problem is that I also need to
>>>> rename all the value label names to match the new variable names.
>>>>
>>>> For example, the current situation is:
>>>>
>>>> varname  label name
>>>> ------------------------------
>>>>
>>>> a1            a1
>>>> a2            a2
>>>> a3            yesno
>>>> a4            gender
>>>> ------------------------------
>>>>
>>>> What I need to have is:
>>>>
>>>> varname  label name
>>>> ------------------------------
>>>>
>>>> V1            V1
>>>> V2            V2
>>>> V3            V3
>>>> V4            V4
>>>> ------------------------------
>>>>
>>>>
>>>> Does anyone have any suggestions on how I can rename the label names
>>>> to match the variable names? I found a number of similar questions on
>>>> Statalist but most seem to be going the other way (i.e from renaming
>>>> variables to match the label names)
>>>>
>>>> Thanks heaps
>>>> Anna
>>>>
>>>> *
>>>> *   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/
>>>
>>
>> *
>> *   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/
>>
>
>
>
> --
> To every ω-consistent recursive class κ of formulae there correspond
> recursive class signs r, such that neither v Gen r nor Neg(v Gen r)
> belongs to Flg(κ) (where v is the free variable of r).
>
> *
> *   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/
>



-- 
To every ω-consistent recursive class κ of formulae there correspond
recursive class signs r, such that neither v Gen r nor Neg(v Gen r)
belongs to Flg(κ) (where v is the free variable of r).

*
*   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/


© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index