BookmarkSubscribeRSS Feed
Kethy
Calcite | Level 5

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!

4 REPLIES 4
Doc_Duke
Rhodochrosite | Level 12

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

Kethy
Calcite | Level 5

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.?

Doc_Duke
Rhodochrosite | Level 12

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.

GreggB
Pyrite | Level 9

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

proc import table="tbl1"

              out=work.one

              dbms=access replace;

database='C:\MyDatabase.mdb';

run;

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 853 views
  • 0 likes
  • 3 in conversation