Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
AW: st: AW: list output transpose
From
"Martin Weiss" <[email protected]>
To
<[email protected]>
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: [email protected]
[mailto:[email protected]] Im Auftrag von Joerg
Eulenberger
Gesendet: Donnerstag, 11. März 2010 13:57
An: [email protected]
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: [email protected]
>> [mailto:[email protected]] Im Auftrag von Joerg
>> Eulenberger
>> Gesendet: Donnerstag, 11. März 2010 10:08
>> An: [email protected]
>> 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/