Rajesh,
What are you trying to achieve? Do you want to use only one program
or do you want to use only Stat/Transfer? Are you familiar with
Stata's -shell- command? I would do the following:
1. Write a Stat/Transfer command file to convert the Excel files to
Stata format.
2. Write a Stata do-file that (a) calls the Stat/Transfer command
file with -shell- and (b) combines the files with -append-.
3. Run the Stata do-file to convert and combine the Excel files in
one go.
Another option is the Stata module -stcmd- (-ssc d stcmd-) to avoid
the use of Stat/Transfer command files.
Friedrich
--- Rajesh Tharyan <[email protected]> wrote:
> I have a number (3000) of excel files that i need to convert to dta
> files and i need to append them together. I can use the command
> line interface of stat transfer and convert them and then write a
> do file in stata to append them together. However i was wondering
> if the same can
> be done in one go using stat trasfer. i.e to convert the files and
> append them togther using the stat transfer command line interface.
> I read it someplace and had book marked the page unfortunately the
> bookmark has disappeared!
>
> regards
> rajesh
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
*
* 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/
