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.
Dominick A. Leone 