More information The original data. 4434424 STANTON RENAISSANCE BUILDERS STANTON RENAISSANCE BUILDERS 2325574 2325574 B111 193
4434454 APPLE IPAD COMPUTER SYS APPLE IPAD COMPUTER SYS "AIR/TABLET PC " 1330622 2467340 B311 356
4434573 241 PIZZA RESTAURANT 241 PIZZA RESTAURANT FESTIVE FAVOURITE 1541372 2467232 G330 1253 I'm using "|" to indicate separate variables. 4434424|STANTON RENAISSANCE BUILDERS|STANTON RENAISSANCE BUILDERS|2325574|2325574|B111|193
4434454|APPLE IPAD COMPUTER SYS|APPLE IPAD COMPUTER SYS "AIR/TABLET PC "|1330622|2467340|B311|356
4434573|241 PIZZA RESTAURANT|241 PIZZA RESTAURANT FESTIVE FAVOURITE|1541372|2467232|G330|1253 The generated data step: 1070 data WORK.BRAND ;
1071 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
1072 infile 'E:\path\file.tsv' delimiter='09'x MISSOVER
1072! DSD lrecl=32767 firstobs=2 ;
1073 informat v1 best32. ;
1074 informat v2 $80. ;
1075 informat v3 $91. ;
1076 informat v4 best32. ;
1077 informat v5 best32. ;
1078 informat v6 $4. ;
1079 informat v7 best32. ;
1080 format v1 best12. ;
1081 format v2 $80. ;
1082 format v3 $91. ;
1083 format v4 best12. ;
1084 format v5 best12. ;
1085 format v6 $4. ;
1086 format v7 best12. ;
1087 input
1088 v1
1089 v2 $
1090 v3 $
1091 v4
1092 v5
1093 v6 $
1094 v7
1095 ;
1096 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */
1097 run;
NOTE: The infile 'E:\path\file.tsv' is:
Filename=E:\path\file.tsv,
RECFM=V,LRECL=32767,
File Size (bytes)=340331123,
Last Modified=02Apr2020:11:41:49,
Create Time=13Jul2020:09:45:36
NOTE: Invalid data for v4 in line 3064481 72-72.
NOTE: Invalid data for v7 in line 3064481 90-93.
RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9--
3064481 4434454.APPLE IPAD COMPUTER SYS.APPLE IPAD COMPUTER SYS "AIR/TABLET PC.".1330622.2467340.B31
ZONE 33333330455442454424445554525550455442454424445554525552244525444452540203333333033333330433
NUMR 44344549100C50901403FD0545203939100C50901403FD05452039302192F412C540039291330622924673409231
93 1.356 97
ZONE 30333
NUMR 19356
v1=4434454 v2=APPLE IPAD COMPUTER SYS
v3=APPLE IPAD COMPUTER SYS "AIR/TABLET PC v4=. v5=1330622
v6=2467 v7=. _ERROR_=1 _N_=3064480 If I first transfer the TSV into CSV format data, then SAS can import the csv data without errors.
... View more
