Help using Base SAS procedures

how to define variable when using Proc Import

Reply
N/A
Posts: 0

how to define variable when using Proc Import

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
Super User
Posts: 5,260

Re: how to define variable when using Proc Import

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
Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 105 views
  • 0 likes
  • 2 in conversation