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]

From |
"Martin Weiss" <martin.weiss1@gmx.de> |

To |
<statalist@hsphsun2.harvard.edu> |

Subject |
AW: st: How can I transfer the variable labels to excel using the outsheet command? |

Date |
Thu, 27 May 2010 13:16:35 +0200 |

<> " What I want is to export to a csv file not only the variable names but also the variable labels. Where would the csv-file put the variable label, though? Below the variable name, i.e. in the second row? You may want to look at Roger`s -ssc d descsave- which says in its mission statement: "descsave can be used together with outsheet and insheet to construct a definitive generic spreadsheet version of the data (in case the user needs to return to the data decades into the future, when all proprietary software has evolved beyond recognition)." HTH Martin -----Ursprüngliche Nachricht----- Von: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von A Loumiotis Gesendet: Donnerstag, 27. Mai 2010 13:11 An: statalist@hsphsun2.harvard.edu Betreff: Re: st: How can I transfer the variable labels to excel using the outsheet command? Dear Neil, Thanks a lot for your help. Yes what I'm actually doing is creating a csv file and i'm using excel to open it. But my problem with the variable labels still remain. My concern is not with the value labels of a categorical variable (which I know how to export to a csv file) but with the variable labels of the variable names. For example I have used: label variable var01 "this is variable one" to create the variable label "this is variable one" for variable var01. What I want is to export to a csv file not only the variable names but also the variable labels. On Thu, May 27, 2010 at 1:39 PM, Neil Shephard <nshephard@gmail.com> wrote: > On Thu, May 27, 2010 at 10:27 AM, A Loumiotis > <antonis.loumiotis@gmail.com> wrote: >> Dear Statalist, >> >> When I use the outsheet command the variable names but not the >> variable labels are transferred to excel. >> Is there any way to also transfer the variable labels to excel? > > As per the Statalist FAQ, it would be useful if you provided the > _exact_ command you are using. > > > 1. -outsheet- does not have the capacity to write Excel files. I > suspect you are writing to a CSV (Comma Separate Variables) file and > on your OS (I'll hazard a guess at some M$-Windows variant) this file > extension is associated with M$-Excel so that when double-clicked on > it opens up in that program. > > 2. The -outsheet- command should be default write out variables that > have labels applied to them using the labels themselves, unless you > have explicitly specified the -nolabel- option (as explained in -man > outsheet-). > > So, without knowing what you are doing I suspect you mistakenly using > the -outsheet using filename.csv, comma nolabel- (or similar) syntax, > and if you omit the -nolabel- option you should obtain what you are > after. > > Neil > > -- > "... no scientific worker has a fixed level of significance at which > from year to year, and in all circumstances, he rejects hypotheses; he > rather gives his mind to each particular case in the light of his > evidence and his ideas." - Sir Ronald A. Fisher (1956) > > Email - nshephard@gmail.com > Website - http://slack.ser.man.ac.uk/ > Photos - http://www.flickr.com/photos/slackline/ > * > * 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/

**References**:**st: How can I transfer the variable labels to excel using the outsheet command?***From:*A Loumiotis <antonis.loumiotis@gmail.com>

**Re: st: How can I transfer the variable labels to excel using the outsheet command?***From:*Neil Shephard <nshephard@gmail.com>

**Re: st: How can I transfer the variable labels to excel using the outsheet command?***From:*A Loumiotis <antonis.loumiotis@gmail.com>

- Prev by Date:
**Re: st: How can I transfer the variable labels to excel using the outsheet command?** - Next by Date:
**st: AW: AW: is looping slower** - Previous by thread:
**Re: st: How can I transfer the variable labels to excel using the outsheet command?** - Next by thread:
**RE: st: How can I transfer the variable labels to excel using the outsheet command?** - Index(es):