Hello,
I am using this code:
data want;
infile "filepath"
delimiter = '|'
MISSOVER
DSD
FIRSTOBS=2;
input
ID $15.
Location_ID 9
Code 4
Date_Eff 8
Date_Insert_Row 8
Date_Exp 8
Code_ID $9.
;
run;
to infile data that looks like this:
ID|Location_ID|Code|Date_Eff|Date_Insert_Row|Date_Exp|Code_ID
100101160A |200010386|1|19920430|20200926|22991231|BR3209512
200001040A |200050045|1|19930630|20200926|22991231|AA8312693
but my output data looks like this:
![marleeakerson_0-1603312554003.png marleeakerson_0-1603312554003.png](https://communities.sas.com/t5/image/serverpage/image-id/50892i5247E98B36461513/image-size/medium?v=v2&px=400)
can someone help diagnosis this issue? it looks like the code isn't reading the delimiter properly?