Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: RE: mapping a value from 2 variables


From   "Nick Cox" <n.j.cox@durham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: mapping a value from 2 variables
Date   Wed, 24 Jul 2002 15:24:57 +0100

Joly.Patrick@ic.gc.ca
>
> Has anyone written a routine to define a value label
> mapping based on two
> variables (one numeric, one string)?  Several searches
> using findit did not
> turn up anything.  Normally, I wouldn't bother asking but I
> would find it
> surprising if no one had tried to automate this type of task before.
>
> For instance, I have many data files comprising industrial
> classification
> codes which I routinely merge to data for various projects.
>  One such
> example is my file for the NAICS (North American Industry
> Classification
> System) Codes, which contains the numerical variable
> _naics_ and string
> variable _labelnaics_
>
>  . list
>
>               naics                                   labelnaics
>     1.           11   Agriculture, Forestry, Fishing and Hunting
>     2.          111                              Crop Production
>     3.         1111                    Oilseed and Grain Farming
>     4.        11111                              Soybean Farming
>     5.       111110                              Soybean Farming
>     6.        11112             Oilseed (except Soybean) Farming
>     7.       111120             Oilseed (except Soybean) Farming
>     8.        11113                     Dry Pea and Bean Farming
>    ...
>
> I would like to define a value label such that each value
> of _naics_ would
> map to the corresponding value of _labelnaics_.   Encode
> will not do the
> trick here since it would be equivalent to:
>
>   label define naicslab 1 "Agriculture, Forestry, Fishing
> and Hunting"
>   label define naicslab 2 "Crop Production", add
>   label define naicslab 3 "Oilseed and Grain Farming", add
>   ...
>
>
> I could write my own .ado to create a do file similar to
> those generated by
> -label save ...-.  This could be done by:
> - sending the data to a comma-delimited file via -outsheet-
> - using the -file-command, replacing the first comma by a
> space character
> - prefixing each line by -label define-
> - suffixing by -, modify-
>
> But before I do that, has anyone seen such an .ado?

I don't know of anything quite like this, but
for once a looping over observations would seem
to solve the problem:

local N = _N
forval i = 1/`N' {
	local val = naics[`i']
	local label = labelnaics[`i']
	label def naicslab `val' "`label'" , modify
}

Nick
n.j.cox@durham.ac.uk

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   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   |   What's new   |   Site index