topic Import issue in SAS Procedures

Import issue

Kethy — Wed, 28 Dec 2011 16:15:45 GMT

Hi,

I have a table on MS Acess which has got more than 30 millions records. i want to convert that table into a dataset so tried importing the table in SASEG but since the number of records are more it errors out with a data load error message.

Can anybody help me to fix this issue.

Thanks!

Re: Import issue

Doc_Duke — Thu, 29 Dec 2011 01:57:32 GMT

I am assuming that SASEG refers to the SAS Enterprise Guide product. There is a SAS Enterprise Guide Forum that might get quicker and more pertinent answers than the general procedures one.

Can you include the section of SAS log that includes the generated code and the error message.

If you were just trying to open it by double-clicking on the file name, it was probably just running out of memory on your machine. You need to either

1) generate a SAS View into the Access table, or

2) copy into a SAS dataset.

The defaults are set in the Tools --> options, but you can override on a task-specific basis.

Doc Muhlbaier

Duke

Import issue

Kethy — Mon, 02 Jan 2012 17:09:54 GMT

Hi Doc@Duke,

Thanks for your reply.

Actually here i'm only trying to import a MS access table which has got 30 millions of records into a SAS dataset using the File-> Import data options in SAS Enterprise guide. But this import fails due too many observations. Is it possible to define prior the total number of observations that a SAS dataset could hold in it.?

Import issue

GreggB — Mon, 02 Jan 2012 19:10:02 GMT

Have you tried using PROC IMPORT? something like this....

proc import table="tbl1"

out=work.one

dbms=access replace;

database='C:\MyDatabase.mdb';

run;

Import issue

Doc_Duke — Tue, 03 Jan 2012 03:04:24 GMT

EGuide only displays a portion of the impoted data, so it can handle very large datasets. Sounds like a problem that you may want talk to tech support about.