Re: st: save the value of a string variable into a macro

[Roger Newson <roger.newson@kcl.ac.uk>]

At 19:07 15/07/2004, Jean-Benoit Hardouin wrote:
> In my mail, you must replace "I want to save a specific values of the 
> variable "nomcom" into a variable, for example," by "I want to save a 
> specific values of the variable "nomcom" into a macro, for example,"
> JB Hardouin
>
> Jean-Benoit Hardouin a �crit:
>
>
> > I have a file like that :
> >
> > . list  depcom nomcom in 1/5
> >
> >     +-----------------------------+
> >     | depcom               nomcom |
> >     |-----------------------------|
> >  1. |  18001              Acheres |
> >  2. |  18002       Ainay-le-Vieil |
> >  3. |  18003   Les Aix-d'Angillon |
> >  4. |  18004              Allogny |
> >  5. |  18005              Allouis |
> >     +-----------------------------+
> >
> > Where depcom is an id. I want to save a specific values of the variable 
> > "nomcom" into a variable, for example, I want to obtain :
> > . di "`mymacro'"
> > Archeres
To save the value of a variable in a specific observation into a macro, use 
subscripting. For instance, to save the value of -nomcom- in observation 42 
into a macro -mymacro-, type

local mymacro=nomcom[32]

To save the value corresponding to a specific value of the ID variable 
-depcom-, for instance 18003, define a temporary variable and proceed as 
follows:

tempvar tv1
gene `tv1'=_n if depcom==18003
summ `tv1', meanonly
local index=r(min)
local mymacro=nomcom[`index']
drop `tv1'

This will set -mymacro- to the value of -nomcom- in the first observation 
for which -depcom- is equal to 18003, ie to " Les Aix-d'Angillon".

I hope this helps.

Roger


--
Roger Newson
Lecturer in Medical Statistics
Department of Public Health Sciences
King's College London
5th Floor, Capital House
42 Weston Street
London SE1 3QD
United Kingdom

Tel: 020 7848 6648 International +44 20 7848 6648
Fax: 020 7848 6620 International +44 20 7848 6620
  or 020 7848 6605 International +44 20 7848 6605
Email: roger.newson@kcl.ac.uk
Website: http://www.kcl-phs.org.uk/rogernewson

Opinions expressed are those of the author, not the institution.


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