I'm having trouble importing an excel CSV document into SAS 9.4. (~2 million rows, should only be 60 variables upon import, but it >250 variables) The first thousand or so lines look good, but eventually SAS is reading in multiple observation lines and putting them into one line creating hundreds of extra variables. Here is the code I've used to import it. libname CDC "filepath"; PROC IMPORT OUT= cdc.filename DATAFILE= "filepath\file.csv" out=Q12018 dbms=csv replace; delimiter=',';guessingrows=max; getnames=no ; RUN; For example instead of data looking like this: ID visit number name 0 012 joe 1 123 jane 2 234 john It looks like this (after several thousand rows): ID visit number name var4 var5 var6 0 012 joe 1 123 jane 2 234 john Any help is appreciated! Thanks!
... View more