Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: From: Abhimanyu Arora <[email protected]>
From
Nick Cox <[email protected]>
To
[email protected]
Subject
Re: st: From: Abhimanyu Arora <[email protected]>
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
<[email protected]> 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 <[email protected]> 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, <[email protected]> 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/