Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | "Martin Weiss" <martin.weiss1@gmx.de> |
To | <statalist@hsphsun2.harvard.edu> |
Subject | AW: st: AW: list output transpose |
Date | Thu, 11 Mar 2010 14:14:12 +0100 |
<> Say -keep in 2- if you want the second car... ************* sysuse auto, clear tempname hdle capt erase info.dta //for the first car in the dataset //depends on -sort- order... keep in 1 postfile `hdle' str30(varlabel value) /* */ using info foreach var of varlist _all{ local val = `var' post `hdle' ("`: var label `var''") ("`val'") } postclose `hdle' u info, clear l, noo ************* HTH Martin -----Ursprüngliche Nachricht----- Von: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Joerg Eulenberger Gesendet: Donnerstag, 11. März 2010 13:57 An: statalist@hsphsun2.harvard.edu Betreff: Re: st: AW: list output transpose Thanks Martin but i search only a other displayformat for the list-command-output. All data of one proband in an table with two columns. sysuse auto, clear foreach var of varlist * { char `var'[varname] "`: var label `var''" } keep in 1 list, noobs subvarname abbreviate(33) +--------------------------------------------------------------------------- ---+ | Make and Model | Price | Mileage (mpg) | Repair Record 1978 | Headroom (in.) | | AMC Concord | 4,099 | | 3 | 2.5 | |----------------------------------------+---------------------------------- ---| | Trunk space (cu. ft.) | Weight (lbs.) | Length (in.) | Turn Circle (ft.) | | 11 | 2,930 | 186 | 40 | |--------------------------------------------------------------------------- ---| | Displacement (cu. in.) | Gear Ratio | Car type | | 121 | 3.58 | Domestic | +--------------------------------------------------------------------------- ---+ The data display is correct but I want a output like this: Make and Model AMC Concord Price 4,099 Mileage (mpg) 22 Repair Record 1978 3 Headroom (in.) 2.5 ..... Car type Domestic Thanks, Jörg Joerg Eulenberger schrieb: > Dear Martin, > i want to show the label not the numeric value of the variable, if > there a label-set. Like by car type. > Jörg > > > > Martin Weiss schrieb: >> <> >> What do you want the second column to show? (What is " labelled >> output in >> the value-column."?) >> >> I recommend you apply the latest update (09mar2010) to Stata via -update >> all- and apply the brand new -desc, replace clear- command which >> gives you >> the variable labels in no time... >> >> >> >> >> HTH >> Martin >> >> >> -----Ursprüngliche Nachricht----- >> Von: owner-statalist@hsphsun2.harvard.edu >> [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Joerg >> Eulenberger >> Gesendet: Donnerstag, 11. März 2010 10:08 >> An: statalist@hsphsun2.harvard.edu >> Betreff: st: list output transpose >> >> Dear statalisters, >> i search a possibility to transpose the list-output for an >> individual-analysis. The origin dataset have over 4000 variables. >> The dataset include numeric and string variables. >> >> ***************** >> sysuse auto, clear >> foreach var of varlist * { >> char `var'[varname] "`: var label `var''" >> } >> keep in 1 >> list, noobs subvarname abbreviate(33) >> >> ????????????????????????????? >> >> ***************** >> and now, i search a possibility to transpose the outputtable. >> A table with two columns and a row for each variable. >> With subvarname in the label-column and labelled output in the >> value-column. >> >> Thanks, >> Jörg >> >> >> >> >> >> >> * >> * 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/ >> >> > > * > * 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/ * * 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/