No, the -set- statement is just fantasy syntax.
There was code in my program to get the names
out of the first row. I'd start from that.
See code for the -firstnames- option.
Nick
[email protected]
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]]On Behalf Of
> Wallace, John
> Sent: 12 October 2004 18:48
> To: [email protected]
> Subject: st: temporary variables (was: xpose or reshape)
>
>
> The final step in my original transposition problem was to get the
> variable names out of the first row of observations (see end of
> message). I've accomplished this with the following do-file
> code, but I
> suspect it could be tightened up some, particularly with regard to the
> way I'm handling a temporary variable.
>
> ----------begin good code--------------
> qui d
> local no_vars = r(k)
> forval i=1/`no_vars'{
> local tvarname: di _var`i'[1]
> gen tvar = "`tvarname'"
> qui replace tvar = lower(tvar)
> qui replace tvar = subinstr(tvar," ","",.)
> qui replace tvar = subinstr(tvar,"#","no_",.)
> qui replace tvar = subinstr(tvar,"%","pct_",.)
> qui replace tvar = subinstr(tvar,"(","_",.)
> qui replace tvar = subinstr(tvar,")","",.)
> local tvarname: di tvar[1]
> qui drop tvar
> capture rename _var`i' `tvarname'
> }
> drop in 1
> ---------end good code-----------------
>
> Rather than using -gen tvar- I thought I should be able to use
> . tempvar tvar
> . set `tvar'[1] = "'tvarname'"
> . qui replace `tvar' = lower(`tvar')
> etc
>
> but I get errors when I try this: -set __000000- not allowed;
> '__000000'
> not recognized
>
> -JW
>
> -----Original Message-----
> From: Nick Cox [mailto:[email protected]]
> Sent: Tuesday, October 12, 2004 5:08 AM
> To: [email protected]
> Subject: st: RE: RE: xpose or reshape
>
> A step or two more general. I'll post on SSC.
>
> *! NJC 1.0.0 12 Oct 2004
> program sxpose
> version 8
> syntax , clear [ firstnames destring ]
>
> (code snipped for brevity)
>
> Nick
> [email protected]
>
> > -----Original Message-----
>
> Wallace, John
> (snipped)
> It looks like a clear case for -xpose-, except that all the data are
> brought into Stata as strings because the first row (filenames) are
> strings. -xpose- results in an empty dataset. I'm looking at reshape
> and stack, but I can't figure out how they could accomplish what I'm
> looking for:
>
> v1 v2 v3 v4 v5
> v6 v7 v8
> 1 v1 . Date type group
> noise bkd bkdsd
> 2 v2 foo1.chp 10/11/2004 U133A_2 lymph 1.4
> 46.7 0.28
> 3 v3 foo2.chp 10/11/2004 U133A_2 lymph 1.24
> 50.4 0.28
> 4 v4 foo3.chp 10/11/2004 U133A_2 lymph 1.5
> 32.4 0.26
> 5 v5 foo4.chp 10/11/2004 U133A_2 heart 1.25
> 18.6 0.09
>
> (or actually, ideally)
>
> v1 Date type group noise
> bkd bkdsd
> 1 foo1.chp 10/11/2004 U133A_2 lymph 1.4 46.7
> 0.28
> 2 foo2.chp 10/11/2004 U133A_2 lymph 1.24 50.4
> 0.28
> 3 foo3.chp 10/11/2004 U133A_2 lymph 1.5 32.4
> 0.26
> 4 foo4.chp 10/11/2004 U133A_2 heart 1.25 18.6
> 0.09
>
> *
> * 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/
>
*
* 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/
