Re: Problem importing data

[stephane.g.zebouni@jpmorgan.com]

Sorry for not precising at first that i was trying to import excel data

stephane.g.zebouni@jpmorgan.com Sent by: s-news-owner@lists.biostat.wustl.edu 08/17/2005 10:24 AM

To:        s-news@lists.biostat.wustl.edu         cc:                 Subject:        Re: [S] Problem importing data

Thanks everybody! it seems to work fine. I had been trying to import in .csv but at that time I still had the random seed problem that was making the import crash anyway. Thanks a lot guys! 

Stephane

"Bhandari, A (Arjun)" <a.bhandari@abp.nl> 08/17/2005 09:45 AM

To:        "'stephane.g.zebouni@jpmorgan.com'" <stephane.g.zebouni@jpmorgan.com>        cc:                Subject:        RE: [S] Problem importing data

Hi Stephane, 
  
I have had the problem in the past. some non technical fixes 
  
1. do not import excel but csv / txt files. csv works best. 
2. if possible upgrade to 6.2, these errors reduce dramatically then. 
3. sometimes the data item is locked in the _data directory, so if you have everything in scripts and data, then you might want to delete the project and recreate it, then run the scripts again. 
4. if you are getting the data from a sql server, check the flat file for any special characters. it occurs sometimes when data is got into a flat file from ms sql server. 
  
  
these worked for me in the past and i have had no problems since.

Best Regards,
Arjun Bhandari
Senior Portfolio Manager,
ABP Investments
Work: +31 20 40 69198
Mob : +31 653 610 424
Fax : +31 20 40 53961

-----Original Message-----
From: s-news-owner@lists.biostat.wustl.edu [mailto:s-news-owner@lists.biostat.wustl.edu]On Behalf Of stephane.g.zebouni@jpmorgan.com
Sent: Wednesday, August 17, 2005 3:18 PM
To: s-news@lists.biostat.wustl.edu
Subject: [S] Problem importing data


Hello,

I am using S-plus version 6.1 and I am getting a recurrent error when I try to import data:

 Bad ".Random.seed": should have 12 values: 0

I use the command rm(.Random.seed) that is suppposed to work ( http://www.biostat.wustl.edu/archives/html/s-news/2002-07/msg00168.html )
Nevertheless the problem keeps reapparing

and worse after removing that seed I still cant import all teh data I want - S-plus crashes after a long time when I try to import not-too-big files (bet 3 and 5 MB) that it used to import without any problem.

Thank you in advance for your help - these problems are totally really preventing me from working

Stephane Zebouni

This communication is for informational purposes only. It is not intended
as an offer or solicitation for the purchase or sale of any financial
instrument or as an official confirmation of any transaction. All market prices,
data and other information are not warranted as to completeness or accuracy and
are subject to change without notice. Any comments or statements made herein
do not necessarily reflect those of JPMorgan Chase & Co., its subsidiaries
and affiliates.




This communication is for informational purposes only. It is not intended
as an offer or solicitation for the purchase or sale of any financial
instrument or as an official confirmation of any transaction. All market prices,
data and other information are not warranted as to completeness or accuracy and
are subject to change without notice. Any comments or statements made herein
do not necessarily reflect those of JPMorgan Chase & Co., its subsidiaries
and affiliates.

This communication is for informational purposes only. It is not intended
as an offer or solicitation for the purchase or sale of any financial
instrument or as an official confirmation of any transaction. All market prices,
data and other information are not warranted as to completeness or accuracy and
are subject to change without notice. Any comments or statements made herein 
do not necessarily reflect those of JPMorgan Chase & Co., its subsidiaries 
and affiliates.