Import very big CSV file-error

[Ronein]

Hello

I am running proc import code to import CSV file that contain 15 million rows.

First I run code to import first 5 observations in order to see that it is done successfully .

The 5 observations were imported successfully.

options obs=5;
proc import
datafile="/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/BLL_ISK2.csv"
out=want2
dbms=CSV
replace;
delimiter=';';
GETNAMES=YES;
run;
options obs=max;

Then I wanted to import the whole file that contain 150 million rows.

proc import
datafile="/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/BLL_ISK2.csv"
out=Kelet2
dbms=CSV
replace;
delimiter=';';
GETNAMES=YES;
run;

Here is the error in log file

My question- What is the error? What should I do to repair it?

1                                                          The SAS System                               08:37 Sunday, April 30, 2023

1          ;*';*";*/;quit;run;
2          OPTIONS PAGENO=MIN;
3          %LET _CLIENTTASKLABEL='IMPORT_2_Big_Files';
4          %LET _CLIENTPROCESSFLOWNAME='Process Flow';
5          %LET _CLIENTPROJECTPATH='';
6          %LET _CLIENTPROJECTPATHHOST='';
7          %LET _CLIENTPROJECTNAME='';
8          %LET _SASPROGRAMFILE='K:\Reports\הד הוק לשמוליק\LightSolver\שליפת שני קבצים גדולים\IMPORT_2_Big_Files.sas';
9          %LET _SASPROGRAMFILEHOST='VSK2H010A3091';
10         
11         ODS _ALL_ CLOSE;
12         OPTIONS DEV=PNG;
13         GOPTIONS XPIXELS=0 YPIXELS=0;
14         FILENAME EGSR TEMP;
15         ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR
16             STYLE=HTMLBlue
17             STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HTMLBlue.css")
18             NOGTITLE
19             NOGFOOTNOTE
20             GPATH=&sasworklocation
21             ENCODING=UTF8
22             options(rolap="on")
23         ;
NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
24         
25         GOPTIONS ACCESSIBLE;
26         proc import
27         datafile="/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/BLL_ISK2.csv"
28         out=Kelet2
29         dbms=CSV
30         replace;
31         delimiter=';';
32         GETNAMES=YES;
33         run;

34          /**********************************************************************
35          *   PRODUCT:   SAS
36          *   VERSION:   9.4
37          *   CREATOR:   External File Interface
38          *   DATE:      30APR23
39          *   DESC:      Generated SAS Datastep Code
40          *   TEMPLATE SOURCE:  (None Specified.)
41          ***********************************************************************/
42             data WORK.KELET2    ;
43             %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
44             infile '/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/BLL_ISK2.csv' delimiter = ';' MISSOVER DSD lrecl=32767
44       ! firstobs=2 ;
45                informat MEZAHE_TNUA best32. ;
46                informat SNIF best32. ;
47                informat CHESHBON best32. ;
48                informat LAKOAH best32. ;
49                informat MLI_TEUR_SUG_CARD $8. ;
50                informat MEZAHE_CARD best32. ;
51                informat MEZAHE_PART best32. ;
52                informat MLI_TA_HITZTARFUT anydtdtm40. ;
53                informat KOD_CHEVRA best32. ;
54                informat TEUR_CARD $9. ;
55                informat KOD_CHEVRA_GLOBAL best32. ;
2                                                          The SAS System                               08:37 Sunday, April 30, 2023

56                informat CHEVRA $3. ;
57                informat SHEM_SOCHER $30. ;
58                informat MIS_SOCHER best32. ;
59                informat MCC4 best32. ;
60                informat SHEM_MCC4 $28. ;
61                informat COMPANY_LEGAL_ID best32. ;
62                informat SUG_ISKA best32. ;
63                informat TEURSUG_ISKA $15. ;
64                informat TAARICH_BITZUA_ISKA anydtdtm40. ;
65                informat BITZUA_ISKA_TIME $1. ;
66                informat TAARICH_IBUD_ISKA anydtdtm40. ;
67                informat TAARICH_CHIUV anydtdtm40. ;
68                informat SCHUM_CHIUV best32. ;
69                informat MIS_TASH_NOCH best32. ;
70                informat MATBEA_CHIUV $3. ;
71                informat MIS_TASH_MEK best32. ;
72                informat MIS_TASH_NOTRU best32. ;
73                informat SCHUM_ISKA_MAT_MAKOR best32. ;
74                informat MATBEA_BITZUA_ISKA $3. ;
75                informat ACHUZ_RIBIT best32. ;
76                informat IND_ISKAT_CHUL best32. ;
77                informat SCHUM_ISKA_MAT_CHUV best32. ;
78                informat IND_HOCK best32. ;
79                informat KOD_SOLECK best32. ;
80                informat IND_ISKA_BERUR best32. ;
81                informat IND_ISKA_MISMACH_CHASER best32. ;
82                informat IND_ISKA_MEULETZET best32. ;
83                informat IND_HALVAA best32. ;
84                informat SUG_PLAN best32. ;
85                informat TEUR_SUG_TOCHNIT $5. ;
86                informat MAHUT_KARTIS $1. ;
87                informat RIBIT_NOTAR best32. ;
88                informat **bleep**AT_PERAON best32. ;
89                informat SUG_RIBIT best32. ;
90                informat SHIUR_RIBIT best32. ;
91                informat MIRVACH_PRIME best32. ;
92                informat CALC_TRCH anydtdtm40. ;
93                informat COUNTRY_CODE $1. ;
94                format MEZAHE_TNUA best12. ;
95                format SNIF best12. ;
96                format CHESHBON best12. ;
97                format LAKOAH best12. ;
98                format MLI_TEUR_SUG_CARD $8. ;
99                format MEZAHE_CARD best12. ;
100               format MEZAHE_PART best12. ;
101               format MLI_TA_HITZTARFUT datetime. ;
102               format KOD_CHEVRA best12. ;
103               format TEUR_CARD $9. ;
104               format KOD_CHEVRA_GLOBAL best12. ;
105               format CHEVRA $3. ;
106               format SHEM_SOCHER $30. ;
107               format MIS_SOCHER best12. ;
108               format MCC4 best12. ;
109               format SHEM_MCC4 $28. ;
110               format COMPANY_LEGAL_ID best12. ;
111               format SUG_ISKA best12. ;
112               format TEURSUG_ISKA $15. ;
113               format TAARICH_BITZUA_ISKA datetime. ;
3                                                          The SAS System                               08:37 Sunday, April 30, 2023

114               format BITZUA_ISKA_TIME $1. ;
115               format TAARICH_IBUD_ISKA datetime. ;
116               format TAARICH_CHIUV datetime. ;
117               format SCHUM_CHIUV best12. ;
118               format MIS_TASH_NOCH best12. ;
119               format MATBEA_CHIUV $3. ;
120               format MIS_TASH_MEK best12. ;
121               format MIS_TASH_NOTRU best12. ;
122               format SCHUM_ISKA_MAT_MAKOR best12. ;
123               format MATBEA_BITZUA_ISKA $3. ;
124               format ACHUZ_RIBIT best12. ;
125               format IND_ISKAT_CHUL best12. ;
126               format SCHUM_ISKA_MAT_CHUV best12. ;
127               format IND_HOCK best12. ;
128               format KOD_SOLECK best12. ;
129               format IND_ISKA_BERUR best12. ;
130               format IND_ISKA_MISMACH_CHASER best12. ;
131               format IND_ISKA_MEULETZET best12. ;
132               format IND_HALVAA best12. ;
133               format SUG_PLAN best12. ;
134               format TEUR_SUG_TOCHNIT $5. ;
135               format MAHUT_KARTIS $1. ;
136               format RIBIT_NOTAR best12. ;
137               format **bleep**AT_PERAON best12. ;
138               format SUG_RIBIT best12. ;
139               format SHIUR_RIBIT best12. ;
140               format MIRVACH_PRIME best12. ;
141               format CALC_TRCH datetime. ;
142               format COUNTRY_CODE $1. ;
143            input
144                        MEZAHE_TNUA
145                        SNIF
146                        CHESHBON
147                        LAKOAH
148                        MLI_TEUR_SUG_CARD $
149                        MEZAHE_CARD
150                        MEZAHE_PART
151                        MLI_TA_HITZTARFUT
152                        KOD_CHEVRA
153                        TEUR_CARD $
154                        KOD_CHEVRA_GLOBAL
155                        CHEVRA $
156                        SHEM_SOCHER $
157                        MIS_SOCHER
158                        MCC4
159                        SHEM_MCC4 $
160                        COMPANY_LEGAL_ID
161                        SUG_ISKA
162                        TEURSUG_ISKA $
163                        TAARICH_BITZUA_ISKA
164                        BITZUA_ISKA_TIME $
165                        TAARICH_IBUD_ISKA
166                        TAARICH_CHIUV
167                        SCHUM_CHIUV
168                        MIS_TASH_NOCH
169                        MATBEA_CHIUV $
170                        MIS_TASH_MEK
171                        MIS_TASH_NOTRU
4                                                          The SAS System                               08:37 Sunday, April 30, 2023

172                        SCHUM_ISKA_MAT_MAKOR
173                        MATBEA_BITZUA_ISKA $
174                        ACHUZ_RIBIT
175                        IND_ISKAT_CHUL
176                        SCHUM_ISKA_MAT_CHUV
177                        IND_HOCK
178                        KOD_SOLECK
179                        IND_ISKA_BERUR
180                        IND_ISKA_MISMACH_CHASER
181                        IND_ISKA_MEULETZET
182                        IND_HALVAA
183                        SUG_PLAN
184                        TEUR_SUG_TOCHNIT $
185                        MAHUT_KARTIS $
186                        RIBIT_NOTAR
187                        **bleep**AT_PERAON
188                        SUG_RIBIT
189                        SHIUR_RIBIT
190                        MIRVACH_PRIME
191                        CALC_TRCH
192                        COUNTRY_CODE $
193            ;
194            if _ERROR_ then call symputx('_EFIERR_',1);  /* set ERROR detection macro variable */
195            run;

NOTE: The infile '/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/BLL_ISK2.csv' is:
      Filename=/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/BLL_ISK2.csv,
      Owner Name=UDKSAS1,
      Group Name=GR_IL_SAS_USERS_LabRet,
      Access Permission=-rw-r--r--,
      Last Modified=27Apr2023:11:40:25,
      File Size (bytes)=55022121819

NOTE: Invalid data for MEZAHE_TNUA in line 129 1-48.
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
129       74403030337030001258215 T20337003006613000000100;954;1778796;1778716;דביט;00536642644580475948;5948;
     101  2020-03-08 00:00:00;4;ויזה;4;MAX;אלונית  חריש;1532139;5411;מכולות וסופרמרקטים;512869439;111;עסקה רגי
     201  לה;2020-12-01 00:00:00;        ;2020-12-03 00:00:00;2020-12-02 00:00:00;63.40;0;ILS;0;0;63.40;ILS;.0
     301  00;0;63.40;0;1;0;0;2;0;2000;חיוב עסקות מיידי              ;0;.00;0;0;.000;.000;2020-12-02 00:00:00; 
     401      403
MEZAHE_TNUA=. SNIF=954 CHESHBON=1778796 LAKOAH=1778716 MLI_TEUR_SUG_CARD=דביט MEZAHE_CARD=5.3664264E17 MEZAHE_PART=5948
MLI_TA_HITZTARFUT=08MAR20:00:00:00 KOD_CHEVRA=4 TEUR_CARD=ויזה KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=אלונית  חריש
MIS_SOCHER=1532139 MCC4=5411 SHEM_MCC4=מכולות וסופרמרקטים COMPANY_LEGAL_ID=512869439 SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה
TAARICH_BITZUA_ISKA=01DEC20:00:00:00 BITZUA_ISKA_TIME=  TAARICH_IBUD_ISKA=03DEC20:00:00:00 TAARICH_CHIUV=02DEC20:00:00:00
SCHUM_CHIUV=63.4 MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=63.4 MATBEA_BITZUA_ISKA=ILS
ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=63.4 IND_HOCK=0 KOD_SOLECK=1 IND_ISKA_BERUR=0 IND_ISKA_MISMACH_CHASER=0
IND_ISKA_MEULETZET=2 IND_HALVAA=0 SUG_PLAN=2000 TEUR_SUG_TOCHNIT=חיוב MAHUT_KARTIS=0 RIBIT_NOTAR=0 **bleep**AT_PERAON=0 SUG_RIBIT=0
SHIUR_RIBIT=0 MIRVACH_PRIME=0 CALC_TRCH=02DEC20:00:00:00 COUNTRY_CODE=  _ERROR_=1 _N_=128
NOTE: Invalid data for MEZAHE_TNUA in line 172 1-48.
172       74580000341187879745301VT20343002400001039355400;678;12360907;12360927;זהב;00222463834580128124;8124
     101  ;2005-11-13 00:00:00;4;ויזה;4;MAX;אלונית-גבים;5603599;5411;מכולות וסופרמרקטים;512869439;111;עסקה רגי
     201  לה;2020-12-03 00:00:00;        ;2020-12-06 00:00:00;2020-12-10 00:00:00;37.64;0;ILS;0;0;37.64;ILS;.0
     301  00;0;37.64;0;2;0;0;1;0;1000;רגילה                         ;0;.00;0;0;.000;.000;2020-12-10 00:00:00; 
     401      403
MEZAHE_TNUA=. SNIF=678 CHESHBON=12360907 LAKOAH=12360927 MLI_TEUR_SUG_CARD=זהב MEZAHE_CARD=2.2246383E17 MEZAHE_PART=8124
MLI_TA_HITZTARFUT=13NOV05:00:00:00 KOD_CHEVRA=4 TEUR_CARD=ויזה KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=אלונית-גבים
MIS_SOCHER=5603599 MCC4=5411 SHEM_MCC4=מכולות וסופרמרקטים COMPANY_LEGAL_ID=512869439 SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה
TAARICH_BITZUA_ISKA=03DEC20:00:00:00 BITZUA_ISKA_TIME=  TAARICH_IBUD_ISKA=06DEC20:00:00:00 TAARICH_CHIUV=10DEC20:00:00:00
5                                                          The SAS System                               08:37 Sunday, April 30, 2023

SCHUM_CHIUV=37.64 MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=37.64 MATBEA_BITZUA_ISKA=ILS
ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=37.64 IND_HOCK=0 KOD_SOLECK=2 IND_ISKA_BERUR=0 IND_ISKA_MISMACH_CHASER=0
IND_ISKA_MEULETZET=1 IND_HALVAA=0 SUG_PLAN=1000 TEUR_SUG_TOCHNIT=רגילה MAHUT_KARTIS=0 RIBIT_NOTAR=0 **bleep**AT_PERAON=0 SUG_RIBIT=0
SHIUR_RIBIT=0 MIRVACH_PRIME=0 CALC_TRCH=10DEC20:00:00:00 COUNTRY_CODE=  _ERROR_=1 _N_=171
NOTE: Invalid data for MEZAHE_TNUA in line 173 1-48.
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
173       VT2034300240000105335861202034500009003027494001;678;12360907;12360927;זהב;00222463834580128124;8124
     101  ;2005-11-13 00:00:00;4;ויזה;4;MAX;WE SHOSE;8457225;5661;חנויות נעליים;510963580;666;תשלומים על חשבון
     201   בית העסק;2020-12-05 00:00:00;        ;2020-12-07 00:00:00;2020-12-10 00:00:00;235.96;1;ILS;2;1;471.
     301  92;ILS;.000;0;235.96;0;2;0;0;1;0;13012;תשלומים                       ;0;.00;0;0;.000;.000;2020-12-10
     401   00:00:00;     414
MEZAHE_TNUA=. SNIF=678 CHESHBON=12360907 LAKOAH=12360927 MLI_TEUR_SUG_CARD=זהב MEZAHE_CARD=2.2246383E17 MEZAHE_PART=8124
MLI_TA_HITZTARFUT=13NOV05:00:00:00 KOD_CHEVRA=4 TEUR_CARD=ויזה KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=WE SHOSE
MIS_SOCHER=8457225 MCC4=5661 SHEM_MCC4=חנויות נעליים COMPANY_LEGAL_ID=510963580 SUG_ISKA=666 TEURSUG_ISKA=תשלומים על חשבו
TAARICH_BITZUA_ISKA=05DEC20:00:00:00 BITZUA_ISKA_TIME=  TAARICH_IBUD_ISKA=07DEC20:00:00:00 TAARICH_CHIUV=10DEC20:00:00:00
SCHUM_CHIUV=235.96 MIS_TASH_NOCH=1 MATBEA_CHIUV=ILS MIS_TASH_MEK=2 MIS_TASH_NOTRU=1 SCHUM_ISKA_MAT_MAKOR=471.92
MATBEA_BITZUA_ISKA=ILS ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=235.96 IND_HOCK=0 KOD_SOLECK=2 IND_ISKA_BERUR=0
IND_ISKA_MISMACH_CHASER=0 IND_ISKA_MEULETZET=1 IND_HALVAA=0 SUG_PLAN=13012 TEUR_SUG_TOCHNIT=תשלומ MAHUT_KARTIS=0 RIBIT_NOTAR=0
**bleep**AT_PERAON=0 SUG_RIBIT=0 SHIUR_RIBIT=0 MIRVACH_PRIME=0 CALC_TRCH=10DEC20:00:00:00 COUNTRY_CODE=  _ERROR_=1 _N_=172
NOTE: Invalid data for MEZAHE_TNUA in line 174 1-48.
174       05326100341000813642149MT20342003000001030891400;811;52314193;52314113;פלטינה;00221829275521767910;7
     101  910;2016-05-31 00:00:00;5;מאסטרקארד;4;MAX;כל בו חצי חינם ראשלצ;1196757;5411;מכולות וסופרמרקטים;51218
     201  0886;111;עסקה רגילה;2020-12-04 00:00:00;        ;2020-12-06 00:00:00;2020-12-10 00:00:00;200.60;0;IL
     301  S;0;0;200.60;ILS;.000;0;200.60;0;3;0;0;1;0;1000;רגילה                         ;R;.00;0;0;.000;.000;2
     401  020-12-10 00:00:00;     423
MEZAHE_TNUA=. SNIF=811 CHESHBON=52314193 LAKOAH=52314113 MLI_TEUR_SUG_CARD=פלטינה MEZAHE_CARD=2.2182928E17 MEZAHE_PART=7910
MLI_TA_HITZTARFUT=31MAY16:00:00:00 KOD_CHEVRA=5 TEUR_CARD=מאסטרקארד KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=כל בו חצי חינם ראשלצ
MIS_SOCHER=1196757 MCC4=5411 SHEM_MCC4=מכולות וסופרמרקטים COMPANY_LEGAL_ID=512180886 SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה
TAARICH_BITZUA_ISKA=04DEC20:00:00:00 BITZUA_ISKA_TIME=  TAARICH_IBUD_ISKA=06DEC20:00:00:00 TAARICH_CHIUV=10DEC20:00:00:00
SCHUM_CHIUV=200.6 MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=200.6 MATBEA_BITZUA_ISKA=ILS
ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=200.6 IND_HOCK=0 KOD_SOLECK=3 IND_ISKA_BERUR=0 IND_ISKA_MISMACH_CHASER=0
IND_ISKA_MEULETZET=1 IND_HALVAA=0 SUG_PLAN=1000 TEUR_SUG_TOCHNIT=רגילה MAHUT_KARTIS=R RIBIT_NOTAR=0 **bleep**AT_PERAON=0 SUG_RIBIT=0
SHIUR_RIBIT=0 MIRVACH_PRIME=0 CALC_TRCH=10DEC20:00:00:00 COUNTRY_CODE=  _ERROR_=1 _N_=173
NOTE: Invalid data for MEZAHE_TNUA in line 175 1-48.
175       05326100341000818599492MT20342003000001039676200;811;52314193;52314113;פלטינה;00221829275521767910;7
     101  910;2016-05-31 00:00:00;5;מאסטרקארד;4;MAX;ברכה משולשת - מערב ראשל"צ;8082687;5451;חנויות למוצרי חלב;5
     201  14478502;111;עסקה רגילה;2020-12-04 00:00:00;        ;2020-12-06 00:00:00;2020-12-10 00:00:00;263.48;
     301  0;ILS;0;0;263.48;ILS;.000;0;263.48;0;3;0;0;1;0;1000;רגילה                         ;R;.00;0;0;.000;.0
     401  00;2020-12-10 00:00:00;     427
MEZAHE_TNUA=. SNIF=811 CHESHBON=52314193 LAKOAH=52314113 MLI_TEUR_SUG_CARD=פלטינה MEZAHE_CARD=2.2182928E17 MEZAHE_PART=7910
MLI_TA_HITZTARFUT=31MAY16:00:00:00 KOD_CHEVRA=5 TEUR_CARD=מאסטרקארד KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX
SHEM_SOCHER=ברכה משולשת - מערב ראשל"צ MIS_SOCHER=8082687 MCC4=5451 SHEM_MCC4=חנויות למוצרי חלב COMPANY_LEGAL_ID=514478502
SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה TAARICH_BITZUA_ISKA=04DEC20:00:00:00 BITZUA_ISKA_TIME=  TAARICH_IBUD_ISKA=06DEC20:00:00:00
TAARICH_CHIUV=10DEC20:00:00:00 SCHUM_CHIUV=263.48 MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0
SCHUM_ISKA_MAT_MAKOR=263.48 MATBEA_BITZUA_ISKA=ILS ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=263.48 IND_HOCK=0 KOD_SOLECK=3
IND_ISKA_BERUR=0 IND_ISKA_MISMACH_CHASER=0 IND_ISKA_MEULETZET=1 IND_HALVAA=0 SUG_PLAN=1000 TEUR_SUG_TOCHNIT=רגילה MAHUT_KARTIS=R
RIBIT_NOTAR=0 **bleep**AT_PERAON=0 SUG_RIBIT=0 SHIUR_RIBIT=0 MIRVACH_PRIME=0 CALC_TRCH=10DEC20:00:00:00 COUNTRY_CODE=  _ERROR_=1 _N_=174
NOTE: Invalid data for MEZAHE_TNUA in line 176 1-48.
176       05326100338000760704038MT20339002500001025416600;891;5022547;5022567;בינלאומי;00221971645189543546;3
     101  546;2011-02-17 00:00:00;5;מאסטרקארד;4;MAX;פז YELLOW חוף -;2130029;5541;תחנות שירות לרכב;510216054;11
     201  1;עסקה רגילה;2020-12-02 00:00:00;        ;2020-12-04 00:00:00;2020-12-10 00:00:00;85.00;0;ILS;0;0;85
     301  .00;ILS;.000;0;85.00;0;3;0;0;1;0;1000;רגילה                         ;R;.00;0;0;.000;.000;2020-12-10 
     401  00:00:00;     413
MEZAHE_TNUA=. SNIF=891 CHESHBON=5022547 LAKOAH=5022567 MLI_TEUR_SUG_CARD=בינלאומי MEZAHE_CARD=2.2197165E17 MEZAHE_PART=3546
MLI_TA_HITZTARFUT=17FEB11:00:00:00 KOD_CHEVRA=5 TEUR_CARD=מאסטרקארד KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=פז YELLOW חוף -
MIS_SOCHER=2130029 MCC4=5541 SHEM_MCC4=תחנות שירות לרכב COMPANY_LEGAL_ID=510216054 SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה
TAARICH_BITZUA_ISKA=02DEC20:00:00:00 BITZUA_ISKA_TIME=  TAARICH_IBUD_ISKA=04DEC20:00:00:00 TAARICH_CHIUV=10DEC20:00:00:00
SCHUM_CHIUV=85 MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=85 MATBEA_BITZUA_ISKA=ILS
6                                                          The SAS System                               08:37 Sunday, April 30, 2023

ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=85 IND_HOCK=0 KOD_SOLECK=3 IND_ISKA_BERUR=0 IND_ISKA_MISMACH_CHASER=0
IND_ISKA_MEULETZET=1 IND_HALVAA=0 SUG_PLAN=1000 TEUR_SUG_TOCHNIT=רגילה MAHUT_KARTIS=R RIBIT_NOTAR=0 **bleep**AT_PERAON=0 SUG_RIBIT=0
SHIUR_RIBIT=0 MIRVACH_PRIME=0 CALC_TRCH=10DEC20:00:00:00 COUNTRY_CODE=  _ERROR_=1 _N_=175
NOTE: Invalid data for MEZAHE_TNUA in line 177 1-48.
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
177       05326100337000743669762MT20338003200001034547400;851;36531824;36531844;פלטינה;00222360535521761612;1
     101  612;2007-07-01 00:00:00;5;מאסטרקארד;4;MAX;OUIK סופר אונליין-גמא;9097627;5411;מכולות וסופרמרקטים;5127
     201  11789;111;עסקה רגילה;2020-12-01 00:00:00;        ;2020-12-03 00:00:00;2020-12-10 00:00:00;427.49;0;I
     301  LS;0;0;427.49;ILS;.000;0;427.49;0;3;0;1;1;0;1000;רגילה                         ;R;.00;0;0;.000;.000;
     401  2020-12-10 00:00:00;     424
MEZAHE_TNUA=. SNIF=851 CHESHBON=36531824 LAKOAH=36531844 MLI_TEUR_SUG_CARD=פלטינה MEZAHE_CARD=2.2236054E17 MEZAHE_PART=1612
MLI_TA_HITZTARFUT=01JUL07:00:00:00 KOD_CHEVRA=5 TEUR_CARD=מאסטרקארד KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=OUIK סופר אונליין-גמא
MIS_SOCHER=9097627 MCC4=5411 SHEM_MCC4=מכולות וסופרמרקטים COMPANY_LEGAL_ID=512711789 SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה
TAARICH_BITZUA_ISKA=01DEC20:00:00:00 BITZUA_ISKA_TIME=  TAARICH_IBUD_ISKA=03DEC20:00:00:00 TAARICH_CHIUV=10DEC20:00:00:00
SCHUM_CHIUV=427.49 MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=427.49
MATBEA_BITZUA_ISKA=ILS ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=427.49 IND_HOCK=0 KOD_SOLECK=3 IND_ISKA_BERUR=0
IND_ISKA_MISMACH_CHASER=1 IND_ISKA_MEULETZET=1 IND_HALVAA=0 SUG_PLAN=1000 TEUR_SUG_TOCHNIT=רגילה MAHUT_KARTIS=R RIBIT_NOTAR=0
**bleep**AT_PERAON=0 SUG_RIBIT=0 SHIUR_RIBIT=0 MIRVACH_PRIME=0 CALC_TRCH=10DEC20:00:00:00 COUNTRY_CODE=  _ERROR_=1 _N_=176
NOTE: Invalid data for MEZAHE_TNUA in line 178 1-48.
178       05326100337000743668913MT20338003200001034542300;851;36531824;36531844;פלטינה;00222360535521761612;1
     101  612;2007-07-01 00:00:00;5;מאסטרקארד;4;MAX;OUIK סופר אונליין-גמא;9097627;5411;מכולות וסופרמרקטים;5127
     201  11789;111;עסקה רגילה;2020-12-01 00:00:00;        ;2020-12-03 00:00:00;2020-12-10 00:00:00;-20.00;0;I
     301  LS;0;0;-20.00;ILS;.000;0;-20.00;0;3;0;1;3;0;1000;רגילה                         ;R;.00;0;0;.000;.000;
     401  2020-12-10 00:00:00;     424
MEZAHE_TNUA=. SNIF=851 CHESHBON=36531824 LAKOAH=36531844 MLI_TEUR_SUG_CARD=פלטינה MEZAHE_CARD=2.2236054E17 MEZAHE_PART=1612
MLI_TA_HITZTARFUT=01JUL07:00:00:00 KOD_CHEVRA=5 TEUR_CARD=מאסטרקארד KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=OUIK סופר אונליין-גמא
MIS_SOCHER=9097627 MCC4=5411 SHEM_MCC4=מכולות וסופרמרקטים COMPANY_LEGAL_ID=512711789 SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה
TAARICH_BITZUA_ISKA=01DEC20:00:00:00 BITZUA_ISKA_TIME=  TAARICH_IBUD_ISKA=03DEC20:00:00:00 TAARICH_CHIUV=10DEC20:00:00:00
SCHUM_CHIUV=-20 MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=-20 MATBEA_BITZUA_ISKA=ILS
ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=-20 IND_HOCK=0 KOD_SOLECK=3 IND_ISKA_BERUR=0 IND_ISKA_MISMACH_CHASER=1
IND_ISKA_MEULETZET=3 IND_HALVAA=0 SUG_PLAN=1000 TEUR_SUG_TOCHNIT=רגילה MAHUT_KARTIS=R RIBIT_NOTAR=0 **bleep**AT_PERAON=0 SUG_RIBIT=0
SHIUR_RIBIT=0 MIRVACH_PRIME=0 CALC_TRCH=10DEC20:00:00:00 COUNTRY_CODE=  _ERROR_=1 _N_=177
NOTE: Invalid data for MEZAHE_TNUA in line 179 1-48.
179       05326100341000813858570MT20342003000001031656100;851;36531824;36531844;פלטינה;00222360535521761612;1
     101  612;2007-07-01 00:00:00;5;מאסטרקארד;4;MAX;חברת פרטנר תקשורת בע"מ;1811686;4814;שרותי תקשורת כולל שיחו
     201  ת רגילות בכרטיסי א;520044314;111;עסקה רגילה;2020-12-06 00:00:00;        ;2020-12-08 00:00:00;2020-12
     301  -10 00:00:00;74.52;0;ILS;0;0;74.52;ILS;.000;0;74.52;2;3;0;1;1;0;1000;רגילה                         ;
     401  R;.00;0;0;.000;.000;2020-12-10 00:00:00;     444
MEZAHE_TNUA=. SNIF=851 CHESHBON=36531824 LAKOAH=36531844 MLI_TEUR_SUG_CARD=פלטינה MEZAHE_CARD=2.2236054E17 MEZAHE_PART=1612
MLI_TA_HITZTARFUT=01JUL07:00:00:00 KOD_CHEVRA=5 TEUR_CARD=מאסטרקארד KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX
SHEM_SOCHER=חברת פרטנר תקשורת בע"מ MIS_SOCHER=1811686 MCC4=4814 SHEM_MCC4=שרותי תקשורת כולל שיחות רגיל COMPANY_LEGAL_ID=520044314
SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה TAARICH_BITZUA_ISKA=06DEC20:00:00:00 BITZUA_ISKA_TIME=  TAARICH_IBUD_ISKA=08DEC20:00:00:00
TAARICH_CHIUV=10DEC20:00:00:00 SCHUM_CHIUV=74.52 MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0
SCHUM_ISKA_MAT_MAKOR=74.52 MATBEA_BITZUA_ISKA=ILS ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=74.52 IND_HOCK=2 KOD_SOLECK=3
IND_ISKA_BERUR=0 IND_ISKA_MISMACH_CHASER=1 IND_ISKA_MEULETZET=1 IND_HALVAA=0 SUG_PLAN=1000 TEUR_SUG_TOCHNIT=רגילה MAHUT_KARTIS=R
RIBIT_NOTAR=0 **bleep**AT_PERAON=0 SUG_RIBIT=0 SHIUR_RIBIT=0 MIRVACH_PRIME=0 CALC_TRCH=10DEC20:00:00:00 COUNTRY_CODE=  _ERROR_=1 _N_=178
NOTE: Invalid data for MEZAHE_TNUA in line 180 1-48.
180       04557430337000735460877VT20338003200001001062000;734;3087070;3087090;פלטינה;00222345204580112018;201
     101  8;2012-04-22 00:00:00;4;ויזה;4;MAX;בשירי מרדכי ובניו בעמ;7552151;5211;חנויות חומרי בנין ועץ;;111;עסק
     201  ה רגילה;2020-12-01 00:00:00;        ;2020-12-03 00:00:00;2020-12-10 00:00:00;50.00;0;ILS;0;0;50.00;I
     301  LS;.000;0;50.00;0;8;0;1;1;0;1000;רגילה                         ;0;.00;0;0;.000;.000;2020-12-10 00:00
     401  :00;     408
MEZAHE_TNUA=. SNIF=734 CHESHBON=3087070 LAKOAH=3087090 MLI_TEUR_SUG_CARD=פלטינה MEZAHE_CARD=2.223452E17 MEZAHE_PART=2018
MLI_TA_HITZTARFUT=22APR12:00:00:00 KOD_CHEVRA=4 TEUR_CARD=ויזה KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=בשירי מרדכי ובניו בעמ
MIS_SOCHER=7552151 MCC4=5211 SHEM_MCC4=חנויות חומרי בנין ועץ COMPANY_LEGAL_ID=. SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה
TAARICH_BITZUA_ISKA=01DEC20:00:00:00 BITZUA_ISKA_TIME=  TAARICH_IBUD_ISKA=03DEC20:00:00:00 TAARICH_CHIUV=10DEC20:00:00:00
SCHUM_CHIUV=50 MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=50 MATBEA_BITZUA_ISKA=ILS
ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=50 IND_HOCK=0 KOD_SOLECK=8 IND_ISKA_BERUR=0 IND_ISKA_MISMACH_CHASER=1
7                                                          The SAS System                               08:37 Sunday, April 30, 2023

IND_ISKA_MEULETZET=1 IND_HALVAA=0 SUG_PLAN=1000 TEUR_SUG_TOCHNIT=רגילה MAHUT_KARTIS=0 RIBIT_NOTAR=0 **bleep**AT_PERAON=0 SUG_RIBIT=0
SHIUR_RIBIT=0 MIRVACH_PRIME=0 CALC_TRCH=10DEC20:00:00:00 COUNTRY_CODE=  _ERROR_=1 _N_=179
NOTE: Invalid data for MEZAHE_TNUA in line 181 1-48.
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
181       74580000338187785681397VT20341003900001043068400;705;12933663;12933683;עסקי זהב;00222649644580100590
     101  ;0590;2015-06-19 00:00:00;4;ויזה;4;MAX;שופרסל דיל קרית מוצקין;369014;5411;מכולות וסופרמרקטים;5200227
     201  32;111;עסקה רגילה;2020-12-02 00:00:00;        ;2020-12-04 00:00:00;2020-12-10 00:00:00;164.10;0;ILS;
     301  0;0;164.10;ILS;.000;0;164.10;0;2;0;0;1;0;1000;רגילה                         ;0;.00;0;0;.000;.000;202
     401  0-12-10 00:00:00;     421
MEZAHE_TNUA=. SNIF=705 CHESHBON=12933663 LAKOAH=12933683 MLI_TEUR_SUG_CARD=עסקי זהב MEZAHE_CARD=2.2264964E17 MEZAHE_PART=590
MLI_TA_HITZTARFUT=19JUN15:00:00:00 KOD_CHEVRA=4 TEUR_CARD=ויזה KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=שופרסל דיל קרית מוצקין
MIS_SOCHER=369014 MCC4=5411 SHEM_MCC4=מכולות וסופרמרקטים COMPANY_LEGAL_ID=520022732 SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה
TAARICH_BITZUA_ISKA=02DEC20:00:00:00 BITZUA_ISKA_TIME=  TAARICH_IBUD_ISKA=04DEC20:00:00:00 TAARICH_CHIUV=10DEC20:00:00:00
SCHUM_CHIUV=164.1 MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=164.1 MATBEA_BITZUA_ISKA=ILS
ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=164.1 IND_HOCK=0 KOD_SOLECK=2 IND_ISKA_BERUR=0 IND_ISKA_MISMACH_CHASER=0
IND_ISKA_MEULETZET=1 IND_HALVAA=0 SUG_PLAN=1000 TEUR_SUG_TOCHNIT=רגילה MAHUT_KARTIS=0 RIBIT_NOTAR=0 **bleep**AT_PERAON=0 SUG_RIBIT=0
SHIUR_RIBIT=0 MIRVACH_PRIME=0 CALC_TRCH=10DEC20:00:00:00 COUNTRY_CODE=  _ERROR_=1 _N_=180
NOTE: Invalid data for MEZAHE_TNUA in line 182 1-48.
182       74580000342187939514449VT20344002400001053233900;937;3733121;3733141;מקומי;00221892454580034457;4457
     101  ;2010-08-18 00:00:00;4;ויזה;4;MAX;שיק שוק;7883702;5699;חנויות תשונות לביגוד ועזרים;28971042;111;עסקה
     201   רגילה;2020-12-06 00:00:00;        ;2020-12-08 00:00:00;2020-12-10 00:00:00;40.00;0;ILS;0;0;40.00;IL
     301  S;.000;0;40.00;0;2;0;0;1;0;1000;רגילה                         ;0;.00;0;0;.000;.000;2020-12-10 00:00:
     401  00;     407
MEZAHE_TNUA=. SNIF=937 CHESHBON=3733121 LAKOAH=3733141 MLI_TEUR_SUG_CARD=מקומי MEZAHE_CARD=2.2189245E17 MEZAHE_PART=4457
MLI_TA_HITZTARFUT=18AUG10:00:00:00 KOD_CHEVRA=4 TEUR_CARD=ויזה KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=שיק שוק MIS_SOCHER=7883702
MCC4=5699 SHEM_MCC4=חנויות תשונות לביגוד ועזרים COMPANY_LEGAL_ID=28971042 SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה
TAARICH_BITZUA_ISKA=06DEC20:00:00:00 BITZUA_ISKA_TIME=  TAARICH_IBUD_ISKA=08DEC20:00:00:00 TAARICH_CHIUV=10DEC20:00:00:00
SCHUM_CHIUV=40 MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=40 MATBEA_BITZUA_ISKA=ILS
ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=40 IND_HOCK=0 KOD_SOLECK=2 IND_ISKA_BERUR=0 IND_ISKA_MISMACH_CHASER=0
IND_ISKA_MEULETZET=1 IND_HALVAA=0 SUG_PLAN=1000 TEUR_SUG_TOCHNIT=רגילה MAHUT_KARTIS=0 RIBIT_NOTAR=0 **bleep**AT_PERAON=0 SUG_RIBIT=0
SHIUR_RIBIT=0 MIRVACH_PRIME=0 CALC_TRCH=10DEC20:00:00:00 COUNTRY_CODE=  _ERROR_=1 _N_=181
NOTE: Invalid data for MEZAHE_TNUA in line 183 1-48.
183       74403030341028000721112 T20341002804690000000100;891;5507417;5507437;זהב;00222532984580122927;2927;2
     101  001-02-20 00:00:00;4;ויזה;4;MAX;אד און דנטל סולושנס בע"מ;888144;8071;מעבדות רפואיות ומעבדות שיניים;5
     201  14273820;111;עסקה רגילה;2020-12-03 00:00:00;        ;2020-12-06 00:00:00;2020-12-10 00:00:00;620.00;
     301  0;ILS;0;0;620.00;ILS;.000;0;620.00;1;1;0;1;2;0;1000;רגילה                         ;0;.00;0;0;.000;.0
     401  00;2020-12-10 00:00:00;     427
MEZAHE_TNUA=. SNIF=891 CHESHBON=5507417 LAKOAH=5507437 MLI_TEUR_SUG_CARD=זהב MEZAHE_CARD=2.2253298E17 MEZAHE_PART=2927
MLI_TA_HITZTARFUT=20FEB01:00:00:00 KOD_CHEVRA=4 TEUR_CARD=ויזה KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=אד און דנטל סולושנס בע"מ
MIS_SOCHER=888144 MCC4=8071 SHEM_MCC4=מעבדות רפואיות ומעבדות שיניי COMPANY_LEGAL_ID=514273820 SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה
TAARICH_BITZUA_ISKA=03DEC20:00:00:00 BITZUA_ISKA_TIME=  TAARICH_IBUD_ISKA=06DEC20:00:00:00 TAARICH_CHIUV=10DEC20:00:00:00
SCHUM_CHIUV=620 MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=620 MATBEA_BITZUA_ISKA=ILS
ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=620 IND_HOCK=1 KOD_SOLECK=1 IND_ISKA_BERUR=0 IND_ISKA_MISMACH_CHASER=1
IND_ISKA_MEULETZET=2 IND_HALVAA=0 SUG_PLAN=1000 TEUR_SUG_TOCHNIT=רגילה MAHUT_KARTIS=0 RIBIT_NOTAR=0 **bleep**AT_PERAON=0 SUG_RIBIT=0
SHIUR_RIBIT=0 MIRVACH_PRIME=0 CALC_TRCH=10DEC20:00:00:00 COUNTRY_CODE=  _ERROR_=1 _N_=182
NOTE: Invalid data for MEZAHE_TNUA in line 185 1-48.
185       05326100344000901689173MT20345002600001032269600;851;36531824;36531844;פלטינה;00222360535521761612;1
     101  612;2007-07-01 00:00:00;5;מאסטרקארד;4;MAX;מקדונלד'ס מיקאדו סנטר;2534402;5814;מזנוני אוכל מהיר;511752
     201  677;111;עסקה רגילה;2020-12-08 00:00:00;        ;2020-12-10 00:00:00;2020-12-10 00:00:00;4.00;0;ILS;0
     301  ;0;4.00;ILS;.000;0;4.00;0;3;0;0;1;0;1000;רגילה                         ;R;.00;0;0;.000;.000;2020-12-
     401  10 00:00:00;     416
MEZAHE_TNUA=. SNIF=851 CHESHBON=36531824 LAKOAH=36531844 MLI_TEUR_SUG_CARD=פלטינה MEZAHE_CARD=2.2236054E17 MEZAHE_PART=1612
MLI_TA_HITZTARFUT=01JUL07:00:00:00 KOD_CHEVRA=5 TEUR_CARD=מאסטרקארד KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=מקדונלד'ס מיקאדו סנטר
MIS_SOCHER=2534402 MCC4=5814 SHEM_MCC4=מזנוני אוכל מהיר COMPANY_LEGAL_ID=511752677 SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה
TAARICH_BITZUA_ISKA=08DEC20:00:00:00 BITZUA_ISKA_TIME=  TAARICH_IBUD_ISKA=10DEC20:00:00:00 TAARICH_CHIUV=10DEC20:00:00:00
SCHUM_CHIUV=4 MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=4 MATBEA_BITZUA_ISKA=ILS
ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=4 IND_HOCK=0 KOD_SOLECK=3 IND_ISKA_BERUR=0 IND_ISKA_MISMACH_CHASER=0
IND_ISKA_MEULETZET=1 IND_HALVAA=0 SUG_PLAN=1000 TEUR_SUG_TOCHNIT=רגילה MAHUT_KARTIS=R RIBIT_NOTAR=0 **bleep**AT_PERAON=0 SUG_RIBIT=0
8                                                          The SAS System                               08:37 Sunday, April 30, 2023

SHIUR_RIBIT=0 MIRVACH_PRIME=0 CALC_TRCH=10DEC20:00:00:00 COUNTRY_CODE=  _ERROR_=1 _N_=184
NOTE: Invalid data for MEZAHE_TNUA in line 186 1-48.
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
186       74580000338187801273955VT20341003900001062565200;976;145425;145445;מקומי;00222600794580039552;9552;2
     101  007-06-28 00:00:00;4;ויזה;4;MAX;אייבורי מחשבים;5540197;5734;חנויות תוכנות מחשב;511612749;111;עסקה רג
     201  ילה;2020-12-02 00:00:00;        ;2020-12-04 00:00:00;2020-12-10 00:00:00;122.00;0;ILS;0;0;122.00;ILS
     301  ;.000;0;122.00;0;2;0;0;1;0;1000;רגילה                         ;0;.00;0;0;.000;.000;2020-12-10 00:00:
     401  00;     407
MEZAHE_TNUA=. SNIF=976 CHESHBON=145425 LAKOAH=145445 MLI_TEUR_SUG_CARD=מקומי MEZAHE_CARD=2.2260079E17 MEZAHE_PART=9552
MLI_TA_HITZTARFUT=28JUN07:00:00:00 KOD_CHEVRA=4 TEUR_CARD=ויזה KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=אייבורי מחשבים
MIS_SOCHER=5540197 MCC4=5734 SHEM_MCC4=חנויות תוכנות מחשב COMPANY_LEGAL_ID=511612749 SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה
TAARICH_BITZUA_ISKA=02DEC20:00:00:00 BITZUA_ISKA_TIME=  TAARICH_IBUD_ISKA=04DEC20:00:00:00 TAARICH_CHIUV=10DEC20:00:00:00
SCHUM_CHIUV=122 MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=122 MATBEA_BITZUA_ISKA=ILS
ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=122 IND_HOCK=0 KOD_SOLECK=2 IND_ISKA_BERUR=0 IND_ISKA_MISMACH_CHASER=0
IND_ISKA_MEULETZET=1 IND_HALVAA=0 SUG_PLAN=1000 TEUR_SUG_TOCHNIT=רגילה MAHUT_KARTIS=0 RIBIT_NOTAR=0 **bleep**AT_PERAON=0 SUG_RIBIT=0
SHIUR_RIBIT=0 MIRVACH_PRIME=0 CALC_TRCH=10DEC20:00:00:00 COUNTRY_CODE=  _ERROR_=1 _N_=185
NOTE: Invalid data for MEZAHE_TNUA in line 187 1-48.
187       74580000338187801273740VT20341003900001062563100;976;145425;145445;מקומי;00222600794580039552;9552;2
     101  007-06-28 00:00:00;4;ויזה;4;MAX;אייבורי מחשבים;5540197;5734;חנויות תוכנות מחשב;511612749;111;עסקה רג
     201  ילה;2020-12-02 00:00:00;        ;2020-12-04 00:00:00;2020-12-10 00:00:00;187.00;0;ILS;0;0;187.00;ILS
     301  ;.000;0;187.00;0;2;0;0;1;0;1000;רגילה                         ;0;.00;0;0;.000;.000;2020-12-10 00:00:
     401  00;     407
MEZAHE_TNUA=. SNIF=976 CHESHBON=145425 LAKOAH=145445 MLI_TEUR_SUG_CARD=מקומי MEZAHE_CARD=2.2260079E17 MEZAHE_PART=9552
MLI_TA_HITZTARFUT=28JUN07:00:00:00 KOD_CHEVRA=4 TEUR_CARD=ויזה KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=אייבורי מחשבים
MIS_SOCHER=5540197 MCC4=5734 SHEM_MCC4=חנויות תוכנות מחשב COMPANY_LEGAL_ID=511612749 SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה
TAARICH_BITZUA_ISKA=02DEC20:00:00:00 BITZUA_ISKA_TIME=  TAARICH_IBUD_ISKA=04DEC20:00:00:00 TAARICH_CHIUV=10DEC20:00:00:00
SCHUM_CHIUV=187 MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=187 MATBEA_BITZUA_ISKA=ILS
ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=187 IND_HOCK=0 KOD_SOLECK=2 IND_ISKA_BERUR=0 IND_ISKA_MISMACH_CHASER=0
IND_ISKA_MEULETZET=1 IND_HALVAA=0 SUG_PLAN=1000 TEUR_SUG_TOCHNIT=רגילה MAHUT_KARTIS=0 RIBIT_NOTAR=0 **bleep**AT_PERAON=0 SUG_RIBIT=0
SHIUR_RIBIT=0 MIRVACH_PRIME=0 CALC_TRCH=10DEC20:00:00:00 COUNTRY_CODE=  _ERROR_=1 _N_=186
NOTE: Invalid data for MEZAHE_TNUA in line 188 1-48.
188       04557430337000737118036VT20338003200001004012000;816;63997463;63997483;זהב;00222127654580128821;8821
     101  ;2015-04-08 00:00:00;4;ויזה;4;MAX;ש.ד. מיסוי וחשבונאות;7983596;8931;שירותי ראיית חשבון אודיטינג וניה
     201  ול ספרים;;111;עסקה רגילה;2020-12-01 00:00:00;        ;2020-12-03 00:00:00;2020-12-10 00:00:00;351.00
     301  ;0;ILS;0;0;351.00;ILS;.000;0;351.00;0;8;0;1;1;0;1000;רגילה                         ;0;.00;0;0;.000;.
     401  000;2020-12-10 00:00:00;     428
MEZAHE_TNUA=. SNIF=816 CHESHBON=63997463 LAKOAH=63997483 MLI_TEUR_SUG_CARD=זהב MEZAHE_CARD=2.2212765E17 MEZAHE_PART=8821
MLI_TA_HITZTARFUT=08APR15:00:00:00 KOD_CHEVRA=4 TEUR_CARD=ויזה KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=ש.ד. מיסוי וחשבונאות
MIS_SOCHER=7983596 MCC4=8931 SHEM_MCC4=שירותי ראיית חשבון אודיטינג COMPANY_LEGAL_ID=. SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה
TAARICH_BITZUA_ISKA=01DEC20:00:00:00 BITZUA_ISKA_TIME=  TAARICH_IBUD_ISKA=03DEC20:00:00:00 TAARICH_CHIUV=10DEC20:00:00:00
SCHUM_CHIUV=351 MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=351 MATBEA_BITZUA_ISKA=ILS
ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=351 IND_HOCK=0 KOD_SOLECK=8 IND_ISKA_BERUR=0 IND_ISKA_MISMACH_CHASER=1
IND_ISKA_MEULETZET=1 IND_HALVAA=0 SUG_PLAN=1000 TEUR_SUG_TOCHNIT=רגילה MAHUT_KARTIS=0 RIBIT_NOTAR=0 **bleep**AT_PERAON=0 SUG_RIBIT=0
SHIUR_RIBIT=0 MIRVACH_PRIME=0 CALC_TRCH=10DEC20:00:00:00 COUNTRY_CODE=  _ERROR_=1 _N_=187
NOTE: Invalid data for MEZAHE_TNUA in line 189 1-48.
189       74403030342024000006181 T20342002400042000000500;678;7644181;7644101;פלטינה;00222814634580115518;551
     101  8;2010-06-28 00:00:00;4;ויזה;4;MAX;25M שוק הכרמל;305883;5812;מסעדות;515047355;111;עסקה רגילה;2020-12
     201  -04 00:00:00;        ;2020-12-06 00:00:00;2020-12-10 00:00:00;77.00;0;ILS;0;0;77.00;ILS;.000;0;77.00
     301  ;0;1;0;0;2;0;1000;רגילה                         ;0;.00;0;0;.000;.000;2020-12-10 00:00:00;     393
MEZAHE_TNUA=. SNIF=678 CHESHBON=7644181 LAKOAH=7644101 MLI_TEUR_SUG_CARD=פלטינה MEZAHE_CARD=2.2281463E17 MEZAHE_PART=5518
MLI_TA_HITZTARFUT=28JUN10:00:00:00 KOD_CHEVRA=4 TEUR_CARD=ויזה KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=25M שוק הכרמל
MIS_SOCHER=305883 MCC4=5812 SHEM_MCC4=מסעדות COMPANY_LEGAL_ID=515047355 SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה
TAARICH_BITZUA_ISKA=04DEC20:00:00:00 BITZUA_ISKA_TIME=  TAARICH_IBUD_ISKA=06DEC20:00:00:00 TAARICH_CHIUV=10DEC20:00:00:00
SCHUM_CHIUV=77 MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=77 MATBEA_BITZUA_ISKA=ILS
ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=77 IND_HOCK=0 KOD_SOLECK=1 IND_ISKA_BERUR=0 IND_ISKA_MISMACH_CHASER=0
IND_ISKA_MEULETZET=2 IND_HALVAA=0 SUG_PLAN=1000 TEUR_SUG_TOCHNIT=רגילה MAHUT_KARTIS=0 RIBIT_NOTAR=0 **bleep**AT_PERAON=0 SUG_RIBIT=0
SHIUR_RIBIT=0 MIRVACH_PRIME=0 CALC_TRCH=10DEC20:00:00:00 COUNTRY_CODE=  _ERROR_=1 _N_=188
NOTE: Invalid data for MEZAHE_TNUA in line 190 1-48.
9                                                          The SAS System                               08:37 Sunday, April 30, 2023

RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
190       74403030342024000006165 T20342002400042000000300;678;7644181;7644101;פלטינה;00222814634580115518;551
     101  8;2010-06-28 00:00:00;4;ויזה;4;MAX;25M שוק הכרמל;305883;5812;מסעדות;515047355;111;עסקה רגילה;2020-12
     201  -04 00:00:00;        ;2020-12-06 00:00:00;2020-12-10 00:00:00;140.00;0;ILS;0;0;140.00;ILS;.000;0;140
     301  .00;0;1;0;0;2;0;1000;רגילה                         ;0;.00;0;0;.000;.000;2020-12-10 00:00:00;     396
MEZAHE_TNUA=. SNIF=678 CHESHBON=7644181 LAKOAH=7644101 MLI_TEUR_SUG_CARD=פלטינה MEZAHE_CARD=2.2281463E17 MEZAHE_PART=5518
MLI_TA_HITZTARFUT=28JUN10:00:00:00 KOD_CHEVRA=4 TEUR_CARD=ויזה KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=25M שוק הכרמל
MIS_SOCHER=305883 MCC4=5812 SHEM_MCC4=מסעדות COMPANY_LEGAL_ID=515047355 SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה
TAARICH_BITZUA_ISKA=04DEC20:00:00:00 BITZUA_ISKA_TIME=  TAARICH_IBUD_ISKA=06DEC20:00:00:00 TAARICH_CHIUV=10DEC20:00:00:00
SCHUM_CHIUV=140 MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=140 MATBEA_BITZUA_ISKA=ILS
ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=140 IND_HOCK=0 KOD_SOLECK=1 IND_ISKA_BERUR=0 IND_ISKA_MISMACH_CHASER=0
IND_ISKA_MEULETZET=2 IND_HALVAA=0 SUG_PLAN=1000 TEUR_SUG_TOCHNIT=רגילה MAHUT_KARTIS=0 RIBIT_NOTAR=0 **bleep**AT_PERAON=0 SUG_RIBIT=0
SHIUR_RIBIT=0 MIRVACH_PRIME=0 CALC_TRCH=10DEC20:00:00:00 COUNTRY_CODE=  _ERROR_=1 _N_=189
NOTE: Invalid data for MEZAHE_TNUA in line 191 1-48.
WARNING: Limit set by ERRORS= option reached.  Further errors of this type will not be printed.
191       74580000342187924371870VT20344002400001033872400;705;12933663;12933683;עסקי זהב;00222649644580100590
     101  ;0590;2015-06-19 00:00:00;4;ויזה;4;MAX;שופרסל דיל קרית מוצקין;369014;5411;מכולות וסופרמרקטים;5200227
     201  32;111;עסקה רגילה;2020-12-06 00:00:00;        ;2020-12-08 00:00:00;2020-12-10 00:00:00;279.34;0;ILS;
     301  0;0;279.34;ILS;.000;0;279.34;0;2;0;0;1;0;1000;רגילה                         ;0;.00;0;0;.000;.000;202
     401  0-12-10 00:00:00;     421
MEZAHE_TNUA=. SNIF=705 CHESHBON=12933663 LAKOAH=12933683 MLI_TEUR_SUG_CARD=עסקי זהב MEZAHE_CARD=2.2264964E17 MEZAHE_PART=590
MLI_TA_HITZTARFUT=19JUN15:00:00:00 KOD_CHEVRA=4 TEUR_CARD=ויזה KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=שופרסל דיל קרית מוצקין
MIS_SOCHER=369014 MCC4=5411 SHEM_MCC4=מכולות וסופרמרקטים COMPANY_LEGAL_ID=520022732 SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה
TAARICH_BITZUA_ISKA=06DEC20:00:00:00 BITZUA_ISKA_TIME=  TAARICH_IBUD_ISKA=08DEC20:00:00:00 TAARICH_CHIUV=10DEC20:00:00:00
SCHUM_CHIUV=279.34 MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=279.34
MATBEA_BITZUA_ISKA=ILS ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=279.34 IND_HOCK=0 KOD_SOLECK=2 IND_ISKA_BERUR=0
IND_ISKA_MISMACH_CHASER=0 IND_ISKA_MEULETZET=1 IND_HALVAA=0 SUG_PLAN=1000 TEUR_SUG_TOCHNIT=רגילה MAHUT_KARTIS=0 RIBIT_NOTAR=0
**bleep**AT_PERAON=0 SUG_RIBIT=0 SHIUR_RIBIT=0 MIRVACH_PRIME=0 CALC_TRCH=10DEC20:00:00:00 COUNTRY_CODE=  _ERROR_=1 _N_=190
NOTE: 133941499 records were read from the infile '/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/BLL_ISK2.csv'.
      The minimum record length was 333.
      The maximum record length was 485.
NOTE: The data set WORK.KELET2 has 133941499 observations and 49 variables.
NOTE: Compressing data set WORK.KELET2 decreased size by 40.39 percent. 
      Compressed is 498975 pages; un-compressed would require 837135 pages.
NOTE: DATA statement used (Total process time):
      real time           17:47.86
      user cpu time       17:06.61
      system cpu time     29.54 seconds
      memory              11391.21k
      OS Memory           36372.00k
      Timestamp           04/30/2023 10:14:30 AM
      Step Count                        27  Switch Count  2
      Page Faults                       0
      Page Reclaims                     10604
      Page Swaps                        0
      Voluntary Context Switches        137859
      Involuntary Context Switches      1106
      Block Input Operations            0
      Block Output Operations           0
      

Errors detected in submitted DATA step. Examine log.
133941499 rows created in WORK.KELET2 from /usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/BLL_ISK2.csv.
  
  
  
ERROR: Import unsuccessful.  See SAS Log for details.
NOTE: The SAS System stopped processing this step because of errors.
10                                                         The SAS System                               08:37 Sunday, April 30, 2023

NOTE: PROCEDURE IMPORT used (Total process time):
      real time           17:47.98
      user cpu time       17:06.67
      system cpu time     29.55 seconds
      memory              11391.21k
      OS Memory           36888.00k
      Timestamp           04/30/2023 10:14:30 AM
      Step Count                        27  Switch Count  9
      Page Faults                       0
      Page Reclaims                     13704
      Page Swaps                        0
      Voluntary Context Switches        137997
      Involuntary Context Switches      1108
      Block Input Operations            0
      Block Output Operations           0
      
196        
197        
198        
199        GOPTIONS NOACCESSIBLE;
200        %LET _CLIENTTASKLABEL=;
201        %LET _CLIENTPROCESSFLOWNAME=;
202        %LET _CLIENTPROJECTPATH=;
203        %LET _CLIENTPROJECTPATHHOST=;
204        %LET _CLIENTPROJECTNAME=;
205        %LET _SASPROGRAMFILE=;
206        %LET _SASPROGRAMFILEHOST=;
207        
208        ;*';*";*/;quit;run;
209        ODS _ALL_ CLOSE;
210        
211        
212        QUIT; RUN;
213        

[Patrick · Accepted solution]

Suggest next time share your log as an attachment. This will keep the discussion here "leaner".

As you can see in your log Proc Import generates data step code that it then executes. In order to generate this data step code Proc Import needs first to scan your source csv file to determine column types, lengths etc. 

Per default Proc Import doesn't scan all source rows and though things like data type, informats, lengths etc. can be inappropriate for data that comes later and hasn't been scanned.

To avoid such issues instruct Proc Import to scan all source rows first by using statement guessingrows=max;

proc import
  datafile="/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/BLL_ISK2.csv"
  out=Kelet2
  dbms=CSV
  replace;
  delimiter=';';
  GETNAMES=YES;
  guessingrows=max;
run;

[Patrick]

@Ronein It appears guessingrows fixed the immediate issue.

What I should have added to my post and what others advised: Especially if this is a repeated task don't use Proc Import but a SAS data step. You can use the Proc Import step generated code as your starting point.

Some of the reasons to not use Proc Import for repeated tasks (like an ETL job):

1. Proc Import will define variable attributes based on the source data. Source data can be different between runs and though the variable definitions can be different. For repeated tasks like monthly ETLs you need stable table structures.

2. Know your data! You should know your source data and should read it according to this knowledge. In doing so not only will you get stable table structures but it will also allow you to capture DQ issues like invalid characters for a numerical field. If you use Proc Import then the result will just be a character variable instead of a numerical one.

3. Proc Import will map source columns with only digits to a numerical variable. Sourced data like IDs can be all digits but may need to be mapped into a character variable. If the source string exceeds 15 digits then you might even end up with a rounded value in your target variable.  

[Kurt_Bremser]

Do NOT use PROC IMPORT for text files (IMHO, NEVER use PROC IMPORT; avoid any file format where you must use it - Excel!!!). Instead of letting a dumb computer make guesses on your behalf, employ your own intelligence and write the data step yourself, according to the documentation of the file in question.

Your first column is clearly not a number, and a lot longer than the 32 digits PROC IMPORT coded.

In the end, writing the code yourself will be quicker than letting PROC IMPORT do it and then spend lots of time fixing the "result".

[PaigeMiller]

NOTE: Invalid data for MEZAHE_TNUA in line 129 1-48.
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
129       74403030337030001258215 T20337003006613000000100;954;1778796;1778716;דביט;00536642644580475948;5948;

This variable is defined to be numeric. The input in columns 1-48 are not numeric. That is the problem. You probably have to change the code to look for character strings in these fields (or possibly change the data so it is numeric).

[Kurt_Bremser]

And what we've mentioned so far is just the tip of the iceberg. There's something with "time" in the name defined as $1, and something with "card" and a lot more digits than 15 (the limit of numerical precision) as a number.

I stopped looking right there.

Once again: use the file documentation to write working code and get correct data.

[AhmedAl_Attar]

Hi @Ronein 

In additions to the previous advices, from your log, the file seems to have some Hebrew characters!?

if it does, then you probably would need to tell SAS processor of that, because text files don't have metadata of their own to be queried/inspected.

Check this SAS Blog about File encoding  SAS author's tip: Encoding of external files

Hope this helps

[Sajid01]

Hello @Ronein 
From the log it appears the error starts appearing early - at row 129.
I suggest take a sample of first few hundred (say 500 rows) and try to open in a spreadsheet.

That will get a better idea of what the data is.

[Kurt_Bremser]

---

@Sajid01 wrote:

Hello @Ronein 
From the log it appears the error starts appearing early - at row 129.
I suggest take a sample of first few hundred (say 500 rows) and try to open in a spreadsheet.

That will get a better idea of what the data is.

---

I (and a lot of others here) VERY STRONGLY recommend to not open a text file with a spreadsheet program if you intend to import it into SAS. The program will show you values as it thinks they are, but not as they are stored in the file, and if you accidentally hit Save, the contents will change, sometimes beyond recognition.

Always use a suitable text editor (like Notepad++) to inspect text files before importing them.

[Sajid01]

I agree wit @Kurt_Bremser that do not open this large file with a spreadsheet.
This particular user appears to be on Linux/Unix. It is easy to create a subset  say of 500 rows from command line.

[ballardw]

If you are going to abdicate responsibility and let Proc Import make all of your decisions for you at least use the correct options.

Your proc import code:

26         proc import
27         datafile="/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/BLL_ISK2.csv"
28         out=Kelet2
29         dbms=CSV
30         replace;
31         delimiter=';';
32         GETNAMES=YES;
33         run;

Should be:

proc import
        datafile="/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/BLL_ISK2.csv"
        out=Kelet2
        dbms=CSV
        replace;
        delimiter=';';
        GETNAMES=YES;
        guessingrows=32000;
  run;

READ the documentation for Proc Import and see how many rows of data are examined by default to set properties.

The GUESSINGROWS option lets you override that behavior so that more rows are examined. This may not "fix" everything but at least would have set the type for the particular variable MEZAHE_TNUA as character. Though that still may not be correct. If the variable is intended to be numeric then you might need to have a custom informat that would set whatever numeric value that "MAX" represents in the source.

Such an informat might look like:(the SQUARE [ ] are required to reference another format/informat in proc format)

Proc format;
invalue mymax (upcase)
'MAX' = 100000000
other = [best32.]
;
run;

Then copy the code from the log (or use RECALL) to get the code into the editor instead of the Proc import step. Clean it up a bit and replace the

informat MEZAHE_TNUA best32. ;

with

informat MEZAHE_TNUA mymax. ;

This will remove the Invalid data warnings and allow you set a numeric value for MAX. But you need to know what numeric value it should represent.

[Tom]

Take the time to write your own data step to read the file and you fix the mistakes that PROC IMPORT made.

You could eliminate the issue with the first variable by just adding the GUESSINGROWS=MAX statement to the proc import step.

But that will not fix the other mistakes that PROC IMPORT makes when it guesses how to define the variables. 

For example values like 00536642644580475948 should be read as a character variable and not a number.

And most of the variables it is making a DATETIME appear to only have DATE values, the time part is just midnight on all of the example lines you showed.

Plus you can also fix the sloppiness of the code that PROC IMPORT generates. 

There is no need to attach $xx formats to character variables.

BEST is the name of a FORMAT, not an INFORMAT. And there is no need to attach an informat to normal numeric variables.

For datetime variables make sure to use at least a width of 19 on the DATETIME format you attach to the variable.  Otherwise the dates will print without the century number.   

etc.