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]
Re: AW: st: AW: list output transpose
From
Joerg Eulenberger <[email protected]>
To
[email protected]
Subject
Re: AW: st: AW: list output transpose
Date
Fri, 12 Mar 2010 08:55:18 +0100
Thanks a lot Martin,
i found a solution to automate the decode part:
ds, has(vall)
foreach var of varlist `r(varlist)'{
decode `var',gen(`var'2)
move `var'2 `var'
drop `var'
}
that's what i want.
Thanks,
Jörg
Martin Weiss schrieb:
<>
I am not particularly proud of this, but here is a solution that does put
the value in there:
*******
sysuse auto, clear
tempname hdle
capt erase info.dta
//for the first car in the dataset
//depends on -sort- order...
keep in 1
decode foreign, gen(strforeign)
drop foreign
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
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Joerg Eulenberger
Sent: Donnerstag, 11. März 2010 19:35
To: [email protected]
Subject: Re: AW: st: AW: list output transpose
Tanks Martin its great.
Only one question.
In the case of the variable "car typ", is it possible to get the label
"domestic" in the output and not the value zero?
Tanks a lot,
Jörg
Martin Weiss schrieb:
<>
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/
*
* 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/