Could the length be formated when using proc import?

[ybz12003]

Hello:

I have a proc import code below.   I found some columns were truncated after the import procedure.   Could I format some specific column length to avoid this situation?  Thanks.

PROC IMPORT OUT=Poverty&state.&year

DATAFILE= "&importfolder.\&state.\&year.\Poverty&year..csv"

DBMS=CSV REPLACE;

GETNAMES=YES;

DATAROW=3;

RUN;

[Reeza · Accepted solution]

No. If you use PROC IMPORT you cannot specify column lengths/types, you need to use a data step to have full control. You can set GUESSINGROWS=MAX to see if PROC IMPORT works, but a data step is better in the long run. And it's faster.