I am new to SAS programming. so what I have is a file using a pipe "|" delimiter, but it has 2 fields that use a secondary delimiter of "?" for data that can contain from 1 to 14 entries for each field. Have it currently set up as: INFILE INDD1 COL=COL PAD LENGTH=LENGTH MISSOVER DELIMITER='|' dsd;
INPUT @1 LINE $VARYING. LENGTH @;
LENGTH REQTYPE $15 REQUSER $9 REQID $9 PHONE $9 SSN $9 PREFERID $7
FIRST MI LAST BANK CCENTER EMAIL MAILCODE FILL1 FILL2 TASKID $36
ASSIGNEE HOSTPLAT HOSTFILL PRIOR DATE1 DATE2 ACTION USERID SAPID
MODELID MODELNM DELDES ADDESS $600; the fields DELDES & ADDESS are the fields that use the secondary delimiter of ? inside of the. How do I define and use the individual fields within DELDES & ADDESS ? Sorry if this is hard to read, I'm an old COBOL developer and this is my first post; examples of data example 1: Byte ----+----10---+----2----+----3----+----4----+----5----+----6 1 |Delete|NODATA|NODATA|1012404|noSSN|BLMORRO|BRITTNEY|X|MORRO 61 W|bank|0004213|BRITTNEY.xxxxxxxxxxxxx.COM|SL-KS-S4FD|||72b02 121 7d9-5e2a-4b2e-8574-8871c2503766|TAOKES1|F400 TOPS PROCESS CO 181 NTROL|F400 TOPS PROCESS CONTROL|priority|TUE AUG 14 18:42:17 241 CDT 2018|TUE AUG 14 18:42:17 CDT 2018|Delete|BLMORRO||||INT 301 ERNAL TABLE: RFS||||| example 2: Byte ----+----10---+----2----+----3----+----4----+----5----+----6 1 |Add|NODATA|NODATA|1004604|noSSN|DGTHOM2|DONALD|X|THOMAS|ban 61 k|0005182|DONALD.xxxxxxxxxxxxx.COM|EP-MN-WS4M|||ee497752-8a8 121 2-479a-a206-9395c84b32e5|TAOKES1|F400 TOPS PROCESS CONTROL|F 181 400 TOPS PROCESS CONTROL|priority|TUE AUG 14 11:57:50 CDT 20 241 18|TUE AUG 14 11:57:50 CDT 2018|Add|DGTHOM2|||||OFFICE: OPS| 301 ||| example 3: Byte ----+----10---+----2----+----3----+----4----+----5----+----6 1 |Change|NODATA|NODATA|1001783|noSSN|TMDOORN|TIMOTHY|X|DOORN| 61 bank|0022410|TIMOTHY.xxxxxxxxxxxK.COM|SL-KS-S1FD|||5e3e7038- 121 b315-4809-8b5c-a03091dbd7e3|TAOKES1|F400 TOPS PROCESS CONTRO 181 L|F400 TOPS PROCESS CONTROL|priority|TUE AUG 14 10:12:53 CDT 241 2018|TUE AUG 14 10:12:53 CDT 2018|Change|TMDOORN||||INTERNA 301 L TABLE: CBO?INTERNAL TABLE: CRV|INTERNAL TABLE: RFS|||| example 4: Byte ----+----10---+----2----+----3----+----4----+----5----+----6 1 |Add|NODATA|NODATA|993332|noSSN|SLHEND7|SUNNY|X|HENDRIX|bank 61 |0052065|SUNNY.xxxxxxxxxxxxxx.COM|SL-KS-9211|||f5e697ec-61e7 121 -427f-ac00-68e24260e207|TAOKES1|F400 TOPS PROCESS CONTROL|F4 181 00 TOPS PROCESS CONTROL|priority|MON AUG 13 13:43:05 CDT 201 241 8|MON AUG 13 13:43:05 CDT 2018|Add|SLHEND7|||||INTERNAL TABL 301 E: RBS?OFFICE: CMNT|||| When I look at it in excel, this is what I see example data as seen in Excel
... View more
