Proc import excel - Default character

[GreggB]

try this.  modify the path to find your data.  var is the name of column one so you may have to change it.

  libname db "C:\excel files\test1.xls"  mixed=yes;

   data test3;
     set db."Sheet1$"n(DBSASTYPE=(var='char(1024)'));
   run;

   libname db;

[NN]

Hi gregg,

The libname statement gives the following error

ERROR: Library DB is not in a valid format for access method RANDOM.

ERROR: Error in the LIBNAME statement.

I think what you have suggested would work on windows. But since i am on a Unix platform maybe it doenot work here.

Thanks...

[kleinhev]

Please see this thread:

[agoldma]

If you want PROC IMPORT to have an option to import all fields as character, please vote:

PROC IMPORT -- all fields as character