Number of charaters were truncationed in SAS

[zhangsh]

I used PROC IMPORT to read an Excel file into SAS. One of the variable contains a string of chacters with a length from 200 to 400 character depending on the record. I noticed that SAS did not read the whole string in, instead, a substantial part of the string was truncated and that's not what I want.

Any of you here ever experienced this situation and know hwo to fix it?

Thanks in advance.

 

[ChrisW75]

There's an option in Proc import called guessingrows=. Look that up, it should help you.
Basically put a line in the proc import step like this

   guessingrows=32767;

and that will hopefully help. Basically it tells SAS to examine the first 32767 records to determine the types and lengths of all the variables. That is the maximum value of that option.

Chris
Business Analyst, Code Monkey, Data Wrangler.
SAS Guru.