Why does line 4 start with a quoted string instead of a DATE value?
8 data _null_;
9 infile "&path\Sample 3.csv" ;
10 input;
11 list;
12 run;
NOTE: The infile "...\Sample 3.csv" is:
Filename=...\Sample 3.csv,
RECFM=V,LRECL=32767,File Size (bytes)=2271,
Last Modified=05Mar2020:13:13:05,
Create Time=05Mar2020:13:13:04
RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+--
1 Date received,Product,Sub-product,Issue,Sub-issue,Consumer complaint narrative,Company public res
98 ponse,Company,State,ZIP code,Tags,Consumer consent provided?,Submitted via,Date sent to company,C
195 ompany response to consumer,Timely response?,Consumer disputed?,Complaint ID 270
2 6/5/2015,Credit reporting,,Incorrect information on credit report,Information is not mine,,Compan
98 y chooses not to provide a public response,"TransUnion Intermediate Holdings, Inc.",TX,78703,,Con
195 sent not provided,Web,6/5/2015,Closed with explanation,Yes,Yes,1408548 264
3 5/18/2015,Debt collection,"Other (i.e. phone, health club, etc.)",Disclosure verification of debt
98 ,Not disclosed as an attempt to collect,"I received a letter from IC System back in XXXX XXXX, 20
195 15 stating that I have a balance due from XXXX XXXX XXXX. I was shocked and researched the issue
292 with XXXX XXXX XXXX immediately. XXXX XXXX XXXX confirmed with me on the phone and in writing tha
389 t I did not owe them any balance and the communication from IC System is incorrect. Then, I conta
486 cted IC System to explain the situation to them on XXXX XXXX, 2015 and the representative ( XXXX
583 ) advised me to mail them a dispute letter. Then, I did mail IC System two dispute letters. After
680 I sent the dispute letter, I follow-up with IC System three times on the phone on XXXX XXXX, XXX
777 X XXXX and XXXX XXXX, 2015. IC System advised me that the status is pending the response from XXX
874 X XXXX, but they will not report my file to the credit bureaus as they still need to do a investi
971 gation. However, I just realized they reported my file to the credit bureaus few days ago without
1068 clarified my account with XXXX XXXX XXXX. I called IC System today, XXXX XXXX, 2015 and seeking
1165 for help. Their response to me is I am sorry they can not do anything about it, I can dispute tha
1262 t from the credit bureaus if I want to. I believe the whole process make me very frustrated and h
1359 elpless because of the mistake of a billing. 1403
RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+--
4 ",,"I.C. System, Inc.",TX,774XX,,Consent provided,Web,5/18/2015,Closed with explanation,Yes,No,13
98 81317 102
5 5/18/2015,Credit reporting,,Incorrect information on credit report,Public record,,Company chooses
98 not to provide a public response,Experian,TX,75791,,Consent not provided,Web,5/18/2015,Closed wi
195 th explanation,Yes,No,1379696 223
Make sure your CSV file follows SAS's rules for how delimited text files need to be formatted.
If you don't like SAS's rules then go up-vote this change request:
https://communities.sas.com/t5/SASware-Ballot-Ideas/Enhancements-to-INFILE-FILE-to-handle-delimited-file-variations/idi-p/435977
... View more
