Could the length be formated when using proc import?

ybz12003 — Tue, 31 Oct 2017 15:47:52 GMT

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;

Re: Could the length be formated when using proc import?

Reeza — Tue, 31 Oct 2017 15:51:21 GMT

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.

topic Re: Could the length be formated when using proc import? in SAS Programming

Could the length be formated when using proc import?

Re: Could the length be formated when using proc import?