<>
Just go for brute force then:
*******
clear*
inp byte col1 str5 col2
1 "Table"
2 "Chair"
end
l, noo
loc h ""
forv i=1/`=_N'{
loc h `h' `=col1[`i']' "`=col2[`i']'"
}
la def col1 `h'
la val col1 col1
//let`s see
list, noob
la li col1
*******
HTH
Martin
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of moleps
Sent: Sonntag, 3. Januar 2010 22:47
To: [email protected]
Subject: st: Setting label to adjoining column value
Dear listers,
I received an excel dataset with col1 identifiying productnumber, while col2
has the text variable for the productnumber.
Col1 col2
1 Table
2 Chair
etc.,etc
Now what I´d like to do is to automatically generate a label for col1
containing col2.
local j=0
global h=""
levelsof col2,local (u)
foreach var in `u'{
local j=`j'+1
global h $h `j'"`""`var'""'"
di "$h"
}
lab define col1 $h
lab val col1 col1
The di "$4" displays everything as planned, except for the sorting that has
been carried out by levelsof. Is there workaround ? As of now the values in
the columns dont match.
Regards,
M
*
* 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/
