Problem: Proc Import will only check the first 20 rows of a spreadsheet to determine the data characteristics (type, length, etc).

Solution: Use GUESSINGROWS= <##> option to change the default (up to 32767).

Example:

PROC IMPORT OUT= WORK.artref
            DATAFILE= “P:\ART refusal\De_ID_Baseline20160430.csv”
            DBMS=CSV REPLACE;
            GETNAMES=YES;
            DATAROW=2;
            GUESSINGROWS=32767;
RUN;
Thank you: Hari Lyer, MPH, Harvard School of Public Health
For further info, see SAS documentation.