Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | Nick Cox <njcoxstata@gmail.com> |
To | statalist@hsphsun2.harvard.edu |
Subject | Re: st: From: Abhimanyu Arora <abhimanyu.arora1987@gmail.com> |
Date | Mon, 2 Apr 2012 09:45:55 +0100 |
I see now. In fact your code did tell us what is going on. As you instructed, -save- will save the data as a Stata data file but with its original name and not with a .dta suffix. So, you should be read in each file with -use-. Nick P.S. -fs- is a user-written command from SSC. On Mon, Apr 2, 2012 at 9:36 AM, Abhimanyu Arora <abhimanyu.arora1987@gmail.com> wrote: > Hi Nick > Thanks for your email. > The problem as I perceive is that due to that line in the code -save > `file', replace- stata has changed my original *.csv files. Here is > one example on what a structured *.csv has been reduced to. > http://screencast.com/t/HU1Y4cPGelf > Before running the loop it was a table with numbers, the first column > being the time variable and each subsequent column being a time > series. > I was wondering whether there is a way to make stata reverse the process. > Hoping against hope > Abhimanyu > > > > > On Mon, Apr 2, 2012 at 10:28 AM, Nick Cox <njcoxstata@gmail.com> wrote: >> Without information on the _precise_ problem here, I think we are >> reduced to guessing. My guess is that you need to go back to the >> original *.csv. >> >> What "strange characters"? What does "not recognizable completely"? >> >> Nick >> >> On Mon, Apr 2, 2012 at 9:01 AM, <owner-statalist@hsphsun2.harvard.edu> wrote: >> >>> My data was in around 50 csv files in one folder. I wanted to merge >>> the data into a single stata dataset. So I used the following commands >>> in order to first create 50 stata datasets to be merged. >>> >>> >>> fs >>> >>> foreach file in `r(files)' { >>> insheet using `file' >>> save `file',replace >>> clear >>> } >>> >>> I now discover that the csv files have strange characters and the data >>> is not recognizable completely. Do you think it would be possible to >>> retrieve my data? * * 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/