Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: RE: -desc- output in excel


From   Radu Ban <rban@nber.org>
To   <statalist@hsphsun2.harvard.edu>
Subject   Re: st: RE: -desc- output in excel
Date   Tue, 1 Apr 2003 02:15:39 -0500 (EST)

thanks daniel,

actually i figured out an, admittedly ugly, method which works for me.
should anyone need it, here it is:


set obs 613; *i.e. the number of variables you have;

gen str1 variable = "";
gen str1 type = "";
gen str1 label = "";
local vlist "_all";

local i = 1;
foreach var of varlist `vlist' {;
	replace variable = `"`var'"' if _n == `i';
	local typ: type `var';
	replace type = `"`typ'"' if _n == `i';
	local lab: variable label `var';
	replace label = `"`lab'"' if _n == `i';
	local i = `i' + 1;
	};

list variable type label if variable ~= "";


the output of this code doesn't have wrapped lines, so excel reads it just
fine.


radu ban


On Tue, 1 Apr 2003, [iso-8859-1] Daniel Müller wrote:

> > i want to have a description file for my dataset (i.e.
> > names, types, labels).
> >
> > so i used -desc-, logged the output, saved as a text file
> > and opened it in excel. while excel did recognize that the text is
> > formatted as a table, some of the label names were too long and they
> > occupied more than one line.
> >
> > is there a way to make sure that the output of -desc-
> > is displayed such that each variable occupies only one row?
>
> I think -findit descsave- might do what you want (though I never tried it).
>
> Daniel
>
>
> *
> *   For searches and help try:
> *   http://www.stata.com/support/faqs/res/findit.html
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
>
>
>




*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index