importing an excel with over 1,024 characters

Quartz | Level 8

I have an Excel file with a variable that has observations over 1,024 characters.

Currently I'm only able to proc import 1,024 characters.

How do I fix this?

I'm using SAS 9.2.

Thank you.

1 REPLY 1

Opal | Level 21

Posted 07-15-2011 01:48 PM (1542 views) | In reply to gzr2mz39

If you are using a libname statement include dbMax_text=32767 in the statement.

Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.

SAS Training: Just a Click Away