I would also suggest to include global macro names in {} (curly
braces): "${globalname1}${globalname2}`localname3'", whenever globals
are used in concatenations such as file names or parts of variables'
names. Local names are clearly delimited with quotes, whereas globals'
are not.
Vladimir.
2008/4/9, nikh 2000 <[email protected]>:
> Thanks Nick, it worked!!
>
>
>
>
> On Wed, Apr 9, 2008 at 2:57 PM, Nick Cox <[email protected]> wrote:
> > My guess: Don't use \ as a separator within filenames.
> > Use a /, even with MS Windows as your operating system.
> > This is documented e.g. [U] 18.3.11.
> >
> > Nick
> > [email protected]
> >
> > nikh 2000
> >
> > In the following program I was trying to read a Access table using
> > ODBC command. It works fine except with saving command. I want to save
> > Stata file in the same name as Access file. When I used method-1 it
> > didn't work. Method-2 works fine. But I don't want to add any prefix
> > in the filename I saved. Any Idea how I could save without any
> > prefix?. I have to convert and save many Access tables into Stata
> > format.
> >
> > Method-1:
> > cap prog drop readdata
> > prog def readdata
> > clear
> > odbc load, dsn("MS Access Database; DBQ=$acdata_sc")
> > table("`1'") lower
> > count
> > save $data_sc\`1',replace
> > end
> >
> > readdata assetstatus
> >
> > **
> > . readdata assetstatus
> > 3351
> > invalid '`'
> > r(198);
> >
> >
> > Method-2:
> > cap prog drop readdata
> > prog def readdata
> > clear
> > odbc load, dsn("MS Access Database; DBQ=$acdata_sc")
> > table("`1'") lower
> > count
> > save x`1',replace
> > end
> >
> > . readdata assetstatus
> > 3351
> > (note: file C:\xassetstatus.dta not found)
> > file C:\xassetstatus.dta saved
> >
> > *
> > * 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/
> >
> *
> * 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/
>
--
__________________
Volodymyr Vakhitov
[email protected]
*
* 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/
