I'm a very new SAS user, and I'm trying to import a data set of over 41,000 values into Base SAS 9.4. The data set is saved in a csv format. Many hundreds of these data points are missing entries and have the value "NULL" written in an otherwise numerical set of values. When I try and import the data using the Import Data tool it comes up with many of these error messages: "NOTE: Invalid data for v_child in line 732 147-150." And then I get this warning message: "WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed." Followed by this: "NOTE: 41817 records were read from the infile 'J:\ABU Dataset 2010 to 2018.csv'. The minimum record length was 696. The maximum record length was 1588. NOTE: The data set SASDATA.ABU has 41817 observations and 145 variables. NOTE: DATA statement used (Total process time): real time 30.07 seconds cpu time 1.28 seconds Errors detected in submitted DATA step. Examine log. 41817 rows created in SASDATA.ABU from J:\ABU Dataset 2010 to 2018.csv. ERROR: Import unsuccessful. See SAS Log for details." How can I fix this so that I can import the data successfully? Thank you in advance!
... View more