Proc import

[Peter_C]

Art

as you haven't mentioned it, I might be bringing up an idea that is as  new to you as it was to me (last week!)

Use the SASTRACE option before PROC IMPORT from excel file types, to see the underlying SAS SQL code with options passed into excel (a bit like getting the code for CSV import).

The standard sastrace option I used :

options sastrace=',,,d' sastraceloc=saslog nostsuffix;

The examples in the documentation of SASTRACE reveal an even greater degree of detail might be available.

regards

Peter

[art297]

: No, that was new to me as well!  Yes, some other option settings would be needed to see exactly what they (SAS) did, and how, but it appears that the import is simply using the excel engine in a libname statement and then running proc sql and setting everything needed using various dbdsopts settings.  Yes, definitely similar to getting the code for CSV imports.

Much appreciated,

Art