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 |
A Loumiotis <antonis.loumiotis@gmail.com> |

To |
statalist@hsphsun2.harvard.edu |

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

Date |
Thu, 27 May 2010 14:52:21 +0300 |

Thanks to all for your quick help! Nick: Your solution is perfect for me. Martin: I will check out descsave in case i need to go back to stata from a csv file. Antonis Loumiotis On Thu, May 27, 2010 at 2:41 PM, Martin Weiss <martin.weiss1@gmx.de> wrote: > > <> > > " I don't know how you'd reverse that in Excel. You would have a column of > variable labels. I understand that Excel users like to have such stuff as a > row." > > > > You can simply copy the column and then "Paste Special -> Transpose" to turn > it into a row. > > But reversing in Excel is not the only problem. The question is would you be > able to recreate the data in Stata from the csv? I bet not. So -ssc d > descsave- is still a competitor for this task, I think. > > > > HTH > Martin > > > -----Ursprüngliche Nachricht----- > Von: owner-statalist@hsphsun2.harvard.edu > [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Nick Cox > Gesendet: Donnerstag, 27. Mai 2010 13:28 > An: statalist@hsphsun2.harvard.edu > Betreff: RE: st: How can I transfer the variable labels to excel using the > outsheet command? > > This has never been my problem, but I can think of one work-around. > > Assuming the number of observations is at least as great as the number of > variables, you could copy the variable labels into a string variable and > export that too. > > unab vars : * > gen varlabel = "" > local i = 1 > > foreach v of local vars { > replace varlabel = `"`: var label `v''"' in `i' > local ++i > } > > I don't know how you'd reverse that in Excel. You would have a column of > variable labels. I understand that Excel users like to have such stuff as a > row. > > Nick > n.j.cox@durham.ac.uk > > A Loumiotis > > 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/ > > > * > * 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>

**RE: st: How can I transfer the variable labels to excel using the outsheet command?***From:*"Nick Cox" <n.j.cox@durham.ac.uk>

- Prev by Date:
**AW: st: How can I transfer the variable labels to excel using the outsheet command?** - Next by Date:
**st: RE: AW: RE: RE: RE: FW: Using regex to identify strings with capital letters** - Previous by thread:
**AW: st: How can I transfer the variable labels to excel using the outsheet command?** - Next by thread:
**st: AW: How can I transfer the variable labels to excel using the outsheet command?** - Index(es):