topic proc dbload in SAS Procedures

proc dbload

helloSAS — Tue, 04 Sep 2012 14:13:03 GMT

I am using Proc dbload to load into excel file using following code. I got the below error. Can anyone tell me why dbload cannot load more than 16384 rows? What is the alternative code?

proc dbload dbms = excel data = c2&tapein;

path = &detail1;

putnames = yes;

limit = 0;

rename co ='Coll Office'

curr ='Currency'

load;

run;

ERROR: The maximum number of rows has been exceeded, no more observations will be loaded.

ERROR: Insert failed for obs number 16384.

Re: proc dbload

DanielSantos — Tue, 04 Sep 2012 15:09:25 GMT

Hello HelloSAS

Read this please:

https://communities.sas.com/thread/2158?start=0&tstart=0

Cheers from Portugal.

Daniel Santos @ www.cgd.pt

Re: proc dbload

SASKiwi — Tue, 04 Sep 2012 20:11:59 GMT

The number of rows an Excel spreadsheet can store depends on what version you are writing to. Prior to Excel 2008, 64K rows is the limit, so if you try PROC EXPORT as suggested in Daniel's link then you should be able to load at least 64K rows. From 2008 onwards the limit is 1 million rows.

Re: proc dbload

Ksharp — Wed, 05 Sep 2012 04:13:32 GMT

Why would you still use proc dbload.

It is outdated (too old product). only can read excel file before excel2003 .

Currently, We often use proc import or libname to import excel file.

Ksharp