I have a csv file of 232,190 rows and 9 columns. When I import data into sas, sas only extracts the first 1,011 rows and 9 columns. How can I import all the rows available without losing any data from the csv file? Here is the log result: 237 data WORK.announcement ; 238 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ 239 infile 'D:\Dropbox\Dataset\9ee779962de5b464.csv' 239! delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ; 240 informat CompanyName $38. ; 241 informat DirectorName $19. ; 242 informat CommitteeName $12. ; 243 informat JobName $27. ; 244 informat Description $99. ; 245 informat AnnouncementDate best32. ; 246 informat CompanyID best32. ; 247 informat DirectorID best32. ; 248 informat EffectDate best32. ; 249 format CompanyName $38. ; 250 format DirectorName $19. ; 251 format CommitteeName $12. ; 252 format JobName $27. ; 253 format Description $99. ; 254 format AnnouncementDate best12. ; 255 format CompanyID best12. ; 256 format DirectorID best12. ; 257 format EffectDate best12. ; 258 input 259 CompanyName $ 260 DirectorName $ 261 CommitteeName $ 262 JobName $ 263 Description $ 264 AnnouncementDate 265 CompanyID 266 DirectorID 267 EffectDate 268 ; 269 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ 270 run; NOTE: The infile 'D:\Dropbox\Dataset\9ee779962de5b464.csv' is: Filename=D:\Dropbox\Dataset\9ee779962de5b464.csv, RECFM=V,LRECL=32767,File Size (bytes)=39898957, Last Modified=10,November,2020 13:48:22, Create Time=08,February,2022 15:21:23 NOTE: 1011 records were read from the infile 'D:\Dropbox\Dataset\9ee779962de5b464.csv'. The minimum record length was 98. The maximum record length was 312. NOTE: The data set WORK.ANNOUNCEMENT has 1011 observations and 9 variables. NOTE: DATA statement used (Total process time): real time 0.11 seconds cpu time 0.07 seconds 1011 rows created in WORK.announcement from D:\Dropbox\Dataset\9ee779962de5b464.csv. NOTE: WORK.ANNOUNCEMENT data set was successfully created. NOTE: The data set WORK.ANNOUNCEMENT has 1011 observations and 9 variables.
... View more