RE: st: adding variable name to value label

[Joe Canner <jcanner1@jhmi.edu>]

Lin,

I was going to suggest a solution to do this automatically, but it seems much more complicated than I first thought, depending on how many values each variable has.

For the examples you gave you could do something like:

foreach var of varlist Q* {     // or some other varlist
local labelname : value label `var'
local lab1 : label `labelname' 1
local lab2 : label `labelname' 2
label define `labelname' 1 `var'_'lab1' 2 `var'_`lab2'
label var `var' `labelname', modify
}

If you have more than two values for some variables, this could get more tedious or you will have to loop through the values using -levelsof'.  Let us know if this is the case and we can suggest further refinements.

Regards,
Joe Canner
Johns Hopkins University School of Medicine


-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Song, Lin
Sent: Thursday, September 26, 2013 12:47 PM
To: 'statalist@hsphsun2.harvard.edu'
Subject: RE: st: adding variable name to value label

Hi Steve, 

 Thanks for your reply.

Since I have over 100 variables, I was looking for a simple program that can add the variable name to the value label automatically.

Lin

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Steve Nakoneshny
Sent: Thursday, September 26, 2013 9:43 AM
To: statalist@hsphsun2.harvard.edu
Subject: Re: st: adding variable name to value label

Lin,