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

Re: st: sequential file conversion possible ?


From   Steven Dubnoff <[email protected]>
To   [email protected]
Subject   Re: st: sequential file conversion possible ?
Date   Thu, 07 Apr 2005 09:34:46 -0700

At 06:12 AM 4/7/2005, you wrote:
Dear Statalisters,

I have multiple (more than 20) Excel-format files, named like
mat1983.xls, mat1984.xls etc.


And I'd like to convert them into Stata-format ones using
StatTransfer. But it is tedious to do so one by one.
The Stat/Transfer command processor allows wildcard transfers so:

        copy mat*.xls *.dta

will work.  This can also be done from the OS command line as in:

        st mat*.xls *.dta

or from within Stata with stcmd:

        stcmd mat*.xls *.dta.

Best,

Steve








----------------------------------------------------------------
Steven Dubnoff              [email protected]
Circle Systems              We make your data instantly usable.
Download Stat/Transfer from http://www.stattransfer.com
1001 Fourth Avenue, #3200   (206) 682-3783
Seattle, WA 98154           Fax (206) 328-4788



*
*   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–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index