Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


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

Re: st: AW: list output transpose


From   Joerg Eulenberger <j.eulenberger@web.de>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: AW: list output transpose
Date   Thu, 11 Mar 2010 13:57:17 +0100

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/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index