Bookmark and Share

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/


© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index