how to define variable when using Proc Import

[deleted_user]

Hi,
I want to import a .txt data to SAS using proc import. But SAS always truncates my string variables. e.g. EXCESSIVEWET is truncated to be EXCESSIV.

How do I define the length of variable while using proc import? the procedure that I used is:

Proc import datafile='C:\Nov.txt'
out=mylib.nov dbms=tab replace;
getnames=yes;
run;

Thanks

[LinusH]

You might want to check out the GUESSINGROWS option. It has a default of 20. This means that if your longer fields appear after 20 rows, IMPORT will not consider them when calculating the column length.

/Linus