Hi,

harbourcharles@JOHNDEERE.COM (Charles Harbour) wrote in message news:<200401231839.i0NIdaS20434@listserv.cc.uga.edu>... > Your dbload is probably the most efficient way to load your data. > Depending on how large your sas datasets are, it might be faster to scrub > your data first (assuming you have a short list of variables that you're > having trouble with), and then continue to use dbload. >

Runtime efficiency is of no concern here. Whether it takes 10 minutes or 10 seconds is not an issue. The thing is that these are read-only datasets, so if the formats are "wrong", then I can't change them.

> If you do decide to abandon the dbload, ask your sas contact for a copy of > their white paper 'The SAS/ACCESS Interface to DB2 on the mainframe using > the Libname engine'. I received an early release of the paper (don't know > if it's gone GA yet), and it has some outstanding tips on using explicit > vs. implicit sql (along with a lot of other pointers) on how to get the > most bang for your buck. Don't let the title of the paper fool you, their > recommendations are easily adapted to non-db2 databases on platforms other > than the host. > > Hope this helps > > CH

Thanks, I'll look into it.

Steve

ps BTW, does CREATE TABLE x AS SELECT * FROM y work in PROC SQL?