Thanks for the suggestion! Here is the complete log I get after running Tom's code: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
72
73 DATA RAW;
74 INFILE 'FILENAME.csv' firstobs=2 obs=5;
75 INPUT;
76 list;
77 Run;
NOTE: The infile 'filename.csv' is:
Filename=filename.csv,
RECFM=V,LRECL=32767,File Size (bytes)=49471666,
Last Modified=08Jul2021:02:23:25,
Create Time=08Jul2021:07:15:26
RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
2 0,123456,1234567,891011121314,2021-00-00 03:30:40,,2021-00-00 15:37:40,94500-6,TJU SARS-COV-2 RNA QUALI
101 TATIVE NAAT,,Lab,,,POSITIVE,"REVERSE TRANSCRIPTION POLYMERASE CHAIN REACTION (RT-PCR) 185
3 ",POSITIVE,F,84,0,XXXXX,XXXX,1900-00-00,(XXX)xxx-xxxx,1234 APPLE RD,,PHILADELPHIA,PA, 101 race,ENG,191,W,1144,Jefferson Ambulatory,,,,RACE,,,, 161
4 0,1359946,1345887,403041498,2020-11-24 10:00:00,,2020-11-24 10:00:00,94309-2,TJU SARS-COV-2 RNA QUAL
101 ITATIVE NAAT,,Lab,"","",POSITIVE,SARS-COV-2 RNA DETECTED. POSITIVE RESULTS DO NOT RULE OUT BACTERIA
201 L INFECTION OR CO-INFECTION WITH OTHER VIRUSES. | PENNSYLVANIA DEPARTMENT OF HEALTH WILL BE NOTIFIED
301 . 0X0D | ,POSITIVE,F,50,0,PATIENT NAME,1900-00-0,(xxx)XXX-xxxx,address,,PHILADELPHIA,PA,
401 race,,19136,,1168, University Hospital,"","","",Unknown,"","","","" 497
5 0,1359949,1345890,03083743,2021-01-09 08:21:00,,2021-01-09 08:21:19,94309-2,TJU SARS-COV-2 RNA QUALI
101 TATIVE NAAT,,Lab,,,POSITIVE,"SARS-COV-2 RNA DETECTED. POSITIVE RESULTS DO NOT RULE OUT BACTERIAL IN
201 FECTION OR CO-INFECTION WITH OTHER VIRUSES. 243
NOTE: 4 records were read from the infile 'M:\DDC\EPI\ACD\COVID\datasTest\HSX\covid19_phila_dph_2021-07-08.csv'.
The minimum record length was 161.
The maximum record length was 497.
NOTE: The data set WORK.RAW has 4 observations and 0 variables.
NOTE: DATA statement used (Total process time):
real time 0.02 seconds
cpu time 0.01 seconds
78
79 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; As you can see, something is going on with the delimiters. Using the classic csv comma is not working. I'm just not sure how to get around this.
... View more