Re: st: From: Abhimanyu Arora <abhimanyu.arora1987@gmail.com>

[Abhimanyu Arora <abhimanyu.arora1987@gmail.com>]

Thanks a lot Nick, data recovered using -use-.
And thanks for your useful command, -fs- as well.
Cheers
Abhimanyu


On Mon, Apr 2, 2012 at 10:45 AM, Nick Cox <njcoxstata@gmail.com> wrote:
> 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/

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