Solved: Importing a csv file using the proc import code

Sandeep77 · Posted 04-11-2023 08:16 AM

Hi all,

I am trying to import a csv file using the proc import code but it is invalid data error. Can you please check and let me know the issue with the code?

I have not pasted the entire error log as it is too long.

Proc import 
datafile='\\lowell2.local\shares\Public\Trace\Trace Integrity Analyst Data\BAU_Processes\SAS\Enhanced TPT\Storage\Monthly Washes\Trace_2023_02_10\elnz_Lowell_10Feb.CSV'
out=Feb_release
dbms=csv
replace;
run;

Error log:
NOTE: Invalid data for TA_TEL_NUM_1 in line 446 267-277.
NOTE: Invalid data for TA_TEL_NUM_1 in line 406 301-311.
WARNING: Limit set by ERRORS= option reached.  Further errors of this type will not be printed.
NOTE: The data set WORK.FEB_RELEASE has 995394 observations and 72 variables.
NOTE: Compressing data set WORK.FEB_RELEASE decreased size by 54.32 percent. 

Errors detected in submitted DATA step. Examine log.
995394 rows created in WORK.FEB_RELEASE from \\lowell2.local\shares\Public\Trace\Trace Integrity Analyst 
Data\BAU_Processes\SAS\Enhanced TPT\Storage\Monthly 
Washes\Trace_2023_02_10\elnz_Lowell_10Feb.CSV.
ERROR: Import unsuccessful.  See SAS Log for details.
NOTE: The SAS System stopped processing this step because of errors.

Ksharp · Posted 04-11-2023 08:25 AM

Try add GUESSINGROWS= option:

Proc import
datafile='\\lowell2.local\shares\Public\Trace\Trace Integrity Analyst Data\BAU_Processes\SAS\Enhanced TPT\Storage\Monthly Washes\Trace_2023_02_10\elnz_Lowell_10Feb.CSV'
out=Feb_release
dbms=csv
replace;
guessingrows=max ;
run;

View solution in original post

PaigeMiller · Posted 04-11-2023 08:22 AM

Please use some common sense here, error messages by themselves without the code created by PROC IMPORT tell us nothing useful, we don't know what to fix because we can't see the code created by PROC IMPORT.

We need to see the code generated by PROC IMPORT, as it appears in the log, and far enough down so we can see a few errors.

--
Paige Miller

Sandeep77 · Posted 04-11-2023 08:28 AM

Here is the full error log.


1          ;*';*";*/;quit;run;
2          OPTIONS PAGENO=MIN;
3          %LET _CLIENTTASKLABEL='Importing the file';
4          %LET _CLIENTPROCESSFLOWNAME='Process Flow';
5          %LET _CLIENTPROJECTPATH='S:\Trace\Trace Integrity Analyst Data\Projects and Tasks\3. Sandeep\Equifax release\Equifax
5        ! released.egp';
6          %LET _CLIENTPROJECTPATHHOST='LWLT5CG9322XFL';
7          %LET _CLIENTPROJECTNAME='Equifax released.egp';
8          %LET _SASPROGRAMFILE='';
9          %LET _SASPROGRAMFILEHOST='';
10         
11         ODS _ALL_ CLOSE;
12         OPTIONS DEV=SVG;
13         GOPTIONS XPIXELS=0 YPIXELS=0;
14         %macro HTML5AccessibleGraphSupported;
15             %if %_SAS_VERCOMP_FV(9,4,4, 0,0,0) >= 0 %then ACCESSIBLE_GRAPH;
16         %mend;
17         ODS LISTING GPATH=&sasworklocation;
18         FILENAME EGHTML TEMP;
19         ODS HTML5(ID=EGHTML) FILE=EGHTML
20             OPTIONS(BITMAP_MODE='INLINE')
21             %HTML5AccessibleGraphSupported
22             ENCODING='utf-8'
23             STYLE=HTMLBlue
24             NOGTITLE
25             NOGFOOTNOTE
26             GPATH=&sasworklocation
27         ;
NOTE: Writing HTML5(EGHTML) Body file: EGHTML
28         
29         Proc import
30         datafile='\\lowell2.local\shares\Public\Trace\Trace Integrity Analyst Data\BAU_Processes\SAS\Enhanced TPT\Storage\Monthly
30       !  Washes\Trace_2023_02_10\elnz_Lowell_10Feb.CSV'
31         out=Feb_release
32         dbms=csv
33         replace;
34         run;

35          /**********************************************************************
36          *   PRODUCT:   SAS
37          *   VERSION:   9.4
38          *   CREATOR:   External File Interface
39          *   DATE:      11APR23
40          *   DESC:      Generated SAS Datastep Code
41          *   TEMPLATE SOURCE:  (None Specified.)
42          ***********************************************************************/
43             data WORK.FEB_RELEASE    ;
44             %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
45             infile '\\lowell2.local\shares\Public\Trace\Trace Integrity Analyst Data\BAU_Processes\SAS\Enhanced
45       ! TPT\Storage\Monthly Washes\Trace_2023_02_10\elnz_Lowell_10Feb.CSV' delimiter = ',' MISSOVER DSD
46         lrecl=32767 firstobs=2 ;
47                informat SEQUENCE_NUMBER best32. ;
48                informat REFERENCE_NUMBER best32. ;
49                informat ADDRESS_MATCHED $3. ;
50                informat ERROR_MESSAGE $1. ;
51                informat SEGMENT_NUMBER $4. ;
52                informat SEGMENT $19. ;
53                informat OPS_FLAG $18. ;
2                                                          The SAS System                              10:29 Tuesday, April 11, 2023

54                informat TA_ADDRESS1 $14. ;
55                informat TA_ADDRESS2 $1. ;
56                informat TA_ADDRESS3 $21. ;
57                informat TA_ADDRESS4 $13. ;
58                informat TA_PCODE $7. ;
59                informat RANK_1 best32. ;
60                informat RANK_TYPE_1 $8. ;
61                informat APPENDED_DOB best32. ;
62                informat APPENDED_FORENAME $10. ;
63                informat NO_INDIVIDUALS_SHARING_NM_DOB best32. ;
64                informat NO_INDIVIDUALS_SHARING_NM_NO_DOB best32. ;
65                informat DECEASED $2. ;
66                informat LAS_RES_IND $4. ;
67                informat LAS_NON_RES_IND $6. ;
68                informat LAS_NO_OPEN_INSIGHT_ACC best32. ;
69                informat LAS_NO_OPEN_INSIGHT_ACC_L3M best32. ;
70                informat LAS_NO_OPEN_INSIGHT_ACC_LM best32. ;
71                informat LAS_NO_DIFF_OPEN_INSIGHT_LENDERS best32. ;
72                informat LAS_CURRENTLY_REGISTERED_ON_ER $3. ;
73                informat LAS_TIME_SINCE_SUBJECT_ON_EER best32. ;
74                informat LAS_NEW_RR_IN_DIFF_SURNAME $15. ;
75                informat LAS_TIME_SINCE_RR_DELETE_FOR_APP $17. ;
76                informat LAS_REGISTERED_TELEPHONE_NUMBER $3. ;
77                informat LAS_TEL_NUMBER $11. ;
78                informat LAS_COUNT_ACTIVITY_IN_L1M $16. ;
79                informat LAS_COUNT_ACTIVITY_IN_L3M $16. ;
80                informat MOVEMENT_OUT_INDICATOR $9. ;
81                informat LAS_RES_COUNT_INCL_MOV_INFO best32. ;
82                informat LAS_NON_RES_COUNT_INCL_MOV_INFO best32. ;
83                informat TA_RESIDENCY_IND $6. ;
84                informat TA_NON_RESIDENCY_IND $2. ;
85                informat TA_NO_OPEN_INSIGHT_ACC best32. ;
86                informat TA_NO_OPEN_INSIGHT_ACC_L3M best32. ;
87                informat TA_NO_OPEN_INSIGHT_ACC_L1M best32. ;
88                informat TA_NO_DIFF_OPEN_INSIGHT_LENDERS best32. ;
89                informat TA_CURR_REG_ON_ER $2. ;
90                informat TA_TIME_SINCE_SUBJECT_ON_EER best32. ;
91                informat TA_NEW_RR_IN_DIFF_SURNAME $15. ;
92                informat TA_TIME_SINCE_RR_DELETE_FOR_APP $17. ;
93                informat TA_REG_TEL_NUM $3. ;
94                informat TA_TEL_NUM_1 best32. ;
95                informat TA_COUNT_ACTIVITY_IN_L1M $16. ;
96                informat TA_COUNT_ACTIVITY_IN_L3M $16. ;
97                informat TA_RES_COUNT_INCL_MOV_INFO best32. ;
98                informat TA_NON_RES_COUNT_INCL_MOV_INFO best32. ;
99                informat TYPE_1 $20. ;
100               informat LINK_DATE_1 best32. ;
101               informat EQUIFAX_ADDRESS_KEY_1 best32. ;
102               informat STD_CODE_1 $1. ;
103               informat LOCAL_NUMBER_1 $1. ;
104               informat TPS_1 $1. ;
105               informat DATE_LOADED_1 $1. ;
106               informat LINE_TYPE_1 $1. ;
107               informat DISTANCE_1 best32. ;
108               informat NAME_MATCH_1 $7. ;
109               informat NAME_1 $25. ;
110               informat DOB_1 best32. ;
111               informat ADDITIONAL_NAME1_1 $17. ;
3                                                          The SAS System                              10:29 Tuesday, April 11, 2023

112               informat ADDITIONAL_NAME2_1 $13. ;
113               informat ADDITIONAL_NAME3_1 $14. ;
114               informat DISPUTE_ALERT $2. ;
115               informat CIFAS $2. ;
116               informat CSISF30 best32. ;
117               informat OPS_NUM_S best32. ;
118               informat OPS_NUM_T best32. ;
119               format SEQUENCE_NUMBER best12. ;
120               format REFERENCE_NUMBER best12. ;
121               format ADDRESS_MATCHED $3. ;
122               format ERROR_MESSAGE $1. ;
123               format SEGMENT_NUMBER $4. ;
124               format SEGMENT $19. ;
125               format OPS_FLAG $18. ;
126               format TA_ADDRESS1 $14. ;
127               format TA_ADDRESS2 $1. ;
128               format TA_ADDRESS3 $21. ;
129               format TA_ADDRESS4 $13. ;
130               format TA_PCODE $7. ;
131               format RANK_1 best12. ;
132               format RANK_TYPE_1 $8. ;
133               format APPENDED_DOB best12. ;
134               format APPENDED_FORENAME $10. ;
135               format NO_INDIVIDUALS_SHARING_NM_DOB best12. ;
136               format NO_INDIVIDUALS_SHARING_NM_NO_DOB best12. ;
137               format DECEASED $2. ;
138               format LAS_RES_IND $4. ;
139               format LAS_NON_RES_IND $6. ;
140               format LAS_NO_OPEN_INSIGHT_ACC best12. ;
141               format LAS_NO_OPEN_INSIGHT_ACC_L3M best12. ;
142               format LAS_NO_OPEN_INSIGHT_ACC_LM best12. ;
143               format LAS_NO_DIFF_OPEN_INSIGHT_LENDERS best12. ;
144               format LAS_CURRENTLY_REGISTERED_ON_ER $3. ;
145               format LAS_TIME_SINCE_SUBJECT_ON_EER best12. ;
146               format LAS_NEW_RR_IN_DIFF_SURNAME $15. ;
147               format LAS_TIME_SINCE_RR_DELETE_FOR_APP $17. ;
148               format LAS_REGISTERED_TELEPHONE_NUMBER $3. ;
149               format LAS_TEL_NUMBER $11. ;
150               format LAS_COUNT_ACTIVITY_IN_L1M $16. ;
151               format LAS_COUNT_ACTIVITY_IN_L3M $16. ;
152               format MOVEMENT_OUT_INDICATOR $9. ;
153               format LAS_RES_COUNT_INCL_MOV_INFO best12. ;
154               format LAS_NON_RES_COUNT_INCL_MOV_INFO best12. ;
155               format TA_RESIDENCY_IND $6. ;
156               format TA_NON_RESIDENCY_IND $2. ;
157               format TA_NO_OPEN_INSIGHT_ACC best12. ;
158               format TA_NO_OPEN_INSIGHT_ACC_L3M best12. ;
159               format TA_NO_OPEN_INSIGHT_ACC_L1M best12. ;
160               format TA_NO_DIFF_OPEN_INSIGHT_LENDERS best12. ;
161               format TA_CURR_REG_ON_ER $2. ;
162               format TA_TIME_SINCE_SUBJECT_ON_EER best12. ;
163               format TA_NEW_RR_IN_DIFF_SURNAME $15. ;
164               format TA_TIME_SINCE_RR_DELETE_FOR_APP $17. ;
165               format TA_REG_TEL_NUM $3. ;
166               format TA_TEL_NUM_1 best12. ;
167               format TA_COUNT_ACTIVITY_IN_L1M $16. ;
168               format TA_COUNT_ACTIVITY_IN_L3M $16. ;
169               format TA_RES_COUNT_INCL_MOV_INFO best12. ;
4                                                          The SAS System                              10:29 Tuesday, April 11, 2023

170               format TA_NON_RES_COUNT_INCL_MOV_INFO best12. ;
171               format TYPE_1 $20. ;
172               format LINK_DATE_1 best12. ;
173               format EQUIFAX_ADDRESS_KEY_1 best12. ;
174               format STD_CODE_1 $1. ;
175               format LOCAL_NUMBER_1 $1. ;
176               format TPS_1 $1. ;
177               format DATE_LOADED_1 $1. ;
178               format LINE_TYPE_1 $1. ;
179               format DISTANCE_1 best12. ;
180               format NAME_MATCH_1 $7. ;
181               format NAME_1 $25. ;
182               format DOB_1 best12. ;
183               format ADDITIONAL_NAME1_1 $17. ;
184               format ADDITIONAL_NAME2_1 $13. ;
185               format ADDITIONAL_NAME3_1 $14. ;
186               format DISPUTE_ALERT $2. ;
187               format CIFAS $2. ;
188               format CSISF30 best12. ;
189               format OPS_NUM_S best12. ;
190               format OPS_NUM_T best12. ;
191            input
192                        SEQUENCE_NUMBER
193                        REFERENCE_NUMBER
194                        ADDRESS_MATCHED  $
195                        ERROR_MESSAGE  $
196                        SEGMENT_NUMBER  $
197                        SEGMENT  $
198                        OPS_FLAG  $
199                        TA_ADDRESS1  $
200                        TA_ADDRESS2  $
201                        TA_ADDRESS3  $
202                        TA_ADDRESS4  $
203                        TA_PCODE  $
204                        RANK_1
205                        RANK_TYPE_1  $
206                        APPENDED_DOB
207                        APPENDED_FORENAME  $
208                        NO_INDIVIDUALS_SHARING_NM_DOB
209                        NO_INDIVIDUALS_SHARING_NM_NO_DOB
210                        DECEASED  $
211                        LAS_RES_IND  $
212                        LAS_NON_RES_IND  $
213                        LAS_NO_OPEN_INSIGHT_ACC
214                        LAS_NO_OPEN_INSIGHT_ACC_L3M
215                        LAS_NO_OPEN_INSIGHT_ACC_LM
216                        LAS_NO_DIFF_OPEN_INSIGHT_LENDERS
217                        LAS_CURRENTLY_REGISTERED_ON_ER  $
218                        LAS_TIME_SINCE_SUBJECT_ON_EER
219                        LAS_NEW_RR_IN_DIFF_SURNAME  $
220                        LAS_TIME_SINCE_RR_DELETE_FOR_APP  $
221                        LAS_REGISTERED_TELEPHONE_NUMBER  $
222                        LAS_TEL_NUMBER  $
223                        LAS_COUNT_ACTIVITY_IN_L1M  $
224                        LAS_COUNT_ACTIVITY_IN_L3M  $
225                        MOVEMENT_OUT_INDICATOR  $
226                        LAS_RES_COUNT_INCL_MOV_INFO
227                        LAS_NON_RES_COUNT_INCL_MOV_INFO
5                                                          The SAS System                              10:29 Tuesday, April 11, 2023

228                        TA_RESIDENCY_IND  $
229                        TA_NON_RESIDENCY_IND  $
230                        TA_NO_OPEN_INSIGHT_ACC
231                        TA_NO_OPEN_INSIGHT_ACC_L3M
232                        TA_NO_OPEN_INSIGHT_ACC_L1M
233                        TA_NO_DIFF_OPEN_INSIGHT_LENDERS
234                        TA_CURR_REG_ON_ER  $
235                        TA_TIME_SINCE_SUBJECT_ON_EER
236                        TA_NEW_RR_IN_DIFF_SURNAME  $
237                        TA_TIME_SINCE_RR_DELETE_FOR_APP  $
238                        TA_REG_TEL_NUM  $
239                        TA_TEL_NUM_1
240                        TA_COUNT_ACTIVITY_IN_L1M  $
241                        TA_COUNT_ACTIVITY_IN_L3M  $
242                        TA_RES_COUNT_INCL_MOV_INFO
243                        TA_NON_RES_COUNT_INCL_MOV_INFO
244                        TYPE_1  $
245                        LINK_DATE_1
246                        EQUIFAX_ADDRESS_KEY_1
247                        STD_CODE_1  $
248                        LOCAL_NUMBER_1  $
249                        TPS_1  $
250                        DATE_LOADED_1  $
251                        LINE_TYPE_1  $
252                        DISTANCE_1
253                        NAME_MATCH_1  $
254                        NAME_1  $
255                        DOB_1
256                        ADDITIONAL_NAME1_1  $
257                        ADDITIONAL_NAME2_1  $
258                        ADDITIONAL_NAME3_1  $
259                        DISPUTE_ALERT  $
260                        CIFAS  $
261                        CSISF30
262                        OPS_NUM_S
263                        OPS_NUM_T
264            ;
265            if _ERROR_ then call symputx('_EFIERR_',1);  /* set ERROR detection macro variable */
266            run;

NOTE: The infile '\\lowell2.local\shares\Public\Trace\Trace Integrity Analyst Data\BAU_Processes\SAS\Enhanced TPT\Storage\Monthly 
      Washes\Trace_2023_02_10\elnz_Lowell_10Feb.CSV' is:
      
      Filename=\\lowell2.local\shares\Public\Trace\Trace Integrity Analyst Data\BAU_Processes\SAS\Enhanced TPT\Storage\Monthly 
      Washes\Trace_2023_02_10\elnz_Lowell_10Feb.CSV,
      RECFM=V,LRECL=32767,
      File Size (bytes)=263495880,
      Last Modified=15Feb2023:11:23:24,
      Create Time=15Feb2023:11:27:08

NOTE: Invalid data for TA_TEL_NUM_1 in line 40 280-290.
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
40        39,10052229,Yes,,TEL9,Asct Trace No data,Verbal New – 2 Ver,BETHSHEAN CRAIGO,,MONTROSE,ANGUS,DD109LD
     101  ,1700,Movement,,,0,0,NO,No,Strong,0,0,0,0,No,0,99,No delete records,No,,No searches ever,No searches
     201   ever,Associate,1,3,Some,No,0,0,0,0,No,0,No load records,No delete records,Yes,***********,No search
     301  es ever,No searches ever,2,0,Last link in a chain,06042022,68070017907,,,,,,274,Associate,"MR,MARK J
     401  AMES, ,HOLLOWAY",09071968,", ,",", ,",", ,",NO,NO,+0176,0,0.5 461
SEQUENCE_NUMBER=39 REFERENCE_NUMBER=10052229 ADDRESS_MATCHED=Yes ERROR_MESSAGE=  SEGMENT_NUMBER=TEL9 SEGMENT=Asct Trace No data
6                                                          The SAS System                              10:29 Tuesday, April 11, 2023

OPS_FLAG=Verbal New – 2 Ver TA_ADDRESS1=BETHSHEAN CRAI TA_ADDRESS2=  TA_ADDRESS3=MONTROSE TA_ADDRESS4=ANGUS TA_PCODE=DD109LD
RANK_1=1700 RANK_TYPE_1=Movement APPENDED_DOB=. APPENDED_FORENAME=  NO_INDIVIDUALS_SHARING_NM_DOB=0
NO_INDIVIDUALS_SHARING_NM_NO_DOB=0 DECEASED=NO LAS_RES_IND=No LAS_NON_RES_IND=Strong LAS_NO_OPEN_INSIGHT_ACC=0
LAS_NO_OPEN_INSIGHT_ACC_L3M=0 LAS_NO_OPEN_INSIGHT_ACC_LM=0 LAS_NO_DIFF_OPEN_INSIGHT_LENDERS=0 LAS_CURRENTLY_REGISTERED_ON_ER=No
LAS_TIME_SINCE_SUBJECT_ON_EER=0 LAS_NEW_RR_IN_DIFF_SURNAME=99 LAS_TIME_SINCE_RR_DELETE_FOR_APP=No delete records
LAS_REGISTERED_TELEPHONE_NUMBER=No LAS_TEL_NUMBER=  LAS_COUNT_ACTIVITY_IN_L1M=No searches ever
LAS_COUNT_ACTIVITY_IN_L3M=No searches ever MOVEMENT_OUT_INDICATOR=Associate LAS_RES_COUNT_INCL_MOV_INFO=1
LAS_NON_RES_COUNT_INCL_MOV_INFO=3 TA_RESIDENCY_IND=Some TA_NON_RESIDENCY_IND=No TA_NO_OPEN_INSIGHT_ACC=0
TA_NO_OPEN_INSIGHT_ACC_L3M=0 TA_NO_OPEN_INSIGHT_ACC_L1M=0 TA_NO_DIFF_OPEN_INSIGHT_LENDERS=0 TA_CURR_REG_ON_ER=No
TA_TIME_SINCE_SUBJECT_ON_EER=0 TA_NEW_RR_IN_DIFF_SURNAME=No load records TA_TIME_SINCE_RR_DELETE_FOR_APP=No delete records
TA_REG_TEL_NUM=Yes TA_TEL_NUM_1=. TA_COUNT_ACTIVITY_IN_L1M=No searches ever TA_COUNT_ACTIVITY_IN_L3M=No searches ever
TA_RES_COUNT_INCL_MOV_INFO=2 TA_NON_RES_COUNT_INCL_MOV_INFO=0 TYPE_1=Last link in a chain LINK_DATE_1=6042022
EQUIFAX_ADDRESS_KEY_1=68070017907 STD_CODE_1=  LOCAL_NUMBER_1=  TPS_1=  DATE_LOADED_1=  LINE_TYPE_1=  DISTANCE_1=274
NAME_MATCH_1=Associa NAME_1=MR,MARK JAMES, ,HOLLOWAY DOB_1=9071968 ADDITIONAL_NAME1_1=, , ADDITIONAL_NAME2_1=, ,
ADDITIONAL_NAME3_1=, , DISPUTE_ALERT=NO CIFAS=NO CSISF30=176 OPS_NUM_S=0 OPS_NUM_T=0.5 _ERROR_=1 _N_=39
NOTE: Invalid data for TA_TEL_NUM_1 in line 91 303-313.
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
91        90,102028370,Yes,,SA1,App Conflict 6-,Resident Conflict,10 SILVER PIT GARDENS,,PETERHEAD,ABERDEENSHI
     101  RE,AB422UQ,200,Movement and Activity,22031986,VICTORIA,1,2,NO,Some,Some,3,3,3,3,No,0,No load records
     201  ,No delete records,Yes,***********,00,00,Family,5,1,Strong,Strong,1,1,1,1,No,3,No load records,33,Ye
     301  s,***********,No searches ever,No searches ever,3,3,Name & DOB,17012023,67320041463,,,,,,0,,",V, ,CO
     401  OK",22031986,"MISS,VICTORIA,A",",VICTORIA,",", ,",NO,NO,+0185,3.5,1.5 469
SEQUENCE_NUMBER=90 REFERENCE_NUMBER=102028370 ADDRESS_MATCHED=Yes ERROR_MESSAGE=  SEGMENT_NUMBER=SA1 SEGMENT=App Conflict 6-
OPS_FLAG=Resident Conflict TA_ADDRESS1=10 SILVER PIT TA_ADDRESS2=  TA_ADDRESS3=PETERHEAD TA_ADDRESS4=ABERDEENSHIRE TA_PCODE=AB422UQ
RANK_1=200 RANK_TYPE_1=Movement APPENDED_DOB=22031986 APPENDED_FORENAME=VICTORIA NO_INDIVIDUALS_SHARING_NM_DOB=1
NO_INDIVIDUALS_SHARING_NM_NO_DOB=2 DECEASED=NO LAS_RES_IND=Some LAS_NON_RES_IND=Some LAS_NO_OPEN_INSIGHT_ACC=3
LAS_NO_OPEN_INSIGHT_ACC_L3M=3 LAS_NO_OPEN_INSIGHT_ACC_LM=3 LAS_NO_DIFF_OPEN_INSIGHT_LENDERS=3 LAS_CURRENTLY_REGISTERED_ON_ER=No
LAS_TIME_SINCE_SUBJECT_ON_EER=0 LAS_NEW_RR_IN_DIFF_SURNAME=No load records LAS_TIME_SINCE_RR_DELETE_FOR_APP=No delete records
LAS_REGISTERED_TELEPHONE_NUMBER=Yes LAS_TEL_NUMBER=*********** LAS_COUNT_ACTIVITY_IN_L1M=00 LAS_COUNT_ACTIVITY_IN_L3M=00
MOVEMENT_OUT_INDICATOR=Family LAS_RES_COUNT_INCL_MOV_INFO=5 LAS_NON_RES_COUNT_INCL_MOV_INFO=1 TA_RESIDENCY_IND=Strong
TA_NON_RESIDENCY_IND=St TA_NO_OPEN_INSIGHT_ACC=1 TA_NO_OPEN_INSIGHT_ACC_L3M=1 TA_NO_OPEN_INSIGHT_ACC_L1M=1
TA_NO_DIFF_OPEN_INSIGHT_LENDERS=1 TA_CURR_REG_ON_ER=No TA_TIME_SINCE_SUBJECT_ON_EER=3 TA_NEW_RR_IN_DIFF_SURNAME=No load records
TA_TIME_SINCE_RR_DELETE_FOR_APP=33 TA_REG_TEL_NUM=Yes TA_TEL_NUM_1=. TA_COUNT_ACTIVITY_IN_L1M=No searches ever
TA_COUNT_ACTIVITY_IN_L3M=No searches ever TA_RES_COUNT_INCL_MOV_INFO=3 TA_NON_RES_COUNT_INCL_MOV_INFO=3 TYPE_1=Name & DOB
LINK_DATE_1=17012023 EQUIFAX_ADDRESS_KEY_1=67320041463 STD_CODE_1=  LOCAL_NUMBER_1=  TPS_1=  DATE_LOADED_1=  LINE_TYPE_1= 
DISTANCE_1=0 NAME_MATCH_1=  NAME_1=,V, ,COOK DOB_1=22031986 ADDITIONAL_NAME1_1=MISS,VICTORIA,A ADDITIONAL_NAME2_1=,VICTORIA,
ADDITIONAL_NAME3_1=, , DISPUTE_ALERT=NO CIFAS=NO CSISF30=185 OPS_NUM_S=3.5 OPS_NUM_T=1.5 _ERROR_=1 _N_=90
NOTE: Invalid data for TA_TEL_NUM_1 in line 114 284-294.
114       113,10288934,Yes,,TEL1,Associate Trace IP,Verbal New - Exact,82 WATKIN ST,,WARRINGTON,CHESHIRE,WA2 7
     101  DP,1300,Activity,19101955,SUSAN,1,1,NO,No,Strong,0,0,0,0,No,0,95,No delete records,No,,No searches e
     201  ver,No searches ever,Subject,0,4,Strong,Some,4,4,4,4,No,0,99,No delete records,Yes,***********,00,00
     301  ,3,1,Name & DOB,29012023,25220017123,,,,,,9,,",S, ,WARBURTON",19101955,",SUSAN,","MRS,SUSAN,","MS,SU
     401  SAN,",NO,NO,+0153,0,4.5 423
SEQUENCE_NUMBER=113 REFERENCE_NUMBER=10288934 ADDRESS_MATCHED=Yes ERROR_MESSAGE=  SEGMENT_NUMBER=TEL1 SEGMENT=Associate Trace IP
OPS_FLAG=Verbal New - Exact TA_ADDRESS1=82 WATKIN ST TA_ADDRESS2=  TA_ADDRESS3=WARRINGTON TA_ADDRESS4=CHESHIRE TA_PCODE=WA2 7DP
RANK_1=1300 RANK_TYPE_1=Activity APPENDED_DOB=19101955 APPENDED_FORENAME=SUSAN NO_INDIVIDUALS_SHARING_NM_DOB=1
NO_INDIVIDUALS_SHARING_NM_NO_DOB=1 DECEASED=NO LAS_RES_IND=No LAS_NON_RES_IND=Strong LAS_NO_OPEN_INSIGHT_ACC=0
LAS_NO_OPEN_INSIGHT_ACC_L3M=0 LAS_NO_OPEN_INSIGHT_ACC_LM=0 LAS_NO_DIFF_OPEN_INSIGHT_LENDERS=0 LAS_CURRENTLY_REGISTERED_ON_ER=No
LAS_TIME_SINCE_SUBJECT_ON_EER=0 LAS_NEW_RR_IN_DIFF_SURNAME=95 LAS_TIME_SINCE_RR_DELETE_FOR_APP=No delete records
LAS_REGISTERED_TELEPHONE_NUMBER=No LAS_TEL_NUMBER=  LAS_COUNT_ACTIVITY_IN_L1M=No searches ever
LAS_COUNT_ACTIVITY_IN_L3M=No searches ever MOVEMENT_OUT_INDICATOR=Subject LAS_RES_COUNT_INCL_MOV_INFO=0
LAS_NON_RES_COUNT_INCL_MOV_INFO=4 TA_RESIDENCY_IND=Strong TA_NON_RESIDENCY_IND=So TA_NO_OPEN_INSIGHT_ACC=4
TA_NO_OPEN_INSIGHT_ACC_L3M=4 TA_NO_OPEN_INSIGHT_ACC_L1M=4 TA_NO_DIFF_OPEN_INSIGHT_LENDERS=4 TA_CURR_REG_ON_ER=No
TA_TIME_SINCE_SUBJECT_ON_EER=0 TA_NEW_RR_IN_DIFF_SURNAME=99 TA_TIME_SINCE_RR_DELETE_FOR_APP=No delete records TA_REG_TEL_NUM=Yes
TA_TEL_NUM_1=. TA_COUNT_ACTIVITY_IN_L1M=00 TA_COUNT_ACTIVITY_IN_L3M=00 TA_RES_COUNT_INCL_MOV_INFO=3 TA_NON_RES_COUNT_INCL_MOV_INFO=1
TYPE_1=Name & DOB LINK_DATE_1=29012023 EQUIFAX_ADDRESS_KEY_1=25220017123 STD_CODE_1=  LOCAL_NUMBER_1=  TPS_1=  DATE_LOADED_1= 
LINE_TYPE_1=  DISTANCE_1=9 NAME_MATCH_1=  NAME_1=,S, ,WARBURTON DOB_1=19101955 ADDITIONAL_NAME1_1=,SUSAN,
ADDITIONAL_NAME2_1=MRS,SUSAN, ADDITIONAL_NAME3_1=MS,SUSAN, DISPUTE_ALERT=NO CIFAS=NO CSISF30=153 OPS_NUM_S=0 OPS_NUM_T=4.5 _ERROR_=1
7                                                          The SAS System                              10:29 Tuesday, April 11, 2023

_N_=113
NOTE: Invalid data for TA_TEL_NUM_1 in line 116 278-288.
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
116       115,102949799,Yes,,F1,App Trace 1 IN,1 Ver,14 HEADLAM GREEN,,NEWCASTLE UPON TYNE,TYNE AND WEAR,NE6 2
     101  NZ,100,Movement,15101991,VICKY,1,0,NO,No,Strong,2,2,2,2,No,0,54,No delete records,Yes,***********,00
     201  ,00,Subject,3,4,Strong,No,2,2,2,1,No,0,No load records,No delete records,Yes,***********,00,00,3,0,N
     301  ame & DOB,01102022,14080143812,,,,,,9,,",V, ,BENTON",15101991,",VICKY,M",", ,",", ,",NO,NO,+0167,2.5
     401  ,1.5 404
SEQUENCE_NUMBER=115 REFERENCE_NUMBER=102949799 ADDRESS_MATCHED=Yes ERROR_MESSAGE=  SEGMENT_NUMBER=F1 SEGMENT=App Trace 1 IN
OPS_FLAG=1 Ver TA_ADDRESS1=14 HEADLAM GRE TA_ADDRESS2=  TA_ADDRESS3=NEWCASTLE UPON TYNE TA_ADDRESS4=TYNE AND WEAR TA_PCODE=NE6 2NZ
RANK_1=100 RANK_TYPE_1=Movement APPENDED_DOB=15101991 APPENDED_FORENAME=VICKY NO_INDIVIDUALS_SHARING_NM_DOB=1
NO_INDIVIDUALS_SHARING_NM_NO_DOB=0 DECEASED=NO LAS_RES_IND=No LAS_NON_RES_IND=Strong LAS_NO_OPEN_INSIGHT_ACC=2
LAS_NO_OPEN_INSIGHT_ACC_L3M=2 LAS_NO_OPEN_INSIGHT_ACC_LM=2 LAS_NO_DIFF_OPEN_INSIGHT_LENDERS=2 LAS_CURRENTLY_REGISTERED_ON_ER=No
LAS_TIME_SINCE_SUBJECT_ON_EER=0 LAS_NEW_RR_IN_DIFF_SURNAME=54 LAS_TIME_SINCE_RR_DELETE_FOR_APP=No delete records
LAS_REGISTERED_TELEPHONE_NUMBER=Yes LAS_TEL_NUMBER=*********** LAS_COUNT_ACTIVITY_IN_L1M=00 LAS_COUNT_ACTIVITY_IN_L3M=00
MOVEMENT_OUT_INDICATOR=Subject LAS_RES_COUNT_INCL_MOV_INFO=3 LAS_NON_RES_COUNT_INCL_MOV_INFO=4 TA_RESIDENCY_IND=Strong
TA_NON_RESIDENCY_IND=No TA_NO_OPEN_INSIGHT_ACC=2 TA_NO_OPEN_INSIGHT_ACC_L3M=2 TA_NO_OPEN_INSIGHT_ACC_L1M=2
TA_NO_DIFF_OPEN_INSIGHT_LENDERS=1 TA_CURR_REG_ON_ER=No TA_TIME_SINCE_SUBJECT_ON_EER=0 TA_NEW_RR_IN_DIFF_SURNAME=No load records
TA_TIME_SINCE_RR_DELETE_FOR_APP=No delete records TA_REG_TEL_NUM=Yes TA_TEL_NUM_1=. TA_COUNT_ACTIVITY_IN_L1M=00
TA_COUNT_ACTIVITY_IN_L3M=00 TA_RES_COUNT_INCL_MOV_INFO=3 TA_NON_RES_COUNT_INCL_MOV_INFO=0 TYPE_1=Name & DOB LINK_DATE_1=1102022
EQUIFAX_ADDRESS_KEY_1=14080143812 STD_CODE_1=  LOCAL_NUMBER_1=  TPS_1=  DATE_LOADED_1=  LINE_TYPE_1=  DISTANCE_1=9 NAME_MATCH_1= 
NAME_1=,V, ,BENTON DOB_1=15101991 ADDITIONAL_NAME1_1=,VICKY,M ADDITIONAL_NAME2_1=, , ADDITIONAL_NAME3_1=, , DISPUTE_ALERT=NO
CIFAS=NO CSISF30=167 OPS_NUM_S=2.5 OPS_NUM_T=1.5 _ERROR_=1 _N_=115
NOTE: Invalid data for TA_TEL_NUM_1 in line 118 264-274.
118       117,10304667,Yes,,TEL9,Asct Trace No data,Verbal New – 2 Ver,10A MARTINDALE ROAD,,LIVERPOOL,MERSEYSI
     101  DE,L18 3LQ,1700,Movement,28061958,STEVEN,1,1,NO,No,Strong,1,1,1,1,No,10,83,No delete records,No,,00,
     201  00,Subject,1,5,Some,Some,0,0,0,0,No,0,95,No delete records,Yes,***********,00,00,2,1,Last link in a 
     301  chain,29042021,27030093486,,,,,,9,Associate,"MRS,SANDRA, ,PEARSON",05031962,", ,",", ,",", ,",NO,NO,
     401  +0176,1,0.5 411
SEQUENCE_NUMBER=117 REFERENCE_NUMBER=10304667 ADDRESS_MATCHED=Yes ERROR_MESSAGE=  SEGMENT_NUMBER=TEL9 SEGMENT=Asct Trace No data
OPS_FLAG=Verbal New – 2 Ver TA_ADDRESS1=10A MARTINDALE TA_ADDRESS2=  TA_ADDRESS3=LIVERPOOL TA_ADDRESS4=MERSEYSIDE TA_PCODE=L18 3LQ
RANK_1=1700 RANK_TYPE_1=Movement APPENDED_DOB=28061958 APPENDED_FORENAME=STEVEN NO_INDIVIDUALS_SHARING_NM_DOB=1
NO_INDIVIDUALS_SHARING_NM_NO_DOB=1 DECEASED=NO LAS_RES_IND=No LAS_NON_RES_IND=Strong LAS_NO_OPEN_INSIGHT_ACC=1
LAS_NO_OPEN_INSIGHT_ACC_L3M=1 LAS_NO_OPEN_INSIGHT_ACC_LM=1 LAS_NO_DIFF_OPEN_INSIGHT_LENDERS=1 LAS_CURRENTLY_REGISTERED_ON_ER=No
LAS_TIME_SINCE_SUBJECT_ON_EER=10 LAS_NEW_RR_IN_DIFF_SURNAME=83 LAS_TIME_SINCE_RR_DELETE_FOR_APP=No delete records
LAS_REGISTERED_TELEPHONE_NUMBER=No LAS_TEL_NUMBER=  LAS_COUNT_ACTIVITY_IN_L1M=00 LAS_COUNT_ACTIVITY_IN_L3M=00
MOVEMENT_OUT_INDICATOR=Subject LAS_RES_COUNT_INCL_MOV_INFO=1 LAS_NON_RES_COUNT_INCL_MOV_INFO=5 TA_RESIDENCY_IND=Some
TA_NON_RESIDENCY_IND=So TA_NO_OPEN_INSIGHT_ACC=0 TA_NO_OPEN_INSIGHT_ACC_L3M=0 TA_NO_OPEN_INSIGHT_ACC_L1M=0
TA_NO_DIFF_OPEN_INSIGHT_LENDERS=0 TA_CURR_REG_ON_ER=No TA_TIME_SINCE_SUBJECT_ON_EER=0 TA_NEW_RR_IN_DIFF_SURNAME=95
TA_TIME_SINCE_RR_DELETE_FOR_APP=No delete records TA_REG_TEL_NUM=Yes TA_TEL_NUM_1=. TA_COUNT_ACTIVITY_IN_L1M=00
TA_COUNT_ACTIVITY_IN_L3M=00 TA_RES_COUNT_INCL_MOV_INFO=2 TA_NON_RES_COUNT_INCL_MOV_INFO=1 TYPE_1=Last link in a chain
LINK_DATE_1=29042021 EQUIFAX_ADDRESS_KEY_1=27030093486 STD_CODE_1=  LOCAL_NUMBER_1=  TPS_1=  DATE_LOADED_1=  LINE_TYPE_1= 
DISTANCE_1=9 NAME_MATCH_1=Associa NAME_1=MRS,SANDRA, ,PEARSON DOB_1=5031962 ADDITIONAL_NAME1_1=, , ADDITIONAL_NAME2_1=, ,
ADDITIONAL_NAME3_1=, , DISPUTE_ALERT=NO CIFAS=NO CSISF30=176 OPS_NUM_S=1 OPS_NUM_T=0.5 _ERROR_=1 _N_=117
NOTE: Invalid data for TA_TEL_NUM_1 in line 136 316-326.
136       135,10351016,Yes,,TEL1,Associate Trace IP,Verbal New - Exact,41 SANDALWOOD SQUARE,,SUNDERLAND,TYNE A
     101  ND WEAR,SR4 9SF,1300,Activity,29071964,NEIL,1,1,NO,Some,No,1,1,1,1,No,0,No load records,No delete re
     201  cords,No,,No searches ever,No searches ever,Other,4,0,Strong,No,2,2,2,2,No,0,No load records,No dele
     301  te records,Yes,***********,No searches ever,No searches ever,3,0,Name & DOB,30012023,14140053214,,,,
     401  ,,9,,",N, ,KEMP",29071964,",NEIL,","MR,NEIL,",", ,",NO,NO,+0170,1,2.5 469
SEQUENCE_NUMBER=135 REFERENCE_NUMBER=10351016 ADDRESS_MATCHED=Yes ERROR_MESSAGE=  SEGMENT_NUMBER=TEL1 SEGMENT=Associate Trace IP
OPS_FLAG=Verbal New - Exact TA_ADDRESS1=41 SANDALWOOD TA_ADDRESS2=  TA_ADDRESS3=SUNDERLAND TA_ADDRESS4=TYNE AND WEAR
TA_PCODE=SR4 9SF RANK_1=1300 RANK_TYPE_1=Activity APPENDED_DOB=29071964 APPENDED_FORENAME=NEIL NO_INDIVIDUALS_SHARING_NM_DOB=1
NO_INDIVIDUALS_SHARING_NM_NO_DOB=1 DECEASED=NO LAS_RES_IND=Some LAS_NON_RES_IND=No LAS_NO_OPEN_INSIGHT_ACC=1
LAS_NO_OPEN_INSIGHT_ACC_L3M=1 LAS_NO_OPEN_INSIGHT_ACC_LM=1 LAS_NO_DIFF_OPEN_INSIGHT_LENDERS=1 LAS_CURRENTLY_REGISTERED_ON_ER=No
LAS_TIME_SINCE_SUBJECT_ON_EER=0 LAS_NEW_RR_IN_DIFF_SURNAME=No load records LAS_TIME_SINCE_RR_DELETE_FOR_APP=No delete records
LAS_REGISTERED_TELEPHONE_NUMBER=No LAS_TEL_NUMBER=  LAS_COUNT_ACTIVITY_IN_L1M=No searches ever
LAS_COUNT_ACTIVITY_IN_L3M=No searches ever MOVEMENT_OUT_INDICATOR=Other LAS_RES_COUNT_INCL_MOV_INFO=4
8                                                          The SAS System                              10:29 Tuesday, April 11, 2023

LAS_NON_RES_COUNT_INCL_MOV_INFO=0 TA_RESIDENCY_IND=Strong TA_NON_RESIDENCY_IND=No TA_NO_OPEN_INSIGHT_ACC=2
TA_NO_OPEN_INSIGHT_ACC_L3M=2 TA_NO_OPEN_INSIGHT_ACC_L1M=2 TA_NO_DIFF_OPEN_INSIGHT_LENDERS=2 TA_CURR_REG_ON_ER=No
TA_TIME_SINCE_SUBJECT_ON_EER=0 TA_NEW_RR_IN_DIFF_SURNAME=No load records TA_TIME_SINCE_RR_DELETE_FOR_APP=No delete records
TA_REG_TEL_NUM=Yes TA_TEL_NUM_1=. TA_COUNT_ACTIVITY_IN_L1M=No searches ever TA_COUNT_ACTIVITY_IN_L3M=No searches ever
TA_RES_COUNT_INCL_MOV_INFO=3 TA_NON_RES_COUNT_INCL_MOV_INFO=0 TYPE_1=Name & DOB LINK_DATE_1=30012023
EQUIFAX_ADDRESS_KEY_1=14140053214 STD_CODE_1=  LOCAL_NUMBER_1=  TPS_1=  DATE_LOADED_1=  LINE_TYPE_1=  DISTANCE_1=9 NAME_MATCH_1= 
NAME_1=,N, ,KEMP DOB_1=29071964 ADDITIONAL_NAME1_1=,NEIL, ADDITIONAL_NAME2_1=MR,NEIL, ADDITIONAL_NAME3_1=, , DISPUTE_ALERT=NO
CIFAS=NO CSISF30=170 OPS_NUM_S=1 OPS_NUM_T=2.5 _ERROR_=1 _N_=135
NOTE: Invalid data for TA_TEL_NUM_1 in line 173 292-302.
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
173       172,104322268,Yes,,TEL9,Asct Trace No data,Verbal New – 2 Ver,259 BELLSHILL ROAD,,MOTHERWELL,LANARKS
     101  HIRE,ML1 3TN,1700,Movement,15101967,ANGELA,1,0,NO,Some,Some,2,2,2,1,No,0,No load records,No delete r
     201  ecords,Yes,***********,00,00,Associate,4,2,Some,Some,0,0,0,0,No,0,99,No delete records,Yes,*********
     301  **,No searches ever,No searches ever,2,1,Last link in a chain,21112022,65110011495,,,,,,9,Associate,
     401  "MR,MARK, ,RENDALL",30011970,", ,",", ,",", ,",NO,NO,+0167,1.5,0.5 466
SEQUENCE_NUMBER=172 REFERENCE_NUMBER=104322268 ADDRESS_MATCHED=Yes ERROR_MESSAGE=  SEGMENT_NUMBER=TEL9 SEGMENT=Asct Trace No data
OPS_FLAG=Verbal New – 2 Ver TA_ADDRESS1=259 BELLSHILL TA_ADDRESS2=  TA_ADDRESS3=MOTHERWELL TA_ADDRESS4=LANARKSHIRE TA_PCODE=ML1 3TN
RANK_1=1700 RANK_TYPE_1=Movement APPENDED_DOB=15101967 APPENDED_FORENAME=ANGELA NO_INDIVIDUALS_SHARING_NM_DOB=1
NO_INDIVIDUALS_SHARING_NM_NO_DOB=0 DECEASED=NO LAS_RES_IND=Some LAS_NON_RES_IND=Some LAS_NO_OPEN_INSIGHT_ACC=2
LAS_NO_OPEN_INSIGHT_ACC_L3M=2 LAS_NO_OPEN_INSIGHT_ACC_LM=2 LAS_NO_DIFF_OPEN_INSIGHT_LENDERS=1 LAS_CURRENTLY_REGISTERED_ON_ER=No
LAS_TIME_SINCE_SUBJECT_ON_EER=0 LAS_NEW_RR_IN_DIFF_SURNAME=No load records LAS_TIME_SINCE_RR_DELETE_FOR_APP=No delete records
LAS_REGISTERED_TELEPHONE_NUMBER=Yes LAS_TEL_NUMBER=*********** LAS_COUNT_ACTIVITY_IN_L1M=00 LAS_COUNT_ACTIVITY_IN_L3M=00
MOVEMENT_OUT_INDICATOR=Associate LAS_RES_COUNT_INCL_MOV_INFO=4 LAS_NON_RES_COUNT_INCL_MOV_INFO=2 TA_RESIDENCY_IND=Some
TA_NON_RESIDENCY_IND=So TA_NO_OPEN_INSIGHT_ACC=0 TA_NO_OPEN_INSIGHT_ACC_L3M=0 TA_NO_OPEN_INSIGHT_ACC_L1M=0
TA_NO_DIFF_OPEN_INSIGHT_LENDERS=0 TA_CURR_REG_ON_ER=No TA_TIME_SINCE_SUBJECT_ON_EER=0 TA_NEW_RR_IN_DIFF_SURNAME=99
TA_TIME_SINCE_RR_DELETE_FOR_APP=No delete records TA_REG_TEL_NUM=Yes TA_TEL_NUM_1=. TA_COUNT_ACTIVITY_IN_L1M=No searches ever
TA_COUNT_ACTIVITY_IN_L3M=No searches ever TA_RES_COUNT_INCL_MOV_INFO=2 TA_NON_RES_COUNT_INCL_MOV_INFO=1 TYPE_1=Last link in a chain
LINK_DATE_1=21112022 EQUIFAX_ADDRESS_KEY_1=65110011495 STD_CODE_1=  LOCAL_NUMBER_1=  TPS_1=  DATE_LOADED_1=  LINE_TYPE_1= 
DISTANCE_1=9 NAME_MATCH_1=Associa NAME_1=MR,MARK, ,RENDALL DOB_1=30011970 ADDITIONAL_NAME1_1=, , ADDITIONAL_NAME2_1=, ,
ADDITIONAL_NAME3_1=, , DISPUTE_ALERT=NO CIFAS=NO CSISF30=167 OPS_NUM_S=1.5 OPS_NUM_T=0.5 _ERROR_=1 _N_=172
NOTE: Invalid data for TA_TEL_NUM_1 in line 225 258-268.
225       224,105524565,Yes,,A1,App Trace No data,2 Ver,7 MILLER WAY,,STEVENAGE,HERTS,SG1 3UF,100,Movement,110
     101  11993,JODIE,1,1,NO,No,Strong,1,1,1,1,No,0,No load records,No delete records,No,,00,00,Subject,1,3,So
     201  me,No,0,0,0,0,No,0,No load records,No delete records,Yes,***********,00,00,2,0,Name & DOB,01022023,4
     301  5240042533,,,,,,0,,",J, ,CLARKE",11011993,",JODIE,L",",JODIE,",", ,",NO,NO,+0143,1,0.5 386
SEQUENCE_NUMBER=224 REFERENCE_NUMBER=105524565 ADDRESS_MATCHED=Yes ERROR_MESSAGE=  SEGMENT_NUMBER=A1 SEGMENT=App Trace No data
OPS_FLAG=2 Ver TA_ADDRESS1=7 MILLER WAY TA_ADDRESS2=  TA_ADDRESS3=STEVENAGE TA_ADDRESS4=HERTS TA_PCODE=SG1 3UF RANK_1=100
RANK_TYPE_1=Movement APPENDED_DOB=11011993 APPENDED_FORENAME=JODIE NO_INDIVIDUALS_SHARING_NM_DOB=1
NO_INDIVIDUALS_SHARING_NM_NO_DOB=1 DECEASED=NO LAS_RES_IND=No LAS_NON_RES_IND=Strong LAS_NO_OPEN_INSIGHT_ACC=1
LAS_NO_OPEN_INSIGHT_ACC_L3M=1 LAS_NO_OPEN_INSIGHT_ACC_LM=1 LAS_NO_DIFF_OPEN_INSIGHT_LENDERS=1 LAS_CURRENTLY_REGISTERED_ON_ER=No
LAS_TIME_SINCE_SUBJECT_ON_EER=0 LAS_NEW_RR_IN_DIFF_SURNAME=No load records LAS_TIME_SINCE_RR_DELETE_FOR_APP=No delete records
LAS_REGISTERED_TELEPHONE_NUMBER=No LAS_TEL_NUMBER=  LAS_COUNT_ACTIVITY_IN_L1M=00 LAS_COUNT_ACTIVITY_IN_L3M=00
MOVEMENT_OUT_INDICATOR=Subject LAS_RES_COUNT_INCL_MOV_INFO=1 LAS_NON_RES_COUNT_INCL_MOV_INFO=3 TA_RESIDENCY_IND=Some
TA_NON_RESIDENCY_IND=No TA_NO_OPEN_INSIGHT_ACC=0 TA_NO_OPEN_INSIGHT_ACC_L3M=0 TA_NO_OPEN_INSIGHT_ACC_L1M=0
TA_NO_DIFF_OPEN_INSIGHT_LENDERS=0 TA_CURR_REG_ON_ER=No TA_TIME_SINCE_SUBJECT_ON_EER=0 TA_NEW_RR_IN_DIFF_SURNAME=No load records
TA_TIME_SINCE_RR_DELETE_FOR_APP=No delete records TA_REG_TEL_NUM=Yes TA_TEL_NUM_1=. TA_COUNT_ACTIVITY_IN_L1M=00
TA_COUNT_ACTIVITY_IN_L3M=00 TA_RES_COUNT_INCL_MOV_INFO=2 TA_NON_RES_COUNT_INCL_MOV_INFO=0 TYPE_1=Name & DOB LINK_DATE_1=1022023
EQUIFAX_ADDRESS_KEY_1=45240042533 STD_CODE_1=  LOCAL_NUMBER_1=  TPS_1=  DATE_LOADED_1=  LINE_TYPE_1=  DISTANCE_1=0 NAME_MATCH_1= 
NAME_1=,J, ,CLARKE DOB_1=11011993 ADDITIONAL_NAME1_1=,JODIE,L ADDITIONAL_NAME2_1=,JODIE, ADDITIONAL_NAME3_1=, , DISPUTE_ALERT=NO
CIFAS=NO CSISF30=143 OPS_NUM_S=1 OPS_NUM_T=0.5 _ERROR_=1 _N_=224
NOTE: Invalid data for TA_TEL_NUM_1 in line 258 315-325.
258       257,106316193,Yes,,TEL9,Asct Trace No data,Verbal New – 2 Ver,314 LYTHALLS LANE,,COVENTRY,WEST MIDLA
     101  NDS,CV6 6GA,1700,Movement,24081968,KIREN,0,0,NO,No,Some,1,1,1,1,No,0,No load records,No delete recor
     201  ds,No,,No searches ever,No searches ever,Associate,2,2,Some,No,0,0,0,0,No,0,No load records,No delet
     301  e records,Yes,***********,No searches ever,No searches ever,2,0,Last link in a chain,21052020,410401
     401  23498,,,,,,20,Associate,"MR,JOHN, ,WILLIAMS",09051960,", ,",", ,",", ,",NO,NO,+0174,1,0.5 489
SEQUENCE_NUMBER=257 REFERENCE_NUMBER=106316193 ADDRESS_MATCHED=Yes ERROR_MESSAGE=  SEGMENT_NUMBER=TEL9 SEGMENT=Asct Trace No data
OPS_FLAG=Verbal New – 2 Ver TA_ADDRESS1=314 LYTHALLS L TA_ADDRESS2=  TA_ADDRESS3=COVENTRY TA_ADDRESS4=WEST MIDLANDS TA_PCODE=CV6 6GA
9                                                          The SAS System                              10:29 Tuesday, April 11, 2023

RANK_1=1700 RANK_TYPE_1=Movement APPENDED_DOB=24081968 APPENDED_FORENAME=KIREN NO_INDIVIDUALS_SHARING_NM_DOB=0
NO_INDIVIDUALS_SHARING_NM_NO_DOB=0 DECEASED=NO LAS_RES_IND=No LAS_NON_RES_IND=Some LAS_NO_OPEN_INSIGHT_ACC=1
LAS_NO_OPEN_INSIGHT_ACC_L3M=1 LAS_NO_OPEN_INSIGHT_ACC_LM=1 LAS_NO_DIFF_OPEN_INSIGHT_LENDERS=1 LAS_CURRENTLY_REGISTERED_ON_ER=No
LAS_TIME_SINCE_SUBJECT_ON_EER=0 LAS_NEW_RR_IN_DIFF_SURNAME=No load records LAS_TIME_SINCE_RR_DELETE_FOR_APP=No delete records
LAS_REGISTERED_TELEPHONE_NUMBER=No LAS_TEL_NUMBER=  LAS_COUNT_ACTIVITY_IN_L1M=No searches ever
LAS_COUNT_ACTIVITY_IN_L3M=No searches ever MOVEMENT_OUT_INDICATOR=Associate LAS_RES_COUNT_INCL_MOV_INFO=2
LAS_NON_RES_COUNT_INCL_MOV_INFO=2 TA_RESIDENCY_IND=Some TA_NON_RESIDENCY_IND=No TA_NO_OPEN_INSIGHT_ACC=0
TA_NO_OPEN_INSIGHT_ACC_L3M=0 TA_NO_OPEN_INSIGHT_ACC_L1M=0 TA_NO_DIFF_OPEN_INSIGHT_LENDERS=0 TA_CURR_REG_ON_ER=No
TA_TIME_SINCE_SUBJECT_ON_EER=0 TA_NEW_RR_IN_DIFF_SURNAME=No load records TA_TIME_SINCE_RR_DELETE_FOR_APP=No delete records
TA_REG_TEL_NUM=Yes TA_TEL_NUM_1=. TA_COUNT_ACTIVITY_IN_L1M=No searches ever TA_COUNT_ACTIVITY_IN_L3M=No searches ever
TA_RES_COUNT_INCL_MOV_INFO=2 TA_NON_RES_COUNT_INCL_MOV_INFO=0 TYPE_1=Last link in a chain LINK_DATE_1=21052020
EQUIFAX_ADDRESS_KEY_1=41040123498 STD_CODE_1=  LOCAL_NUMBER_1=  TPS_1=  DATE_LOADED_1=  LINE_TYPE_1=  DISTANCE_1=20
NAME_MATCH_1=Associa NAME_1=MR,JOHN, ,WILLIAMS DOB_1=9051960 ADDITIONAL_NAME1_1=, , ADDITIONAL_NAME2_1=, , ADDITIONAL_NAME3_1=, ,
DISPUTE_ALERT=NO CIFAS=NO CSISF30=174 OPS_NUM_S=1 OPS_NUM_T=0.5 _ERROR_=1 _N_=257
NOTE: Invalid data for TA_TEL_NUM_1 in line 271 323-333.
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
271       270,106565682,Yes,,A1,App Trace No data,2 Ver,143 MELTON ROAD,,SPROTBROUGH DONCASTER,SOUTH YORKSHIRE
     101  ,DN5 7NS,200,Movement and Activity,27011948,KENNETH,1,0,NO,No,Some,0,0,0,0,No,0,No load records,No d
     201  elete records,No,,No searches ever,No searches ever,Family,2,1,Some,No,0,0,0,0,No,0,No load records,
     301  No delete records,Yes,***********,No searches ever,No searches ever,2,0,Next,07022023,22020076586,,,
     401  ,,,9,Other,"MR,DAVID,GEORGE,BLACKBURN",24061966,", ,",", ,",", ,",NO,NO,+0176,0,0.5 483
SEQUENCE_NUMBER=270 REFERENCE_NUMBER=106565682 ADDRESS_MATCHED=Yes ERROR_MESSAGE=  SEGMENT_NUMBER=A1 SEGMENT=App Trace No data
OPS_FLAG=2 Ver TA_ADDRESS1=143 MELTON ROA TA_ADDRESS2=  TA_ADDRESS3=SPROTBROUGH DONCASTER TA_ADDRESS4=SOUTH YORKSHI TA_PCODE=DN5 7NS
RANK_1=200 RANK_TYPE_1=Movement APPENDED_DOB=27011948 APPENDED_FORENAME=KENNETH NO_INDIVIDUALS_SHARING_NM_DOB=1
NO_INDIVIDUALS_SHARING_NM_NO_DOB=0 DECEASED=NO LAS_RES_IND=No LAS_NON_RES_IND=Some LAS_NO_OPEN_INSIGHT_ACC=0
LAS_NO_OPEN_INSIGHT_ACC_L3M=0 LAS_NO_OPEN_INSIGHT_ACC_LM=0 LAS_NO_DIFF_OPEN_INSIGHT_LENDERS=0 LAS_CURRENTLY_REGISTERED_ON_ER=No
LAS_TIME_SINCE_SUBJECT_ON_EER=0 LAS_NEW_RR_IN_DIFF_SURNAME=No load records LAS_TIME_SINCE_RR_DELETE_FOR_APP=No delete records
LAS_REGISTERED_TELEPHONE_NUMBER=No LAS_TEL_NUMBER=  LAS_COUNT_ACTIVITY_IN_L1M=No searches ever
LAS_COUNT_ACTIVITY_IN_L3M=No searches ever MOVEMENT_OUT_INDICATOR=Family LAS_RES_COUNT_INCL_MOV_INFO=2
LAS_NON_RES_COUNT_INCL_MOV_INFO=1 TA_RESIDENCY_IND=Some TA_NON_RESIDENCY_IND=No TA_NO_OPEN_INSIGHT_ACC=0
TA_NO_OPEN_INSIGHT_ACC_L3M=0 TA_NO_OPEN_INSIGHT_ACC_L1M=0 TA_NO_DIFF_OPEN_INSIGHT_LENDERS=0 TA_CURR_REG_ON_ER=No
TA_TIME_SINCE_SUBJECT_ON_EER=0 TA_NEW_RR_IN_DIFF_SURNAME=No load records TA_TIME_SINCE_RR_DELETE_FOR_APP=No delete records
TA_REG_TEL_NUM=Yes TA_TEL_NUM_1=. TA_COUNT_ACTIVITY_IN_L1M=No searches ever TA_COUNT_ACTIVITY_IN_L3M=No searches ever
TA_RES_COUNT_INCL_MOV_INFO=2 TA_NON_RES_COUNT_INCL_MOV_INFO=0 TYPE_1=Next LINK_DATE_1=7022023 EQUIFAX_ADDRESS_KEY_1=22020076586
STD_CODE_1=  LOCAL_NUMBER_1=  TPS_1=  DATE_LOADED_1=  LINE_TYPE_1=  DISTANCE_1=9 NAME_MATCH_1=Other NAME_1=MR,DAVID,GEORGE,BLACKBURN
DOB_1=24061966 ADDITIONAL_NAME1_1=, , ADDITIONAL_NAME2_1=, , ADDITIONAL_NAME3_1=, , DISPUTE_ALERT=NO CIFAS=NO CSISF30=176
OPS_NUM_S=0 OPS_NUM_T=0.5 _ERROR_=1 _N_=270
NOTE: Invalid data for TA_TEL_NUM_1 in line 285 286-296.
285       284,107240616,Yes,,F1,App Trace 1 IN,1 Ver,FLAT 8 HAMILTON HOUSE 111 PALMERSTON ROAD,,SOUTHSEA,HANTS
     101  ,PO5 3PS,100,Movement,23061982,YUSEF,0,0,NO,No,Strong,1,1,1,1,Yes,0,No load records,No delete record
     201  s,No,,00,00,Subject,2,3,Strong,No,1,1,1,1,No,0,No load records,No delete records,Yes,***********,00,
     301  00,3,0,Last link in a chain,07042022,55280050311,,,,,,9,Subject,"MR,YUSEF, ,MBOMA",23061982,", ,",",
     401   ,",", ,",NO,NO,+0172,2,1.5 427
SEQUENCE_NUMBER=284 REFERENCE_NUMBER=107240616 ADDRESS_MATCHED=Yes ERROR_MESSAGE=  SEGMENT_NUMBER=F1 SEGMENT=App Trace 1 IN
OPS_FLAG=1 Ver TA_ADDRESS1=FLAT 8 HAMILTO TA_ADDRESS2=  TA_ADDRESS3=SOUTHSEA TA_ADDRESS4=HANTS TA_PCODE=PO5 3PS RANK_1=100
RANK_TYPE_1=Movement APPENDED_DOB=23061982 APPENDED_FORENAME=YUSEF NO_INDIVIDUALS_SHARING_NM_DOB=0
NO_INDIVIDUALS_SHARING_NM_NO_DOB=0 DECEASED=NO LAS_RES_IND=No LAS_NON_RES_IND=Strong LAS_NO_OPEN_INSIGHT_ACC=1
LAS_NO_OPEN_INSIGHT_ACC_L3M=1 LAS_NO_OPEN_INSIGHT_ACC_LM=1 LAS_NO_DIFF_OPEN_INSIGHT_LENDERS=1 LAS_CURRENTLY_REGISTERED_ON_ER=Yes
LAS_TIME_SINCE_SUBJECT_ON_EER=0 LAS_NEW_RR_IN_DIFF_SURNAME=No load records LAS_TIME_SINCE_RR_DELETE_FOR_APP=No delete records
LAS_REGISTERED_TELEPHONE_NUMBER=No LAS_TEL_NUMBER=  LAS_COUNT_ACTIVITY_IN_L1M=00 LAS_COUNT_ACTIVITY_IN_L3M=00
MOVEMENT_OUT_INDICATOR=Subject LAS_RES_COUNT_INCL_MOV_INFO=2 LAS_NON_RES_COUNT_INCL_MOV_INFO=3 TA_RESIDENCY_IND=Strong
TA_NON_RESIDENCY_IND=No TA_NO_OPEN_INSIGHT_ACC=1 TA_NO_OPEN_INSIGHT_ACC_L3M=1 TA_NO_OPEN_INSIGHT_ACC_L1M=1
TA_NO_DIFF_OPEN_INSIGHT_LENDERS=1 TA_CURR_REG_ON_ER=No TA_TIME_SINCE_SUBJECT_ON_EER=0 TA_NEW_RR_IN_DIFF_SURNAME=No load records
TA_TIME_SINCE_RR_DELETE_FOR_APP=No delete records TA_REG_TEL_NUM=Yes TA_TEL_NUM_1=. TA_COUNT_ACTIVITY_IN_L1M=00
TA_COUNT_ACTIVITY_IN_L3M=00 TA_RES_COUNT_INCL_MOV_INFO=3 TA_NON_RES_COUNT_INCL_MOV_INFO=0 TYPE_1=Last link in a chain
LINK_DATE_1=7042022 EQUIFAX_ADDRESS_KEY_1=55280050311 STD_CODE_1=  LOCAL_NUMBER_1=  TPS_1=  DATE_LOADED_1=  LINE_TYPE_1= 
DISTANCE_1=9 NAME_MATCH_1=Subject NAME_1=MR,YUSEF, ,MBOMA DOB_1=23061982 ADDITIONAL_NAME1_1=, , ADDITIONAL_NAME2_1=, ,
ADDITIONAL_NAME3_1=, , DISPUTE_ALERT=NO CIFAS=NO CSISF30=172 OPS_NUM_S=2 OPS_NUM_T=1.5 _ERROR_=1 _N_=284
10                                                         The SAS System                              10:29 Tuesday, April 11, 2023

NOTE: Invalid data for TA_TEL_NUM_1 in line 289 296-306.
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
289       288,107580425,Yes,,TEL6,Asct. Trace 1 IN,Verbal New – 1 Ver,87 ELMORE ROAD,,LEE-ON-THE-SOLENT,HANTS,
     101  PO139DY,1300,Activity,15021989,PAUL,1,0,NO,No,Strong,1,1,1,1,No,0,No load records,No delete records,
     201  Yes,***********,00,00,Subject,3,3,Strong,No,1,1,1,1,No,0,No load records,No delete records,Yes,*****
     301  ******,00,00,3,0,Name & DOB,22012023,55160001676,,,,,,9,,",P, ,SMITHERS",15021989,"MR,PAUL,T",", ,",
     401  ", ,",NO,NO,+0178,1.5,1.5 425
SEQUENCE_NUMBER=288 REFERENCE_NUMBER=107580425 ADDRESS_MATCHED=Yes ERROR_MESSAGE=  SEGMENT_NUMBER=TEL6 SEGMENT=Asct. Trace 1 IN
OPS_FLAG=Verbal New – 1 Ver TA_ADDRESS1=87 ELMORE ROAD TA_ADDRESS2=  TA_ADDRESS3=LEE-ON-THE-SOLENT TA_ADDRESS4=HANTS
TA_PCODE=PO139DY RANK_1=1300 RANK_TYPE_1=Activity APPENDED_DOB=15021989 APPENDED_FORENAME=PAUL NO_INDIVIDUALS_SHARING_NM_DOB=1
NO_INDIVIDUALS_SHARING_NM_NO_DOB=0 DECEASED=NO LAS_RES_IND=No LAS_NON_RES_IND=Strong LAS_NO_OPEN_INSIGHT_ACC=1
LAS_NO_OPEN_INSIGHT_ACC_L3M=1 LAS_NO_OPEN_INSIGHT_ACC_LM=1 LAS_NO_DIFF_OPEN_INSIGHT_LENDERS=1 LAS_CURRENTLY_REGISTERED_ON_ER=No
LAS_TIME_SINCE_SUBJECT_ON_EER=0 LAS_NEW_RR_IN_DIFF_SURNAME=No load records LAS_TIME_SINCE_RR_DELETE_FOR_APP=No delete records
LAS_REGISTERED_TELEPHONE_NUMBER=Yes LAS_TEL_NUMBER=*********** LAS_COUNT_ACTIVITY_IN_L1M=00 LAS_COUNT_ACTIVITY_IN_L3M=00
MOVEMENT_OUT_INDICATOR=Subject LAS_RES_COUNT_INCL_MOV_INFO=3 LAS_NON_RES_COUNT_INCL_MOV_INFO=3 TA_RESIDENCY_IND=Strong
TA_NON_RESIDENCY_IND=No TA_NO_OPEN_INSIGHT_ACC=1 TA_NO_OPEN_INSIGHT_ACC_L3M=1 TA_NO_OPEN_INSIGHT_ACC_L1M=1
TA_NO_DIFF_OPEN_INSIGHT_LENDERS=1 TA_CURR_REG_ON_ER=No TA_TIME_SINCE_SUBJECT_ON_EER=0 TA_NEW_RR_IN_DIFF_SURNAME=No load records
TA_TIME_SINCE_RR_DELETE_FOR_APP=No delete records TA_REG_TEL_NUM=Yes TA_TEL_NUM_1=. TA_COUNT_ACTIVITY_IN_L1M=00
TA_COUNT_ACTIVITY_IN_L3M=00 TA_RES_COUNT_INCL_MOV_INFO=3 TA_NON_RES_COUNT_INCL_MOV_INFO=0 TYPE_1=Name & DOB LINK_DATE_1=22012023
EQUIFAX_ADDRESS_KEY_1=55160001676 STD_CODE_1=  LOCAL_NUMBER_1=  TPS_1=  DATE_LOADED_1=  LINE_TYPE_1=  DISTANCE_1=9 NAME_MATCH_1= 
NAME_1=,P, ,SMITHERS DOB_1=15021989 ADDITIONAL_NAME1_1=MR,PAUL,T ADDITIONAL_NAME2_1=, , ADDITIONAL_NAME3_1=, , DISPUTE_ALERT=NO
CIFAS=NO CSISF30=178 OPS_NUM_S=1.5 OPS_NUM_T=1.5 _ERROR_=1 _N_=288
NOTE: Invalid data for TA_TEL_NUM_1 in line 290 306-316.
290       289,107648065,Yes,,T41,Applicant Trace IP,New Address Exact,66 OAKTREE DRIVE,,ANTRIM,CO.ANTRIM,BT411
     101  DB,100,Movement,02051986,MARK,1,0,NO,No,Strong,0,0,0,0,No,0,No load records,No delete records,No,,No
     201   searches ever,No searches ever,Subject,0,3,Strong,No,2,2,2,2,No,0,No load records,No delete records
     301  ,Yes,***********,00,00,3,0,Name & DOB,19012023,05010000647,,,,,,9,,",M, ,DUNN",02051986,"MR,MARK,","
     401  ,MARK,",", ,",NO,NO,+0147,0,2.5 431
SEQUENCE_NUMBER=289 REFERENCE_NUMBER=107648065 ADDRESS_MATCHED=Yes ERROR_MESSAGE=  SEGMENT_NUMBER=T41 SEGMENT=Applicant Trace IP
OPS_FLAG=New Address Exact TA_ADDRESS1=66 OAKTREE DRI TA_ADDRESS2=  TA_ADDRESS3=ANTRIM TA_ADDRESS4=CO.ANTRIM TA_PCODE=BT411DB
RANK_1=100 RANK_TYPE_1=Movement APPENDED_DOB=2051986 APPENDED_FORENAME=MARK NO_INDIVIDUALS_SHARING_NM_DOB=1
NO_INDIVIDUALS_SHARING_NM_NO_DOB=0 DECEASED=NO LAS_RES_IND=No LAS_NON_RES_IND=Strong LAS_NO_OPEN_INSIGHT_ACC=0
LAS_NO_OPEN_INSIGHT_ACC_L3M=0 LAS_NO_OPEN_INSIGHT_ACC_LM=0 LAS_NO_DIFF_OPEN_INSIGHT_LENDERS=0 LAS_CURRENTLY_REGISTERED_ON_ER=No
LAS_TIME_SINCE_SUBJECT_ON_EER=0 LAS_NEW_RR_IN_DIFF_SURNAME=No load records LAS_TIME_SINCE_RR_DELETE_FOR_APP=No delete records
LAS_REGISTERED_TELEPHONE_NUMBER=No LAS_TEL_NUMBER=  LAS_COUNT_ACTIVITY_IN_L1M=No searches ever
LAS_COUNT_ACTIVITY_IN_L3M=No searches ever MOVEMENT_OUT_INDICATOR=Subject LAS_RES_COUNT_INCL_MOV_INFO=0
LAS_NON_RES_COUNT_INCL_MOV_INFO=3 TA_RESIDENCY_IND=Strong TA_NON_RESIDENCY_IND=No TA_NO_OPEN_INSIGHT_ACC=2
TA_NO_OPEN_INSIGHT_ACC_L3M=2 TA_NO_OPEN_INSIGHT_ACC_L1M=2 TA_NO_DIFF_OPEN_INSIGHT_LENDERS=2 TA_CURR_REG_ON_ER=No
TA_TIME_SINCE_SUBJECT_ON_EER=0 TA_NEW_RR_IN_DIFF_SURNAME=No load records TA_TIME_SINCE_RR_DELETE_FOR_APP=No delete records
TA_REG_TEL_NUM=Yes TA_TEL_NUM_1=. TA_COUNT_ACTIVITY_IN_L1M=00 TA_COUNT_ACTIVITY_IN_L3M=00 TA_RES_COUNT_INCL_MOV_INFO=3
TA_NON_RES_COUNT_INCL_MOV_INFO=0 TYPE_1=Name & DOB LINK_DATE_1=19012023 EQUIFAX_ADDRESS_KEY_1=5010000647 STD_CODE_1= 
LOCAL_NUMBER_1=  TPS_1=  DATE_LOADED_1=  LINE_TYPE_1=  DISTANCE_1=9 NAME_MATCH_1=  NAME_1=,M, ,DUNN DOB_1=2051986
ADDITIONAL_NAME1_1=MR,MARK, ADDITIONAL_NAME2_1=,MARK, ADDITIONAL_NAME3_1=, , DISPUTE_ALERT=NO CIFAS=NO CSISF30=147 OPS_NUM_S=0
OPS_NUM_T=2.5 _ERROR_=1 _N_=289
NOTE: Invalid data for TA_TEL_NUM_1 in line 310 279-289.
310       309,108110412,Yes,,T41,Applicant Trace IP,New Address Exact,14 WREN ST,,OLDHAM,LANCS,OL4 5HB,100,Mov
     101  ement,08091984,KELLY,1,1,NO,No,Strong,0,0,0,0,No,0,No load records,No delete records,Yes,*********,0
     201  0,00,Subject,2,3,Strong,No,4,4,4,4,No,0,No load records,No delete records,Yes,***********,00,00,3,0,
     301  Last link in a chain,05122016,24090049501,,,,,,9,Subject,"MISS,KELLY,M,WALKER",08091984,", ,",", ,",
     401  ", ,",NO,NO,+0174,0.5,4.5 425
SEQUENCE_NUMBER=309 REFERENCE_NUMBER=108110412 ADDRESS_MATCHED=Yes ERROR_MESSAGE=  SEGMENT_NUMBER=T41 SEGMENT=Applicant Trace IP
OPS_FLAG=New Address Exact TA_ADDRESS1=14 WREN ST TA_ADDRESS2=  TA_ADDRESS3=OLDHAM TA_ADDRESS4=LANCS TA_PCODE=OL4 5HB RANK_1=100
RANK_TYPE_1=Movement APPENDED_DOB=8091984 APPENDED_FORENAME=KELLY NO_INDIVIDUALS_SHARING_NM_DOB=1 NO_INDIVIDUALS_SHARING_NM_NO_DOB=1
DECEASED=NO LAS_RES_IND=No LAS_NON_RES_IND=Strong LAS_NO_OPEN_INSIGHT_ACC=0 LAS_NO_OPEN_INSIGHT_ACC_L3M=0
LAS_NO_OPEN_INSIGHT_ACC_LM=0 LAS_NO_DIFF_OPEN_INSIGHT_LENDERS=0 LAS_CURRENTLY_REGISTERED_ON_ER=No LAS_TIME_SINCE_SUBJECT_ON_EER=0
LAS_NEW_RR_IN_DIFF_SURNAME=No load records LAS_TIME_SINCE_RR_DELETE_FOR_APP=No delete records LAS_REGISTERED_TELEPHONE_NUMBER=Yes
LAS_TEL_NUMBER=********* LAS_COUNT_ACTIVITY_IN_L1M=00 LAS_COUNT_ACTIVITY_IN_L3M=00 MOVEMENT_OUT_INDICATOR=Subject
LAS_RES_COUNT_INCL_MOV_INFO=2 LAS_NON_RES_COUNT_INCL_MOV_INFO=3 TA_RESIDENCY_IND=Strong TA_NON_RESIDENCY_IND=No
11                                                         The SAS System                              10:29 Tuesday, April 11, 2023

TA_NO_OPEN_INSIGHT_ACC=4 TA_NO_OPEN_INSIGHT_ACC_L3M=4 TA_NO_OPEN_INSIGHT_ACC_L1M=4 TA_NO_DIFF_OPEN_INSIGHT_LENDERS=4
TA_CURR_REG_ON_ER=No TA_TIME_SINCE_SUBJECT_ON_EER=0 TA_NEW_RR_IN_DIFF_SURNAME=No load records
TA_TIME_SINCE_RR_DELETE_FOR_APP=No delete records TA_REG_TEL_NUM=Yes TA_TEL_NUM_1=. TA_COUNT_ACTIVITY_IN_L1M=00
TA_COUNT_ACTIVITY_IN_L3M=00 TA_RES_COUNT_INCL_MOV_INFO=3 TA_NON_RES_COUNT_INCL_MOV_INFO=0 TYPE_1=Last link in a chain
LINK_DATE_1=5122016 EQUIFAX_ADDRESS_KEY_1=24090049501 STD_CODE_1=  LOCAL_NUMBER_1=  TPS_1=  DATE_LOADED_1=  LINE_TYPE_1= 
DISTANCE_1=9 NAME_MATCH_1=Subject NAME_1=MISS,KELLY,M,WALKER DOB_1=8091984 ADDITIONAL_NAME1_1=, , ADDITIONAL_NAME2_1=, ,
ADDITIONAL_NAME3_1=, , DISPUTE_ALERT=NO CIFAS=NO CSISF30=174 OPS_NUM_S=0.5 OPS_NUM_T=4.5 _ERROR_=1 _N_=309
NOTE: Invalid data for TA_TEL_NUM_1 in line 311 291-301.
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
311       310,108132259,Yes,,F1,App Trace 1 IN,1 Ver,2A MILDENHALL ROAD,,SLOUGH,BERKS,SL1 3JE,100,Movement,040
     101  21972,FAISAL,1,0,NO,No,Strong,0,0,0,0,No,0,No load records,No delete records,Yes,***********,No sear
     201  ches ever,No searches ever,Subject,2,3,Strong,Some,1,1,1,1,No,10,11,No delete records,Yes,**********
     301  *,No searches ever,No searches ever,3,2,Name & DOB,18012023,50080008175,,,,,,9,,",F, ,GHAFOOR",04021
     401  972,"MR,FAISAL,",", ,",", ,",NO,NO,+0169,0.5,1.5 448
SEQUENCE_NUMBER=310 REFERENCE_NUMBER=108132259 ADDRESS_MATCHED=Yes ERROR_MESSAGE=  SEGMENT_NUMBER=F1 SEGMENT=App Trace 1 IN
OPS_FLAG=1 Ver TA_ADDRESS1=2A MILDENHALL TA_ADDRESS2=  TA_ADDRESS3=SLOUGH TA_ADDRESS4=BERKS TA_PCODE=SL1 3JE RANK_1=100
RANK_TYPE_1=Movement APPENDED_DOB=4021972 APPENDED_FORENAME=FAISAL NO_INDIVIDUALS_SHARING_NM_DOB=1
NO_INDIVIDUALS_SHARING_NM_NO_DOB=0 DECEASED=NO LAS_RES_IND=No LAS_NON_RES_IND=Strong LAS_NO_OPEN_INSIGHT_ACC=0
LAS_NO_OPEN_INSIGHT_ACC_L3M=0 LAS_NO_OPEN_INSIGHT_ACC_LM=0 LAS_NO_DIFF_OPEN_INSIGHT_LENDERS=0 LAS_CURRENTLY_REGISTERED_ON_ER=No
LAS_TIME_SINCE_SUBJECT_ON_EER=0 LAS_NEW_RR_IN_DIFF_SURNAME=No load records LAS_TIME_SINCE_RR_DELETE_FOR_APP=No delete records
LAS_REGISTERED_TELEPHONE_NUMBER=Yes LAS_TEL_NUMBER=*********** LAS_COUNT_ACTIVITY_IN_L1M=No searches ever
LAS_COUNT_ACTIVITY_IN_L3M=No searches ever MOVEMENT_OUT_INDICATOR=Subject LAS_RES_COUNT_INCL_MOV_INFO=2
LAS_NON_RES_COUNT_INCL_MOV_INFO=3 TA_RESIDENCY_IND=Strong TA_NON_RESIDENCY_IND=So TA_NO_OPEN_INSIGHT_ACC=1
TA_NO_OPEN_INSIGHT_ACC_L3M=1 TA_NO_OPEN_INSIGHT_ACC_L1M=1 TA_NO_DIFF_OPEN_INSIGHT_LENDERS=1 TA_CURR_REG_ON_ER=No
TA_TIME_SINCE_SUBJECT_ON_EER=10 TA_NEW_RR_IN_DIFF_SURNAME=11 TA_TIME_SINCE_RR_DELETE_FOR_APP=No delete records TA_REG_TEL_NUM=Yes
TA_TEL_NUM_1=. TA_COUNT_ACTIVITY_IN_L1M=No searches ever TA_COUNT_ACTIVITY_IN_L3M=No searches ever TA_RES_COUNT_INCL_MOV_INFO=3
TA_NON_RES_COUNT_INCL_MOV_INFO=2 TYPE_1=Name & DOB LINK_DATE_1=18012023 EQUIFAX_ADDRESS_KEY_1=50080008175 STD_CODE_1= 
LOCAL_NUMBER_1=  TPS_1=  DATE_LOADED_1=  LINE_TYPE_1=  DISTANCE_1=9 NAME_MATCH_1=  NAME_1=,F, ,GHAFOOR DOB_1=4021972
ADDITIONAL_NAME1_1=MR,FAISAL, ADDITIONAL_NAME2_1=, , ADDITIONAL_NAME3_1=, , DISPUTE_ALERT=NO CIFAS=NO CSISF30=169 OPS_NUM_S=0.5
OPS_NUM_T=1.5 _ERROR_=1 _N_=310
NOTE: Invalid data for TA_TEL_NUM_1 in line 334 309-319.
334       333,108289380,Yes,,TEL1,Associate Trace IP,Verbal New - Exact,19 BRIGHTWELL AVENUE,,WESTCLIFF-ON-SEA
     101  ,ESSEX,SS0 9EB,1300,Activity,,LINDA,1,3,NO,No,Some,0,0,0,0,No,0,No load records,No delete records,No
     201  ,,No searches ever,No searches ever,Family,2,1,Strong,No,3,3,3,3,No,0,No load records,No delete reco
     301  rds,Yes,***********,No searches ever,No searches ever,3,0,Name & DOB,26012023,44460012835,,,,,,9,,",
     401  L, ,RICHARDS",13021962,",LINDA,","MS,LINDA,","MRS,LINDA,",NO,NO,+0175,0,3.5 475
SEQUENCE_NUMBER=333 REFERENCE_NUMBER=108289380 ADDRESS_MATCHED=Yes ERROR_MESSAGE=  SEGMENT_NUMBER=TEL1 SEGMENT=Associate Trace IP
OPS_FLAG=Verbal New - Exact TA_ADDRESS1=19 BRIGHTWELL TA_ADDRESS2=  TA_ADDRESS3=WESTCLIFF-ON-SEA TA_ADDRESS4=ESSEX TA_PCODE=SS0 9EB
RANK_1=1300 RANK_TYPE_1=Activity APPENDED_DOB=. APPENDED_FORENAME=LINDA NO_INDIVIDUALS_SHARING_NM_DOB=1
NO_INDIVIDUALS_SHARING_NM_NO_DOB=3 DECEASED=NO LAS_RES_IND=No LAS_NON_RES_IND=Some LAS_NO_OPEN_INSIGHT_ACC=0
LAS_NO_OPEN_INSIGHT_ACC_L3M=0 LAS_NO_OPEN_INSIGHT_ACC_LM=0 LAS_NO_DIFF_OPEN_INSIGHT_LENDERS=0 LAS_CURRENTLY_REGISTERED_ON_ER=No
LAS_TIME_SINCE_SUBJECT_ON_EER=0 LAS_NEW_RR_IN_DIFF_SURNAME=No load records LAS_TIME_SINCE_RR_DELETE_FOR_APP=No delete records
LAS_REGISTERED_TELEPHONE_NUMBER=No LAS_TEL_NUMBER=  LAS_COUNT_ACTIVITY_IN_L1M=No searches ever
LAS_COUNT_ACTIVITY_IN_L3M=No searches ever MOVEMENT_OUT_INDICATOR=Family LAS_RES_COUNT_INCL_MOV_INFO=2
LAS_NON_RES_COUNT_INCL_MOV_INFO=1 TA_RESIDENCY_IND=Strong TA_NON_RESIDENCY_IND=No TA_NO_OPEN_INSIGHT_ACC=3
TA_NO_OPEN_INSIGHT_ACC_L3M=3 TA_NO_OPEN_INSIGHT_ACC_L1M=3 TA_NO_DIFF_OPEN_INSIGHT_LENDERS=3 TA_CURR_REG_ON_ER=No
TA_TIME_SINCE_SUBJECT_ON_EER=0 TA_NEW_RR_IN_DIFF_SURNAME=No load records TA_TIME_SINCE_RR_DELETE_FOR_APP=No delete records
TA_REG_TEL_NUM=Yes TA_TEL_NUM_1=. TA_COUNT_ACTIVITY_IN_L1M=No searches ever TA_COUNT_ACTIVITY_IN_L3M=No searches ever
TA_RES_COUNT_INCL_MOV_INFO=3 TA_NON_RES_COUNT_INCL_MOV_INFO=0 TYPE_1=Name & DOB LINK_DATE_1=26012023
EQUIFAX_ADDRESS_KEY_1=44460012835 STD_CODE_1=  LOCAL_NUMBER_1=  TPS_1=  DATE_LOADED_1=  LINE_TYPE_1=  DISTANCE_1=9 NAME_MATCH_1= 
NAME_1=,L, ,RICHARDS DOB_1=13021962 ADDITIONAL_NAME1_1=,LINDA, ADDITIONAL_NAME2_1=MS,LINDA, ADDITIONAL_NAME3_1=MRS,LINDA,
DISPUTE_ALERT=NO CIFAS=NO CSISF30=175 OPS_NUM_S=0 OPS_NUM_T=3.5 _ERROR_=1 _N_=333
NOTE: Invalid data for TA_TEL_NUM_1 in line 360 284-294.
360       359,108762089,Yes,,F1,App Trace 1 IN,1 Ver,35 VEGA ROAD,,BUSHEY,HERTS,WD234JA,100,Movement,15091990,
     101  BRADLEY,1,0,NO,No,Strong,0,0,0,0,No,0,No load records,No delete records,No,,No searches ever,No sear
     201  ches ever,Subject,0,3,Strong,No,1,1,1,1,No,0,No load records,No delete records,Yes,***********,00,00
     301  ,3,0,Name & DOB,26012023,45320007672,,,,,,9,,",B, ,DOLBY",15091990,"MR,BRADLEY,J",",BRADLEY,",", ,",
     401  NO,NO,+0167,0,1.5 417
12                                                         The SAS System                              10:29 Tuesday, April 11, 2023

SEQUENCE_NUMBER=359 REFERENCE_NUMBER=108762089 ADDRESS_MATCHED=Yes ERROR_MESSAGE=  SEGMENT_NUMBER=F1 SEGMENT=App Trace 1 IN
OPS_FLAG=1 Ver TA_ADDRESS1=35 VEGA ROAD TA_ADDRESS2=  TA_ADDRESS3=BUSHEY TA_ADDRESS4=HERTS TA_PCODE=WD234JA RANK_1=100
RANK_TYPE_1=Movement APPENDED_DOB=15091990 APPENDED_FORENAME=BRADLEY NO_INDIVIDUALS_SHARING_NM_DOB=1
NO_INDIVIDUALS_SHARING_NM_NO_DOB=0 DECEASED=NO LAS_RES_IND=No LAS_NON_RES_IND=Strong LAS_NO_OPEN_INSIGHT_ACC=0
LAS_NO_OPEN_INSIGHT_ACC_L3M=0 LAS_NO_OPEN_INSIGHT_ACC_LM=0 LAS_NO_DIFF_OPEN_INSIGHT_LENDERS=0 LAS_CURRENTLY_REGISTERED_ON_ER=No
LAS_TIME_SINCE_SUBJECT_ON_EER=0 LAS_NEW_RR_IN_DIFF_SURNAME=No load records LAS_TIME_SINCE_RR_DELETE_FOR_APP=No delete records
LAS_REGISTERED_TELEPHONE_NUMBER=No LAS_TEL_NUMBER=  LAS_COUNT_ACTIVITY_IN_L1M=No searches ever
LAS_COUNT_ACTIVITY_IN_L3M=No searches ever MOVEMENT_OUT_INDICATOR=Subject LAS_RES_COUNT_INCL_MOV_INFO=0
LAS_NON_RES_COUNT_INCL_MOV_INFO=3 TA_RESIDENCY_IND=Strong TA_NON_RESIDENCY_IND=No TA_NO_OPEN_INSIGHT_ACC=1
TA_NO_OPEN_INSIGHT_ACC_L3M=1 TA_NO_OPEN_INSIGHT_ACC_L1M=1 TA_NO_DIFF_OPEN_INSIGHT_LENDERS=1 TA_CURR_REG_ON_ER=No
TA_TIME_SINCE_SUBJECT_ON_EER=0 TA_NEW_RR_IN_DIFF_SURNAME=No load records TA_TIME_SINCE_RR_DELETE_FOR_APP=No delete records
TA_REG_TEL_NUM=Yes TA_TEL_NUM_1=. TA_COUNT_ACTIVITY_IN_L1M=00 TA_COUNT_ACTIVITY_IN_L3M=00 TA_RES_COUNT_INCL_MOV_INFO=3
TA_NON_RES_COUNT_INCL_MOV_INFO=0 TYPE_1=Name & DOB LINK_DATE_1=26012023 EQUIFAX_ADDRESS_KEY_1=45320007672 STD_CODE_1= 
LOCAL_NUMBER_1=  TPS_1=  DATE_LOADED_1=  LINE_TYPE_1=  DISTANCE_1=9 NAME_MATCH_1=  NAME_1=,B, ,DOLBY DOB_1=15091990
ADDITIONAL_NAME1_1=MR,BRADLEY,J ADDITIONAL_NAME2_1=,BRADLEY, ADDITIONAL_NAME3_1=, , DISPUTE_ALERT=NO CIFAS=NO CSISF30=167
OPS_NUM_S=0 OPS_NUM_T=1.5 _ERROR_=1 _N_=359
NOTE: Invalid data for TA_TEL_NUM_1 in line 382 304-314.
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
382       381,109790212,Yes,,T41,Applicant Trace IP,New Address Exact,49 MANAGUA CLOSE,,CAVERSHAM READING,BERK
     101  S,RG4 5LX,100,Movement,05111961,BEVERLEY,1,0,NO,No,Strong,0,0,0,0,No,0,99,No delete records,No,,No s
     201  earches ever,No searches ever,Subject,0,4,Strong,No,7,7,7,6,No,0,No load records,No delete records,Y
     301  es,***********,No searches ever,No searches ever,3,0,Name & DOB,26012023,50070163282,,,,,,9,,",B, ,D
     401  IMES",05111961,",BEVERLEY,I","MS,BEVERLEY,","MISS,BEVERLEY,",NO,NO,+0186,0,6.5 478
SEQUENCE_NUMBER=381 REFERENCE_NUMBER=109790212 ADDRESS_MATCHED=Yes ERROR_MESSAGE=  SEGMENT_NUMBER=T41 SEGMENT=Applicant Trace IP
OPS_FLAG=New Address Exact TA_ADDRESS1=49 MANAGUA CLO TA_ADDRESS2=  TA_ADDRESS3=CAVERSHAM READING TA_ADDRESS4=BERKS TA_PCODE=RG4 5LX
RANK_1=100 RANK_TYPE_1=Movement APPENDED_DOB=5111961 APPENDED_FORENAME=BEVERLEY NO_INDIVIDUALS_SHARING_NM_DOB=1
NO_INDIVIDUALS_SHARING_NM_NO_DOB=0 DECEASED=NO LAS_RES_IND=No LAS_NON_RES_IND=Strong LAS_NO_OPEN_INSIGHT_ACC=0
LAS_NO_OPEN_INSIGHT_ACC_L3M=0 LAS_NO_OPEN_INSIGHT_ACC_LM=0 LAS_NO_DIFF_OPEN_INSIGHT_LENDERS=0 LAS_CURRENTLY_REGISTERED_ON_ER=No
LAS_TIME_SINCE_SUBJECT_ON_EER=0 LAS_NEW_RR_IN_DIFF_SURNAME=99 LAS_TIME_SINCE_RR_DELETE_FOR_APP=No delete records
LAS_REGISTERED_TELEPHONE_NUMBER=No LAS_TEL_NUMBER=  LAS_COUNT_ACTIVITY_IN_L1M=No searches ever
LAS_COUNT_ACTIVITY_IN_L3M=No searches ever MOVEMENT_OUT_INDICATOR=Subject LAS_RES_COUNT_INCL_MOV_INFO=0
LAS_NON_RES_COUNT_INCL_MOV_INFO=4 TA_RESIDENCY_IND=Strong TA_NON_RESIDENCY_IND=No TA_NO_OPEN_INSIGHT_ACC=7
TA_NO_OPEN_INSIGHT_ACC_L3M=7 TA_NO_OPEN_INSIGHT_ACC_L1M=7 TA_NO_DIFF_OPEN_INSIGHT_LENDERS=6 TA_CURR_REG_ON_ER=No
TA_TIME_SINCE_SUBJECT_ON_EER=0 TA_NEW_RR_IN_DIFF_SURNAME=No load records TA_TIME_SINCE_RR_DELETE_FOR_APP=No delete records
TA_REG_TEL_NUM=Yes TA_TEL_NUM_1=. TA_COUNT_ACTIVITY_IN_L1M=No searches ever TA_COUNT_ACTIVITY_IN_L3M=No searches ever
TA_RES_COUNT_INCL_MOV_INFO=3 TA_NON_RES_COUNT_INCL_MOV_INFO=0 TYPE_1=Name & DOB LINK_DATE_1=26012023
EQUIFAX_ADDRESS_KEY_1=50070163282 STD_CODE_1=  LOCAL_NUMBER_1=  TPS_1=  DATE_LOADED_1=  LINE_TYPE_1=  DISTANCE_1=9 NAME_MATCH_1= 
NAME_1=,B, ,DIMES DOB_1=5111961 ADDITIONAL_NAME1_1=,BEVERLEY,I ADDITIONAL_NAME2_1=MS,BEVERLEY, ADDITIONAL_NAME3_1=MISS,BEVERLEY,
DISPUTE_ALERT=NO CIFAS=NO CSISF30=186 OPS_NUM_S=0 OPS_NUM_T=6.5 _ERROR_=1 _N_=381
NOTE: Invalid data for TA_TEL_NUM_1 in line 406 301-311.
406       405,111048054,Yes,,F1,App Trace 1 IN,1 Ver,2 GREENE PARK PLACE,,CROWBOROUGH,EAST SUSSEX,TN6 2GL,100,
     101  Movement,06061988,ASHLEY,1,0,NO,No,Strong,0,0,0,0,No,0,No load records,No delete records,No,,No sear
     201  ches ever,No searches ever,Subject,0,3,Strong,No,1,1,1,1,No,0,No load records,No delete records,Yes,
     301  ***********,No searches ever,No searches ever,3,0,Name & DOB,26012023,54040017282,,,,,,0,,",A, ,BURT
     401  ON",06061988,",ASHLEY,J","MR,ASHLEY,J","MR,ASHLEY,",NO,NO,+0183,0,1.5 469
SEQUENCE_NUMBER=405 REFERENCE_NUMBER=111048054 ADDRESS_MATCHED=Yes ERROR_MESSAGE=  SEGMENT_NUMBER=F1 SEGMENT=App Trace 1 IN
OPS_FLAG=1 Ver TA_ADDRESS1=2 GREENE PARK TA_ADDRESS2=  TA_ADDRESS3=CROWBOROUGH TA_ADDRESS4=EAST SUSSEX TA_PCODE=TN6 2GL RANK_1=100
RANK_TYPE_1=Movement APPENDED_DOB=6061988 APPENDED_FORENAME=ASHLEY NO_INDIVIDUALS_SHARING_NM_DOB=1
NO_INDIVIDUALS_SHARING_NM_NO_DOB=0 DECEASED=NO LAS_RES_IND=No LAS_NON_RES_IND=Strong LAS_NO_OPEN_INSIGHT_ACC=0
LAS_NO_OPEN_INSIGHT_ACC_L3M=0 LAS_NO_OPEN_INSIGHT_ACC_LM=0 LAS_NO_DIFF_OPEN_INSIGHT_LENDERS=0 LAS_CURRENTLY_REGISTERED_ON_ER=No
LAS_TIME_SINCE_SUBJECT_ON_EER=0 LAS_NEW_RR_IN_DIFF_SURNAME=No load records LAS_TIME_SINCE_RR_DELETE_FOR_APP=No delete records
LAS_REGISTERED_TELEPHONE_NUMBER=No LAS_TEL_NUMBER=  LAS_COUNT_ACTIVITY_IN_L1M=No searches ever
LAS_COUNT_ACTIVITY_IN_L3M=No searches ever MOVEMENT_OUT_INDICATOR=Subject LAS_RES_COUNT_INCL_MOV_INFO=0
LAS_NON_RES_COUNT_INCL_MOV_INFO=3 TA_RESIDENCY_IND=Strong TA_NON_RESIDENCY_IND=No TA_NO_OPEN_INSIGHT_ACC=1
TA_NO_OPEN_INSIGHT_ACC_L3M=1 TA_NO_OPEN_INSIGHT_ACC_L1M=1 TA_NO_DIFF_OPEN_INSIGHT_LENDERS=1 TA_CURR_REG_ON_ER=No
TA_TIME_SINCE_SUBJECT_ON_EER=0 TA_NEW_RR_IN_DIFF_SURNAME=No load records TA_TIME_SINCE_RR_DELETE_FOR_APP=No delete records
TA_REG_TEL_NUM=Yes TA_TEL_NUM_1=. TA_COUNT_ACTIVITY_IN_L1M=No searches ever TA_COUNT_ACTIVITY_IN_L3M=No searches ever
TA_RES_COUNT_INCL_MOV_INFO=3 TA_NON_RES_COUNT_INCL_MOV_INFO=0 TYPE_1=Name & DOB LINK_DATE_1=26012023
13                                                         The SAS System                              10:29 Tuesday, April 11, 2023

EQUIFAX_ADDRESS_KEY_1=54040017282 STD_CODE_1=  LOCAL_NUMBER_1=  TPS_1=  DATE_LOADED_1=  LINE_TYPE_1=  DISTANCE_1=0 NAME_MATCH_1= 
NAME_1=,A, ,BURTON DOB_1=6061988 ADDITIONAL_NAME1_1=,ASHLEY,J ADDITIONAL_NAME2_1=MR,ASHLEY,J ADDITIONAL_NAME3_1=MR,ASHLEY,
DISPUTE_ALERT=NO CIFAS=NO CSISF30=183 OPS_NUM_S=0 OPS_NUM_T=1.5 _ERROR_=1 _N_=405
NOTE: Invalid data for TA_TEL_NUM_1 in line 446 267-277.
WARNING: Limit set by ERRORS= option reached.  Further errors of this type will not be printed.
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
446       445,112537386,Yes,,F1,App Trace 1 IN,1 Ver,3 HONEYMANS CLOSE,,TROWBRIDGE,WILTS,BA147DW,100,Movement,
     101  11091979,RADOUANE,1,0,NO,No,Strong,0,0,0,0,Yes,0,No load records,No delete records,No,,00,00,Subject
     201  ,1,3,Strong,No,1,1,1,1,No,0,No load records,No delete records,Yes,***********,No searches ever,No se
     301  arches ever,3,0,Last link in a chain,19092022,58130007325,,,,,,0,Subject,"MR,RADOUANE, ,BENDHIYAF",1
     401  1091979,", ,",", ,",", ,",NO,NO,+0185,1,1.5 443
SEQUENCE_NUMBER=445 REFERENCE_NUMBER=112537386 ADDRESS_MATCHED=Yes ERROR_MESSAGE=  SEGMENT_NUMBER=F1 SEGMENT=App Trace 1 IN
OPS_FLAG=1 Ver TA_ADDRESS1=3 HONEYMANS CL TA_ADDRESS2=  TA_ADDRESS3=TROWBRIDGE TA_ADDRESS4=WILTS TA_PCODE=BA147DW RANK_1=100
RANK_TYPE_1=Movement APPENDED_DOB=11091979 APPENDED_FORENAME=RADOUANE NO_INDIVIDUALS_SHARING_NM_DOB=1
NO_INDIVIDUALS_SHARING_NM_NO_DOB=0 DECEASED=NO LAS_RES_IND=No LAS_NON_RES_IND=Strong LAS_NO_OPEN_INSIGHT_ACC=0
LAS_NO_OPEN_INSIGHT_ACC_L3M=0 LAS_NO_OPEN_INSIGHT_ACC_LM=0 LAS_NO_DIFF_OPEN_INSIGHT_LENDERS=0 LAS_CURRENTLY_REGISTERED_ON_ER=Yes
LAS_TIME_SINCE_SUBJECT_ON_EER=0 LAS_NEW_RR_IN_DIFF_SURNAME=No load records LAS_TIME_SINCE_RR_DELETE_FOR_APP=No delete records
LAS_REGISTERED_TELEPHONE_NUMBER=No LAS_TEL_NUMBER=  LAS_COUNT_ACTIVITY_IN_L1M=00 LAS_COUNT_ACTIVITY_IN_L3M=00
MOVEMENT_OUT_INDICATOR=Subject LAS_RES_COUNT_INCL_MOV_INFO=1 LAS_NON_RES_COUNT_INCL_MOV_INFO=3 TA_RESIDENCY_IND=Strong
TA_NON_RESIDENCY_IND=No TA_NO_OPEN_INSIGHT_ACC=1 TA_NO_OPEN_INSIGHT_ACC_L3M=1 TA_NO_OPEN_INSIGHT_ACC_L1M=1
TA_NO_DIFF_OPEN_INSIGHT_LENDERS=1 TA_CURR_REG_ON_ER=No TA_TIME_SINCE_SUBJECT_ON_EER=0 TA_NEW_RR_IN_DIFF_SURNAME=No load records
TA_TIME_SINCE_RR_DELETE_FOR_APP=No delete records TA_REG_TEL_NUM=Yes TA_TEL_NUM_1=. TA_COUNT_ACTIVITY_IN_L1M=No searches ever
TA_COUNT_ACTIVITY_IN_L3M=No searches ever TA_RES_COUNT_INCL_MOV_INFO=3 TA_NON_RES_COUNT_INCL_MOV_INFO=0 TYPE_1=Last link in a chain
LINK_DATE_1=19092022 EQUIFAX_ADDRESS_KEY_1=58130007325 STD_CODE_1=  LOCAL_NUMBER_1=  TPS_1=  DATE_LOADED_1=  LINE_TYPE_1= 
DISTANCE_1=0 NAME_MATCH_1=Subject NAME_1=MR,RADOUANE, ,BENDHIYAF DOB_1=11091979 ADDITIONAL_NAME1_1=, , ADDITIONAL_NAME2_1=, ,
ADDITIONAL_NAME3_1=, , DISPUTE_ALERT=NO CIFAS=NO CSISF30=185 OPS_NUM_S=1 OPS_NUM_T=1.5 _ERROR_=1 _N_=445
NOTE: 995394 records were read from the infile '\\lowell2.local\shares\Public\Trace\Trace Integrity Analyst 
      Data\BAU_Processes\SAS\Enhanced TPT\Storage\Monthly Washes\Trace_2023_02_10\elnz_Lowell_10Feb.CSV'.
      The minimum record length was 114.
      The maximum record length was 542.
NOTE: The data set WORK.FEB_RELEASE has 995394 observations and 72 variables.
NOTE: Compressing data set WORK.FEB_RELEASE decreased size by 54.32 percent. 
      Compressed is 4415 pages; un-compressed would require 9665 pages.
NOTE: DATA statement used (Total process time):
      real time           5.95 seconds
      user cpu time       5.20 seconds
      system cpu time     0.32 seconds
      memory              9389.78k
      OS Memory           37480.00k
      Timestamp           04/11/2023 01:12:05 PM
      Step Count                        15  Switch Count  2
      

Errors detected in submitted DATA step. Examine log.
995394 rows created in WORK.FEB_RELEASE from \\lowell2.local\shares\Public\Trace\Trace Integrity Analyst 
Data\BAU_Processes\SAS\Enhanced TPT\Storage\Monthly 
Washes\Trace_2023_02_10\elnz_Lowell_10Feb.CSV.
  
  
  
ERROR: Import unsuccessful.  See SAS Log for details.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           6.12 seconds
      user cpu time       5.25 seconds
      system cpu time     0.35 seconds
      memory              9411.96k
      OS Memory           37992.00k
14                                                         The SAS System                              10:29 Tuesday, April 11, 2023

      Timestamp           04/11/2023 01:12:05 PM
      Step Count                        15  Switch Count  11
      
267        
268        %LET _CLIENTTASKLABEL=;
269        %LET _CLIENTPROCESSFLOWNAME=;
270        %LET _CLIENTPROJECTPATH=;
271        %LET _CLIENTPROJECTPATHHOST=;
272        %LET _CLIENTPROJECTNAME=;
273        %LET _SASPROGRAMFILE=;
274        %LET _SASPROGRAMFILEHOST=;
275        
276        ;*';*";*/;quit;run;
277        ODS _ALL_ CLOSE;
278        
279        
280        QUIT; RUN;
281

PaigeMiller · Posted 04-11-2023 08:36 AM

NOTE: Invalid data for TA_TEL_NUM_1 in line 40 280-290.
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
40        39,10052229,Yes,,TEL9,Asct Trace No data,Verbal New – 2 Ver,BETHSHEAN CRAIGO,,MONTROSE,ANGUS,DD109LD
     101  ,1700,Movement,,,0,0,NO,No,Strong,0,0,0,0,No,0,99,No delete records,No,,No searches ever,No searches
     201   ever,Associate,1,3,Some,No,0,0,0,0,No,0,No load records,No delete records,Yes,***********,No search

TA_TEL_NUM_1 is defined as numeric. The data on row 40 has TA_TEL_NUM_1 as *********** which is not numeric. Since it appears to be a telephone number, there's really no reason to have it as numeric. Thus, you either need to define TA_TEL_NUM_1 as character (or leave it as numeric and create an informat that will handle the asterisks).

The suggestion by @Ksharp may be a good solution.

--
Paige Miller

Tom · Posted 04-11-2023 08:41 AM

This is the problem caused by using PROC IMPORT without telling it how many rows to check. I think the default is only 20 rows. So it never looked at the stars in row 40, if it had then PROC IMPORT would have guessed to make that variable as character.

If you have to use PROC IMPORT than I would suggest always using including the GUESSINGROWS=MAX; statement so that it will read the whole file before finalizing its guesses about how to read the variables.

ballardw · Posted 04-11-2023 11:29 AM

Please note that this is not an ERROR. Errors will stop the data step generated by proc import from running. It is a note about data invalid for a specific variable.

A quick "how to read" one of the messages:

NOTE: Invalid data for TA_TEL_NUM_1 in line 40 280-290.

This tells you the source line in the file read, Line 40. So if needed you can go to the CSV and examine it. Caution: CSV opened by spreadsheet software may alter appearance of some values and if saved from there alter the data. Also if the Guessingrows option had been set to a minimum of 40, for this file, the ******* would have been considered for setting the variable type.

RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
40        39,10052229,Yes,,TEL9,Asct Trace No data,Verbal New – 2 Ver,BETHSHEAN CRAIGO,,MONTROSE,ANGUS,DD109LD
     101  ,1700,Movement,,,0,0,NO,No,Strong,0,0,0,0,No,0,99,No delete records,No,,No searches ever,No searches
     201   ever,Associate,1,3,Some,No,0,0,0,0,No,0,No load records,No delete records,Yes,***********,No search
     301  es ever,No searches ever,2,0,Last link in a chain,06042022,68070017907,,,,,,274,Associate,"MR,MARK J
     401  AMES, ,HOLLOWAY",09071968,", ,",", ,",", ,",NO,NO,+0176,0,0.5 461

The RULE line is a ruler so you can find the specific columns involved. the + indicate columns 5, 15, 25 etc. The 1, 2, 3 are columns 10, 20, 30 . the 0 is column 100. The line wraps if long enough and the 101, 201 etc. Indicate the column start position of that portion of the line read.

So when you have the invalid data at column 280, you start in the line that that has 201 on the left margin and go across to the column under the 8 in the ruler to find column 280. So you can see the ******** encountered.

Compare the informat assigned for that variable:

94                informat TA_TEL_NUM_1 best32. ;

The informat is best32. or a generic numeric informat that will accept all sorts of simple numeric values.

This sort of thing, "invalid data" is common from depending on how well your source data is documented. Someone may have a document that says something like "missing values for this field will appear as ********** " (or some other character) Telephone numbers may often be 9999999999 or 0000000000 but I have seen 9990000000 0009999999 as well. Other data sources are likely to have "numeric" fields that are mostly okay but then throw in something like <0.1 or NA or UNK. So sometimes you are best off to create custom informats that will handle those special cases to provide a desired numeric result and prevent invalid data messages.

I have a few data sources where I have custom informats to read site id values because they keep adding such and the custom informat throws this invalid data message so i can question the source about the other metadata that I need to process the data.

Ksharp · Posted 04-11-2023 08:25 AM

Try add GUESSINGROWS= option:

Proc import
datafile='\\lowell2.local\shares\Public\Trace\Trace Integrity Analyst Data\BAU_Processes\SAS\Enhanced TPT\Storage\Monthly Washes\Trace_2023_02_10\elnz_Lowell_10Feb.CSV'
out=Feb_release
dbms=csv
replace;
guessingrows=max ;
run;

Sandeep77 · Posted 04-11-2023 09:55 AM

Thank you!

Importing a csv file using the proc import code

Re: Importing a csv file using the proc import code

Re: Importing a csv file using the proc import code

Re: Importing a csv file using the proc import code

Re: Importing a csv file using the proc import code

Re: Importing a csv file using the proc import code

Re: Importing a csv file using the proc import code

Re: Importing a csv file using the proc import code

Re: Importing a csv file using the proc import code

Special offer for SAS Communities members