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 at the end of May, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: RE: runing StatTransfer "set" command from Stata do-file


From   Chamara Anuranga <kcanuranga@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: RE: runing StatTransfer "set" command from Stata do-file
Date   Thu, 13 Sep 2012 20:29:10 +0530

xls2dta program need Stata 12.1. If you are using Stata 12 you can use
loop (foreach) command to convert xls data to Stata without using any
user written program.
thanks,
Chamara

On Thu, Sep 13, 2012 at 8:23 PM, Reg Jordan <drreg@earthlink.net> wrote:
> Have you considered using xls2dta (Klein)? See
> http://www.stata.com/statalist/archive/2012-09/msg00394.html
>
> Hope this helps.
>
> reg
>
> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Lucas Ferreira
> Mation
> Sent: Thursday, September 13, 2012 10:34 AM
> To: statalist
> Subject: st: runing StatTransfer "set" command from Stata do-file
>
> Dear all,
>
> my trying to import some .xls files to Stata. I惴 using StatTtransfer11, and
> trying to automate the process, controlled from my do file.
> The problem is that I need to issue the StatTransfer command  "set
> WKS-NAME-ROW First-Row" before running the actual conversion (StatTransfer
> command "copy").
>
> As far as I can tell, there are two ways to send commands to StatTransfer:
>
> - from the StatTransfer prompt (that blue window), typing specific
> StatTransfer commands like "set" and "copy"
> - from the operating system prompt with the "st" command. This is what the
> Stata command "stcmd" uses to send commands to StatTransfer.
>
> The problem seems to be that I can愒 issue a "set" or other StatTransfer
> commands from the OS prompt, only from the StatTransfer prompt.
>
> Does anyone knows how this could be solved?
>
> regards
> Lucas Mation
>
> *
> *   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/
>
>
> *
> *   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/

*
*   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