Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.

# st: extract rownames corresponding to data as unique codes

 From Judy You To statalist@hsphsun2.harvard.edu Subject st: extract rownames corresponding to data as unique codes Date Mon, 11 Jul 2011 10:00:53 +0930

```Dear Stata Experts,

Cheers

---------- Forwarded message ----------
From: Judy You <joodyu@gmail.com>
Date: 2011/7/7
Subject: st: extract rownames corresponding to data as unique codes
To: statalist@hsphsun2.harvard.edu

Dear Stata experts:

I am running a “dstdize” age-standardised rate syntax and got a result
with Crude and age-adjusted rate, together with lower and upper limit.

The age adjusted rate is reported by SLA level (which there are 95
rows or records). I have save the matrix in a file but the result
doesn’t come along with SLA code. I could force it to do by merge the
predefined file with sla code to the one saved in the matrix. I
believer there should be the smart way to do.

----------

. qui dstdize freq pop sex agegp, by(sla) using (t0)

. drop _all

. return list

scalars:
r(k) =  95

macros:
r(by) : "sla"
r(c95) : "`"5050"'"
r(c94) : "`"5000"'"
r(c93) : "`"4809"'"
------
r(c3) : "`"205"'"
r(c2) : "`"203"'"
r(c1) : "`"201"'"

matrices:
r(se) :  1 x 95
r(ub) :  1 x 95
r(lb) :  1 x 95
r(crude) :  1 x 95
r(Nobs) :  1 x 95

. matrix C = r(crude)', r(adj)', r(lb)' , r(ub)'

. svmat C, names(col)
number of observations will be reset to 95 Press any key to continue,
or Break to abort obs was 0, now 95

. save t1,replace
file t1.dta saved

.0144418        .0213993        .0160632        .0267354
.0242798        .0409689        .030746 .0511917
.0123417        .0186174        .0149574        .0222773
.0097357        .0142612        .0108197        .0177028
.0260393        .051086 .0389991        .0631729

-----

The saved file looks like that, but what I like is to have a column
named as SLA, corresponding to the SLA codes in the original data.
Could any expert give me some hint?

Cheers

Judy

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