[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
st: RE: -desc- output in excel
At 08:42 01/04/03 +0200, Daniel Müller wrote (in reply to Radu Ban):
Yes, -descsave- should do what Radu wants. If Radu types
> 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).
outsheet using desc1.txt,replace
then -desc1.txt- should be a generic tab-delimited worksheet importable
into Excel, with 1 observation per variable in the old data set and data on
variable names, types, formats, variable labels and value label names.
Lecturer in Medical Statistics
Department of Public Health Sciences
King's College London
5th Floor, Capital House
42 Weston Street
London SE1 3QD
Tel: 020 7848 6648 International +44 20 7848 6648
Fax: 020 7848 6620 International +44 20 7848 6620
or 020 7848 6605 International +44 20 7848 6605
Opinions expressed are those of the author, not the institution.
* For searches and help try: