Bookmark and Share

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]

Re: st: AW: create a dataset or vector of variable names


From   Eric Booth <ebooth@ppri.tamu.edu>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: AW: create a dataset or vector of variable names
Date   Wed, 24 Feb 2010 10:45:30 -0600

>

You might also try -descsave- from SSC, especially if you want to export more than just the varnames:

****
clear
ssc install descsave
sysuse auto
descsave, saving(vars, replace)

**export to spreadsheet**
use vars.dta, clear
outsheet using "vars.csv", comma replace

**
~ Eric

__
Eric A. Booth
Public Policy Research Institute
Texas A&M University
ebooth@ppri.tamu.edu
Office: +979.845.6754


On Feb 24, 2010, at 10:36 AM, Martin Weiss wrote:

> 
> <> 
> 
> 
> 
> *************
> sysuse auto, clear
> d, varlist
> gen str30 varnames=""
> 
> loc i 1
> foreach var of varlist `r(varlist)'{
> 	replace varnames="`var'" in `i'
> 	loc ++i
> }
> 
> keep varnames
> l in 1/20
> *************
> 
> 
> 
> HTH
> Martin
> 
> 
> -----Ursprüngliche Nachricht-----
> Von: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Sheena Sullivan
> Gesendet: Mittwoch, 24. Februar 2010 17:27
> An: statalist@hsphsun2.harvard.edu
> Betreff: st: create a dataset or vector of variable names
> 
> I would like to create a dataset of the variable names in a dataset (could
> also be a vector).  I have created data using matrices and would like to
> append it to my actual data, but I want to avoid having to manually type up
> the variable names, which I believe I will need to have in order to append
> the created data to the actual data.
> 
> In SAS, I can do this using a proc contents step
> proc contents data=dataset 
> 	out=varname position noprint;
> run;
> 
> which creates a dataset call varname.
> 
> but I'm trying to move away from SAS these days!
> 
> I read that I can get a variable list using 
> describe, varlist
> 
> but I can't figure how I can then use r(varlist) to assign variable names.
> What I would ideally like is something like this: 
> mat colnames mymatrix = r(varlist)
> 
> if you get what I mean.  In SAS it is simply a matter of assigning
> [colnames=varlist] when creating a dataset from a matrix.  
> 
> Any thoughts would be greatly appreciate as I have more than 100 variables.
> 
> Thanks, 
> Sheena  
> 




*
*   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–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index