Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | Judy You <joodyu@gmail.com> |
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, I haven't received any comments and thought just send it again! 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. Here is my log file. Thanks for your help in advance! ---------- . 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(adj) : 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 Crude Adjusted Left Right .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/