topic Re: Problem with the import of a database 5.1 version in SAS Enterprise Guide

Problem with the import of a database 5.1 version

Francisco — Tue, 17 Dec 2013 14:08:11 GMT

Hi to everybody. I have a little problem with the import of a Database. The database have MM 4.2 of lines, but the import task only make MM 4.08 of lines. In the version 4.1 I never had a problem, but a weeks ago it was upgrade to 5.1. I don't know what is the problem.

Thanks in advance for your help.

Regards,

Francisco.

Re: Problem with the import of a database 5.1 version

ChrisHemedinger — Tue, 17 Dec 2013 14:27:32 GMT

Hi Francisco,

We'll need a few more details. What form is the database? Is it an Excel file, CSV file, or MS Access?

Can you share more information about how the import is working? Screen shots of the import data task, etc.

If you can't share that on the forum, you may need to track with SAS Technical Support instead.

Chris

Re: Problem with the import of a database 5.1 version

Francisco — Wed, 18 Dec 2013 13:14:50 GMT

Hi Chris. Thanks for your response. This DB is a txt file and the size is 1.5 GB. I attached log, code, step by step of the import and example of the register of the DB.

Thanks in advance for your help.

Best,

Re: Problem with the import of a database 5.1 version

ChrisHemedinger — Wed, 18 Dec 2013 13:49:18 GMT

If you think that Enterprise Guide is somehow "dropping" records, you can try to tune the process a bit.

First, make sure the encoding is correct. I see you're running EG in Spanish, and the Windows-1252 encoding should be fine for your data (assuming it contains only the latin-1 characters), but that's something you can double-check.

Second, you can remove EG's "cleansing" step -- the step where it prepares a "clean" version of your data file before importing it. To do this, click the Performance button (Rendimiento in your Spanish interface), and then check the second option on that window. In English it's "Bypass the data cleansing process". This should cause EG to pass your raw text file "as is" to the server session for import.

Chris

Re: Problem with the import of a database 5.1 version

Francisco — Fri, 20 Dec 2013 18:20:19 GMT

Thanks a lot Chris!!! I solve the problem.

Thanks for your time and happy xmas.

Best,