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
Thanks, I'll look into it.
ps BTW, does CREATE TABLE x AS SELECT * FROM y work in PROC SQL?