Hello, I am having an issue with the INFILE section in the Data step using Base SAS 9.4 by way of Enterprise Guide. The file that I am importing in question has 1523 records (not including column names on first row), but the statement is only pulling in 144 from the csv. When I look at the dataset that the code has produced, there exists a field where the quotation marks that surround each field in a csv pop out for whatever reason. When I check the csv, there is an odd character (an arrow) that is in the field where the issue starts. Now, I wouldn't mind tossing the record itself later in the program, but the file completely stops reading at that claim. I am confident that the informants and lengths and such are correct because I used the SAS EG Import option to do the heavy lifting on that end. When I read the logs, the following is found, suggesting that there was no error (I am using dummy names to obscure potentially sensitive information): NOTE: The infile "location\file.csv" is: Filename=location, RECFM=V,LRECL=32767,File Size (bytes)=1734349, Last Modified=16May2018:05:59:01, Create Time=16May2018:05:41:48 NOTE: 144 records were read from the infile "location\file.csv". The minimum record length was 876. The maximum record length was 1491. NOTE: The data set WORK.DATASET has 144 observations and 154 variables. NOTE: DATA statement used (Total process time): real time 0.42 seconds cpu time 0.07 seconds Here is a truncated version of the Data step code that I am using. X is the field preceding the problem field, and Y is the problem field. I will note that field x is not populated anywhere in the document, so there should be nothing in field X to cause field Y to break. data work.dataset; length X $ 1 Y $ 1492 ; label X = "X" Y = "Y" ; format X $CHAR1. Y $CHAR1492. ; informat X $CHAR1. Y $CHAR1492. ; INFILE "location\file.csv" firstobs=2 MISSOVER DSD ; input X : $CHAR1. Y : $CHAR1492. ; run; So, to summarize my question: does anyone know why the csv may be breaking, and what can I do to get all of the records in, even if some of them are broken?
... View more