[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: AW: from value to varnames

From   "Martin Weiss" <>
To   <>
Subject   st: AW: from value to varnames
Date   Mon, 18 May 2009 22:55:16 +0200



input str10 field	 str5	cat order  
namea		A	1
nameb B 2
namec F 5
named T 12

list, noobs 

forv i=1/`=_N'{
	egen `=field[`i']' = concat(cat order)

//counter to -replace- redundant stuff...
local cou =0

foreach var of varlist nam*{
	loc ++cou
	replace `var'="" if _n!=`cou'

list, noo



-----Ursprüngliche Nachricht-----
[] Im Auftrag von Richard
Gesendet: Montag, 18. Mai 2009 22:41
An: statalist
Betreff: st: from value to varnames


I have a data set with 3 variables: field, cat, order; there are 258 

I want the 258 observations in field to be 258 variables where the name 
of the value in field becomes the new variable name; I want to keep the 
associated values of the other two fields

For example, say that the first observation has the following values:

field		cat 	order
namea		A	1

I want a new set of variables such that I have a variable called "namea" 
and I still have cat (of "A") and order (of "1") -- but remember that I 
should now have 258 variables--cat and order can be joined as the value 
for each variable; thus, for the example above, the first variable 
(namea) would now have the value "A1"

I hope that this is sufficiently clear (note that there is no pattern in 
the values of field (the new varnames)


*   For searches and help try:

*   For searches and help try:

© Copyright 1996–2017 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index