export to ZIP TXT and then import - Page 2

Tom · Posted 10-09-2023 03:13 PM

@Ronein wrote:

Other question about import the ZP CSV file.

Should I type after INPUT word the list of all variables?

That step is to COPY the lines.

You do not need to list any variable names to the INPUT statement. It is just using the _INFILE_ automatic variable, see the PUT statement.

Ronein · Posted 10-09-2023 11:26 PM

Hello Tom.

I used the code to import the zip csv file.

However,I didnt know what to type in the length statement.

I was sure that after export the sas data set into zip csv file I will see in log the varaibles length.

The result is that the following code without using length statement produce data set with null values in many fields (specially in dates fields).

Can you help and explain what length should I write for each variable?

How can I know it?

libname LS '/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/';
data AAA;
infile SOFI dsd truncover firstobs=2;
input 
MEZAHE_CARD
date_TAARICH_BITZUA_ISKA
date_TAARICH_IBUD_ISKA
date_TAARICH_CHIUV
date_CALC_TRCH
MEZAHE_TNUA
MLI_TEUR_SUG_CARD
KOD_CHEVRA
TEUR_CARD
KOD_CHEVRA_GLOBAL
CHEVRA
SHEM_SOCHER
MIS_SOCHER
MCC4
SHEM_MCC4
COMPANY_LEGAL_ID
SUG_ISKA
TEURSUG_ISKA
SCHUM_CHIUV
MIS_TASH_NOCH
MATBEA_CHIUV
MIS_TASH_MEK
MIS_TASH_NOTRU
SCHUM_ISKA_MAT_MAKOR
MATBEA_BITZUA_ISKA
ACHUZ_RIBIT
IND_ISKAT_CHUL
SCHUM_ISKA_MAT_CHUV
IND_HOCK
KOD_SOLECK
IND_ISKA_BERUR
IND_ISKA_MISMACH_CHASER
IND_ISKA_MEULETZET
IND_HALVAA
SUG_PLAN
TEUR_SUG_TOCHNIT
MAHUT_KARTIS
RIBIT_NOTAR
**bleep**AT_PERAON
SUG_RIBIT
SHIUR_RIBIT
MIRVACH_PRIME
COUNTRY_CODE
WhichFile
Date_HITZTARFUT
month_Nechonut
LAKOACH
groupk_base
misg_crd_base
Hativa_base
nr_FollowUpMonths
Ind_Touch11
nr_Months_With_Tnua_CC
Ind_HAve_ISkaCC_BaseMon
BITZUA_ISKA_TIME
Ind_Sinun_out
MEZAHE_PART
;
run;

Here is also the log of the import

1                                                          The SAS System                              14:08 Monday, October 9, 2023

1          ;*';*";*/;quit;run;
2          OPTIONS PAGENO=MIN;
3          %LET _CLIENTTASKLABEL='Export_final_DatSet_into_CSV_File';
4          %LET _CLIENTPROCESSFLOWNAME='Process Flow';
5          %LET _CLIENTPROJECTPATH='';
6          %LET _CLIENTPROJECTPATHHOST='';
7          %LET _CLIENTPROJECTNAME='';
8          %LET _SASPROGRAMFILE='M:\a.ריכוז
8        ! תוכניות\CS\LightSolver\EXPORT_SAS_DATA_SET_INTO_CSV_FILE\Export_final_DatSet_into_CSV_File.sas';
9          %LET _SASPROGRAMFILEHOST='VSK1H0103A2021';
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         libname LS '/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/';
NOTE: Libref LS was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: /usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards
27         data AAA;
28         infile SOFI dsd truncover firstobs=2;
29         input
30         MEZAHE_CARD
31         date_TAARICH_BITZUA_ISKA
32         date_TAARICH_IBUD_ISKA
33         date_TAARICH_CHIUV
34         date_CALC_TRCH
35         MEZAHE_TNUA
36         MLI_TEUR_SUG_CARD
37         KOD_CHEVRA
38         TEUR_CARD
39         KOD_CHEVRA_GLOBAL
40         CHEVRA
41         SHEM_SOCHER
42         MIS_SOCHER
43         MCC4
44         SHEM_MCC4
45         COMPANY_LEGAL_ID
46         SUG_ISKA
47         TEURSUG_ISKA
48         SCHUM_CHIUV
49         MIS_TASH_NOCH
50         MATBEA_CHIUV
51         MIS_TASH_MEK
52         MIS_TASH_NOTRU
53         SCHUM_ISKA_MAT_MAKOR
2                                                          The SAS System                              14:08 Monday, October 9, 2023

54         MATBEA_BITZUA_ISKA
55         ACHUZ_RIBIT
56         IND_ISKAT_CHUL
57         SCHUM_ISKA_MAT_CHUV
58         IND_HOCK
59         KOD_SOLECK
60         IND_ISKA_BERUR
61         IND_ISKA_MISMACH_CHASER
62         IND_ISKA_MEULETZET
63         IND_HALVAA
64         SUG_PLAN
65         TEUR_SUG_TOCHNIT
66         MAHUT_KARTIS
67         RIBIT_NOTAR
68         **bleep**AT_PERAON
69         SUG_RIBIT
70         SHIUR_RIBIT
71         MIRVACH_PRIME
72         COUNTRY_CODE
73         WhichFile
74         Date_HITZTARFUT
75         month_Nechonut
76         LAKOACH
77         groupk_base
78         misg_crd_base
79         Hativa_base
80         nr_FollowUpMonths
81         Ind_Touch11
82         nr_Months_With_Tnua_CC
83         Ind_HAve_ISkaCC_BaseMon
84         BITZUA_ISKA_TIME
85         Ind_Sinun_out
86         MEZAHE_PART
87         ;
88         run;

NOTE: The infile SOFI is:
      Filename=/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/lightSolver_sofi.zip,
      Member Name=lightSolver_sofi.txt,
      Size=102419258329,Compressed Size=14648474299,
      CRC-32=7935875D,Date/Time=10-09-2023 19:42:44

NOTE: Invalid data for date_TAARICH_BITZUA_ISKA in line 2 38-47.
NOTE: Invalid data for date_TAARICH_IBUD_ISKA in line 2 49-58.
NOTE: Invalid data for date_TAARICH_CHIUV in line 2 60-69.
NOTE: Invalid data for date_CALC_TRCH in line 2 71-80.
NOTE: Invalid data for MEZAHE_TNUA in line 2 82-129.
NOTE: Invalid data for MLI_TEUR_SUG_CARD in line 2 131-136.
NOTE: Invalid data for TEUR_CARD in line 2 140-148.
NOTE: Invalid data for CHEVRA in line 2 152-154.
NOTE: Invalid data for SHEM_SOCHER in line 2 156-179.
NOTE: Invalid data for SHEM_MCC4 in line 2 194-199.
NOTE: Invalid data for TEURSUG_ISKA in line 2 215-224.
NOTE: Invalid data for MATBEA_CHIUV in line 2 231-233.
NOTE: Invalid data for MATBEA_BITZUA_ISKA in line 2 242-244.
NOTE: Invalid data for TEUR_SUG_TOCHNIT in line 2 270-274.
NOTE: Invalid data for COUNTRY_CODE in line 2 288-290.
NOTE: Invalid data for Date_HITZTARFUT in line 2 294-303.
3                                                          The SAS System                              14:08 Monday, October 9, 2023

NOTE: Invalid data for BITZUA_ISKA_TIME in line 2 338-342.
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
2         323433323530343535353231373636333034,23/10/2021,25/10/2021,02/11/2021,02/11/2021,0532610129700076160
     101  1461MT21298002700001059768400,פלטינה,5,מאסטרקארד,4,MAX,בלקוני מרכז הספורט בע''מ,8619090,5812,מסעדות,
     201  515962520,111,עסקה רגילה,46,0,ILS,0,0,46,ILS,0,0,46,0,3,0,0,1,0,1000,רגילה,0,0,0,0,0,0,ISR,1,01/11/2
     301  002,2110,3188,2,7500.00,833,12,0,2,1,11:00,0,7426 349
MEZAHE_CARD=3.2343332E35 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=. date_CALC_TRCH=. MEZAHE_TNUA=.
MLI_TEUR_SUG_CARD=. KOD_CHEVRA=5 TEUR_CARD=. KOD_CHEVRA_GLOBAL=4 CHEVRA=. SHEM_SOCHER=. MIS_SOCHER=8619090 MCC4=5812 SHEM_MCC4=.
COMPANY_LEGAL_ID=515962520 SUG_ISKA=111 TEURSUG_ISKA=. SCHUM_CHIUV=46 MIS_TASH_NOCH=0 MATBEA_CHIUV=. MIS_TASH_MEK=0 MIS_TASH_NOTRU=0
SCHUM_ISKA_MAT_MAKOR=46 MATBEA_BITZUA_ISKA=. ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=46 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=0
RIBIT_NOTAR=0 **bleep**AT_PERAON=0 SUG_RIBIT=0 SHIUR_RIBIT=0 MIRVACH_PRIME=0 COUNTRY_CODE=. WhichFile=1 Date_HITZTARFUT=.
month_Nechonut=2110 LAKOACH=3188 groupk_base=2 misg_crd_base=7500 Hativa_base=833 nr_FollowUpMonths=12 Ind_Touch11=0
nr_Months_With_Tnua_CC=2 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=. Ind_Sinun_out=0 MEZAHE_PART=7426 _ERROR_=1 _N_=1
NOTE: Invalid data for date_TAARICH_BITZUA_ISKA in line 3 38-47.
NOTE: Invalid data for date_TAARICH_IBUD_ISKA in line 3 49-58.
NOTE: Invalid data for date_TAARICH_CHIUV in line 3 60-69.
NOTE: Invalid data for date_CALC_TRCH in line 3 71-80.
NOTE: Invalid data for MEZAHE_TNUA in line 3 82-129.
NOTE: Invalid data for MLI_TEUR_SUG_CARD in line 3 131-136.
NOTE: Invalid data for TEUR_CARD in line 3 140-148.
NOTE: Invalid data for CHEVRA in line 3 152-154.
NOTE: Invalid data for SHEM_SOCHER in line 3 156-172.
NOTE: Invalid data for SHEM_MCC4 in line 3 189-210.
NOTE: Invalid data for TEURSUG_ISKA in line 3 226-235.
NOTE: Invalid data for MATBEA_CHIUV in line 3 242-244.
NOTE: Invalid data for MATBEA_BITZUA_ISKA in line 3 253-255.
NOTE: Invalid data for TEUR_SUG_TOCHNIT in line 3 281-285.
NOTE: Invalid data for COUNTRY_CODE in line 3 299-301.
NOTE: Invalid data for Date_HITZTARFUT in line 3 305-314.
NOTE: Invalid data for BITZUA_ISKA_TIME in line 3 349-353.
3         323433323530343535353231373636333034,24/10/2021,26/10/2021,02/11/2021,02/11/2021,0532610129800078212
     101  5978MT21299003300001029920100,פלטינה,5,מאסטרקארד,4,MAX,"מנויים לאשה)הו""ק(",754762,5968,שווק ישיר מכ
     201  ירת מנויים,510103922,111,עסקה רגילה,66,0,ILS,0,0,66,ILS,0,0,66,2,3,0,1,1,0,1000,רגילה,0,0,0,0,0,0,IS
     301  R,1,01/11/2002,2110,3188,2,7500.00,833,12,0,2,1,11:53,0,7426 360
MEZAHE_CARD=3.2343332E35 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=. date_CALC_TRCH=. MEZAHE_TNUA=.
MLI_TEUR_SUG_CARD=. KOD_CHEVRA=5 TEUR_CARD=. KOD_CHEVRA_GLOBAL=4 CHEVRA=. SHEM_SOCHER=. MIS_SOCHER=754762 MCC4=5968 SHEM_MCC4=.
COMPANY_LEGAL_ID=510103922 SUG_ISKA=111 TEURSUG_ISKA=. SCHUM_CHIUV=66 MIS_TASH_NOCH=0 MATBEA_CHIUV=. MIS_TASH_MEK=0 MIS_TASH_NOTRU=0
SCHUM_ISKA_MAT_MAKOR=66 MATBEA_BITZUA_ISKA=. ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=66 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=0
RIBIT_NOTAR=0 **bleep**AT_PERAON=0 SUG_RIBIT=0 SHIUR_RIBIT=0 MIRVACH_PRIME=0 COUNTRY_CODE=. WhichFile=1 Date_HITZTARFUT=.
month_Nechonut=2110 LAKOACH=3188 groupk_base=2 misg_crd_base=7500 Hativa_base=833 nr_FollowUpMonths=12 Ind_Touch11=0
nr_Months_With_Tnua_CC=2 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=. Ind_Sinun_out=0 MEZAHE_PART=7426 _ERROR_=1 _N_=2
NOTE: Invalid data for date_TAARICH_BITZUA_ISKA in line 4 38-47.
NOTE: Invalid data for date_TAARICH_IBUD_ISKA in line 4 49-58.
NOTE: Invalid data for date_TAARICH_CHIUV in line 4 60-69.
NOTE: Invalid data for date_CALC_TRCH in line 4 71-80.
NOTE: Invalid data for MEZAHE_TNUA in line 4 82-128.
NOTE: Invalid data for MLI_TEUR_SUG_CARD in line 4 130-135.
NOTE: Invalid data for TEUR_CARD in line 4 139-147.
NOTE: Invalid data for CHEVRA in line 4 151-153.
NOTE: Invalid data for SHEM_SOCHER in line 4 155-163.
NOTE: Invalid data for SHEM_MCC4 in line 4 178-205.
NOTE: Invalid data for TEURSUG_ISKA in line 4 221-230.
NOTE: Invalid data for MATBEA_CHIUV in line 4 237-239.
NOTE: Invalid data for MATBEA_BITZUA_ISKA in line 4 248-250.
NOTE: Invalid data for TEUR_SUG_TOCHNIT in line 4 276-280.
NOTE: Invalid data for COUNTRY_CODE in line 4 294-296.
4                                                          The SAS System                              14:08 Monday, October 9, 2023

NOTE: Invalid data for Date_HITZTARFUT in line 4 300-309.
NOTE: Invalid data for BITZUA_ISKA_TIME in line 4 344-347.
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
4         323433323530343535353231373636333034,30/11/2021,02/12/2021,02/12/2021,02/12/2021,T213360032002230001
     101  045 T21336003200223000104500,פלטינה,5,מאסטרקארד,4,MAX,דמי כרטיס,5031220,6012,מוסדות פיננסים סחורה וש
     201  רותים,123456782,111,עסקה רגילה,21,0,ILS,0,0,21,ILS,0,0,21,0,1,0,1,0,0,1000,רגילה,0,0,0,0,0,0,ISR,1,0
     301  1/11/2002,2111,3188,2,7500.00,833,12,0,2,1,0:00,0,7426 354
MEZAHE_CARD=3.2343332E35 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=. date_CALC_TRCH=. MEZAHE_TNUA=.
MLI_TEUR_SUG_CARD=. KOD_CHEVRA=5 TEUR_CARD=. KOD_CHEVRA_GLOBAL=4 CHEVRA=. SHEM_SOCHER=. MIS_SOCHER=5031220 MCC4=6012 SHEM_MCC4=.
COMPANY_LEGAL_ID=123456782 SUG_ISKA=111 TEURSUG_ISKA=. SCHUM_CHIUV=21 MIS_TASH_NOCH=0 MATBEA_CHIUV=. MIS_TASH_MEK=0 MIS_TASH_NOTRU=0
SCHUM_ISKA_MAT_MAKOR=21 MATBEA_BITZUA_ISKA=. ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=21 IND_HOCK=0 KOD_SOLECK=1
IND_ISKA_BERUR=0 IND_ISKA_MISMACH_CHASER=1 IND_ISKA_MEULETZET=0 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 COUNTRY_CODE=. WhichFile=1 Date_HITZTARFUT=.
month_Nechonut=2111 LAKOACH=3188 groupk_base=2 misg_crd_base=7500 Hativa_base=833 nr_FollowUpMonths=12 Ind_Touch11=0
nr_Months_With_Tnua_CC=2 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=. Ind_Sinun_out=0 MEZAHE_PART=7426 _ERROR_=1 _N_=3
NOTE: Invalid data for date_TAARICH_BITZUA_ISKA in line 5 38-47.
NOTE: Invalid data for date_TAARICH_IBUD_ISKA in line 5 49-58.
NOTE: Invalid data for date_TAARICH_CHIUV in line 5 60-69.
NOTE: Invalid data for date_CALC_TRCH in line 5 71-80.
NOTE: Invalid data for MEZAHE_TNUA in line 5 82-129.
NOTE: Invalid data for MLI_TEUR_SUG_CARD in line 5 131-136.
NOTE: Invalid data for TEUR_CARD in line 5 140-148.
NOTE: Invalid data for CHEVRA in line 5 152-154.
NOTE: Invalid data for SHEM_SOCHER in line 5 156-176.
NOTE: Invalid data for SHEM_MCC4 in line 5 194-226.
NOTE: Invalid data for TEURSUG_ISKA in line 5 242-251.
NOTE: Invalid data for MATBEA_CHIUV in line 5 259-261.
NOTE: Invalid data for MATBEA_BITZUA_ISKA in line 5 271-273.
NOTE: Invalid data for TEUR_SUG_TOCHNIT in line 5 300-304.
NOTE: Invalid data for COUNTRY_CODE in line 5 318-320.
NOTE: Invalid data for Date_HITZTARFUT in line 5 324-333.
NOTE: Invalid data for BITZUA_ISKA_TIME in line 5 368-372.
5         323433323530343535353231373636333034,30/10/2021,01/11/2021,02/11/2021,02/11/2021,0532610130400104787
     101  0905MT21305003000001062179400,פלטינה,5,מאסטרקארד,4,MAX,"שבלול ג'אז ישראל בע""מ",8724551,5813,פאבים/ב
     201  ארים/מועדני לילה/דיסקוטקים,516032893,111,עסקה רגילה,210,0,ILS,0,0,210,ILS,0,0,210,0,3,0,1,1,0,1000,ר
     301  גילה,0,0,0,0,0,0,ISR,1,01/11/2002,2110,3188,2,7500.00,833,12,0,2,1,10:00,0,7426 379
MEZAHE_CARD=3.2343332E35 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=. date_CALC_TRCH=. MEZAHE_TNUA=.
MLI_TEUR_SUG_CARD=. KOD_CHEVRA=5 TEUR_CARD=. KOD_CHEVRA_GLOBAL=4 CHEVRA=. SHEM_SOCHER=. MIS_SOCHER=8724551 MCC4=5813 SHEM_MCC4=.
COMPANY_LEGAL_ID=516032893 SUG_ISKA=111 TEURSUG_ISKA=. SCHUM_CHIUV=210 MIS_TASH_NOCH=0 MATBEA_CHIUV=. MIS_TASH_MEK=0
MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=210 MATBEA_BITZUA_ISKA=. ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=210 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=0 RIBIT_NOTAR=0 **bleep**AT_PERAON=0 SUG_RIBIT=0 SHIUR_RIBIT=0 MIRVACH_PRIME=0 COUNTRY_CODE=. WhichFile=1 Date_HITZTARFUT=.
month_Nechonut=2110 LAKOACH=3188 groupk_base=2 misg_crd_base=7500 Hativa_base=833 nr_FollowUpMonths=12 Ind_Touch11=0
nr_Months_With_Tnua_CC=2 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=. Ind_Sinun_out=0 MEZAHE_PART=7426 _ERROR_=1 _N_=4
NOTE: Invalid data for date_TAARICH_BITZUA_ISKA in line 6 38-47.
NOTE: Invalid data for date_TAARICH_IBUD_ISKA in line 6 49-58.
NOTE: Invalid data for date_TAARICH_CHIUV in line 6 60-69.
NOTE: Invalid data for date_CALC_TRCH in line 6 71-80.
NOTE: Invalid data for MEZAHE_TNUA in line 6 82-129.
NOTE: Invalid data for MLI_TEUR_SUG_CARD in line 6 131-136.
NOTE: Invalid data for TEUR_CARD in line 6 140-148.
NOTE: Invalid data for CHEVRA in line 6 152-154.
NOTE: Invalid data for SHEM_SOCHER in line 6 156-170.
NOTE: Invalid data for SHEM_MCC4 in line 6 185-224.
NOTE: Invalid data for TEURSUG_ISKA in line 6 240-249.
NOTE: Invalid data for MATBEA_CHIUV in line 6 260-262.
NOTE: Invalid data for MATBEA_BITZUA_ISKA in line 6 275-277.
NOTE: Invalid data for TEUR_SUG_TOCHNIT in line 6 307-311.
5                                                          The SAS System                              14:08 Monday, October 9, 2023

NOTE: Invalid data for COUNTRY_CODE in line 6 325-327.
NOTE: Invalid data for Date_HITZTARFUT in line 6 331-340.
NOTE: Invalid data for BITZUA_ISKA_TIME in line 6 375-379.
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
6         323433323530343535353231373636333034,24/11/2021,26/11/2021,02/12/2021,02/12/2021,0532610132900173863
     101  9552MT21330003100001043062800,פלטינה,5,מאסטרקארד,4,MAX,מג'יק מיט בע''מ,9188442,5499,חנויות אוכל שונו
     201  ת נוחיות)שעות פתיחה+(שוו,516207610,111,עסקה רגילה,159.18,0,ILS,0,0,159.18,ILS,0,0,159.18,0,3,0,0,1,0
     301  ,1000,רגילה,0,0,0,0,0,0,ISR,1,01/11/2002,2111,3188,2,7500.00,833,12,0,2,1,12:00,0,7426 386
MEZAHE_CARD=3.2343332E35 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=. date_CALC_TRCH=. MEZAHE_TNUA=.
MLI_TEUR_SUG_CARD=. KOD_CHEVRA=5 TEUR_CARD=. KOD_CHEVRA_GLOBAL=4 CHEVRA=. SHEM_SOCHER=. MIS_SOCHER=9188442 MCC4=5499 SHEM_MCC4=.
COMPANY_LEGAL_ID=516207610 SUG_ISKA=111 TEURSUG_ISKA=. SCHUM_CHIUV=159.18 MIS_TASH_NOCH=0 MATBEA_CHIUV=. MIS_TASH_MEK=0
MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=159.18 MATBEA_BITZUA_ISKA=. ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=159.18
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=0 RIBIT_NOTAR=0 **bleep**AT_PERAON=0 SUG_RIBIT=0 SHIUR_RIBIT=0 MIRVACH_PRIME=0 COUNTRY_CODE=. WhichFile=1
Date_HITZTARFUT=. month_Nechonut=2111 LAKOACH=3188 groupk_base=2 misg_crd_base=7500 Hativa_base=833 nr_FollowUpMonths=12
Ind_Touch11=0 nr_Months_With_Tnua_CC=2 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=. Ind_Sinun_out=0 MEZAHE_PART=7426 _ERROR_=1 _N_=5
NOTE: Invalid data for date_TAARICH_BITZUA_ISKA in line 7 38-47.
NOTE: Invalid data for date_TAARICH_IBUD_ISKA in line 7 49-58.
NOTE: Invalid data for date_TAARICH_CHIUV in line 7 60-69.
NOTE: Invalid data for date_CALC_TRCH in line 7 71-80.
NOTE: Invalid data for MEZAHE_TNUA in line 7 82-128.
NOTE: Invalid data for MLI_TEUR_SUG_CARD in line 7 130-135.
NOTE: Invalid data for TEUR_CARD in line 7 139-147.
NOTE: Invalid data for CHEVRA in line 7 151-153.
NOTE: Invalid data for SHEM_SOCHER in line 7 155-163.
NOTE: Invalid data for SHEM_MCC4 in line 7 178-205.
NOTE: Invalid data for TEURSUG_ISKA in line 7 221-230.
NOTE: Invalid data for MATBEA_CHIUV in line 7 238-240.
NOTE: Invalid data for MATBEA_BITZUA_ISKA in line 7 250-252.
NOTE: Invalid data for TEUR_SUG_TOCHNIT in line 7 279-283.
NOTE: Invalid data for COUNTRY_CODE in line 7 297-299.
NOTE: Invalid data for Date_HITZTARFUT in line 7 303-312.
NOTE: Invalid data for BITZUA_ISKA_TIME in line 7 347-350.
7         323433323530343535353231373636333034,31/10/2021,02/11/2021,02/11/2021,02/11/2021,T213060032002180000
     101  746 T21306003200218000074600,פלטינה,5,מאסטרקארד,4,MAX,דמי כרטיס,5031220,6012,מוסדות פיננסים סחורה וש
     201  רותים,123456782,111,עסקה רגילה,8.8,0,ILS,0,0,8.8,ILS,0,0,8.8,0,1,0,1,0,0,1000,רגילה,0,0,0,0,0,0,ISR,
     301  1,01/11/2002,2110,3188,2,7500.00,833,12,0,2,1,0:00,0,7426 357
MEZAHE_CARD=3.2343332E35 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=. date_CALC_TRCH=. MEZAHE_TNUA=.
MLI_TEUR_SUG_CARD=. KOD_CHEVRA=5 TEUR_CARD=. KOD_CHEVRA_GLOBAL=4 CHEVRA=. SHEM_SOCHER=. MIS_SOCHER=5031220 MCC4=6012 SHEM_MCC4=.
COMPANY_LEGAL_ID=123456782 SUG_ISKA=111 TEURSUG_ISKA=. SCHUM_CHIUV=8.8 MIS_TASH_NOCH=0 MATBEA_CHIUV=. MIS_TASH_MEK=0
MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=8.8 MATBEA_BITZUA_ISKA=. ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=8.8 IND_HOCK=0
KOD_SOLECK=1 IND_ISKA_BERUR=0 IND_ISKA_MISMACH_CHASER=1 IND_ISKA_MEULETZET=0 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 COUNTRY_CODE=. WhichFile=1 Date_HITZTARFUT=.
month_Nechonut=2110 LAKOACH=3188 groupk_base=2 misg_crd_base=7500 Hativa_base=833 nr_FollowUpMonths=12 Ind_Touch11=0
nr_Months_With_Tnua_CC=2 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=. Ind_Sinun_out=0 MEZAHE_PART=7426 _ERROR_=1 _N_=6
NOTE: Invalid data for date_TAARICH_BITZUA_ISKA in line 8 38-47.
NOTE: Invalid data for date_TAARICH_IBUD_ISKA in line 8 49-58.
NOTE: Invalid data for date_TAARICH_CHIUV in line 8 60-69.
NOTE: Invalid data for date_CALC_TRCH in line 8 71-80.
NOTE: Invalid data for MEZAHE_TNUA in line 8 82-128.
NOTE: Invalid data for MLI_TEUR_SUG_CARD in line 8 130-135.
NOTE: Invalid data for TEUR_CARD in line 8 139-147.
NOTE: Invalid data for CHEVRA in line 8 151-153.
NOTE: Invalid data for SHEM_SOCHER in line 8 155-163.
NOTE: Invalid data for SHEM_MCC4 in line 8 178-205.
NOTE: Invalid data for TEURSUG_ISKA in line 8 221-230.
NOTE: Invalid data for MATBEA_CHIUV in line 8 238-240.
NOTE: Invalid data for MATBEA_BITZUA_ISKA in line 8 250-252.
6                                                          The SAS System                              14:08 Monday, October 9, 2023

NOTE: Invalid data for TEUR_SUG_TOCHNIT in line 8 279-283.
NOTE: Invalid data for COUNTRY_CODE in line 8 297-299.
NOTE: Invalid data for Date_HITZTARFUT in line 8 303-312.
NOTE: Invalid data for BITZUA_ISKA_TIME in line 8 347-350.
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
8         323433323530343535353231373636333034,31/10/2021,02/11/2021,02/11/2021,02/11/2021,T213060032002180000
     101  745 T21306003200218000074500,פלטינה,5,מאסטרקארד,4,MAX,דמי כרטיס,5031220,6012,מוסדות פיננסים סחורה וש
     201  רותים,123456782,111,עסקה רגילה,2.7,0,ILS,0,0,2.7,ILS,0,0,2.7,0,1,0,1,0,0,1000,רגילה,0,0,0,0,0,0,ISR,
     301  1,01/11/2002,2110,3188,2,7500.00,833,12,0,2,1,0:00,0,7426 357
MEZAHE_CARD=3.2343332E35 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=. date_CALC_TRCH=. MEZAHE_TNUA=.
MLI_TEUR_SUG_CARD=. KOD_CHEVRA=5 TEUR_CARD=. KOD_CHEVRA_GLOBAL=4 CHEVRA=. SHEM_SOCHER=. MIS_SOCHER=5031220 MCC4=6012 SHEM_MCC4=.
COMPANY_LEGAL_ID=123456782 SUG_ISKA=111 TEURSUG_ISKA=. SCHUM_CHIUV=2.7 MIS_TASH_NOCH=0 MATBEA_CHIUV=. MIS_TASH_MEK=0
MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=2.7 MATBEA_BITZUA_ISKA=. ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=2.7 IND_HOCK=0
KOD_SOLECK=1 IND_ISKA_BERUR=0 IND_ISKA_MISMACH_CHASER=1 IND_ISKA_MEULETZET=0 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 COUNTRY_CODE=. WhichFile=1 Date_HITZTARFUT=.
month_Nechonut=2110 LAKOACH=3188 groupk_base=2 misg_crd_base=7500 Hativa_base=833 nr_FollowUpMonths=12 Ind_Touch11=0
nr_Months_With_Tnua_CC=2 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=. Ind_Sinun_out=0 MEZAHE_PART=7426 _ERROR_=1 _N_=7
NOTE: Invalid data for date_TAARICH_BITZUA_ISKA in line 9 38-47.
NOTE: Invalid data for date_TAARICH_IBUD_ISKA in line 9 49-58.
NOTE: Invalid data for date_TAARICH_CHIUV in line 9 60-69.
NOTE: Invalid data for date_CALC_TRCH in line 9 71-80.
NOTE: Invalid data for MEZAHE_TNUA in line 9 82-129.
NOTE: Invalid data for MLI_TEUR_SUG_CARD in line 9 131-136.
NOTE: Invalid data for TEUR_CARD in line 9 140-148.
NOTE: Invalid data for CHEVRA in line 9 152-154.
NOTE: Invalid data for SHEM_SOCHER in line 9 156-169.
NOTE: Invalid data for SHEM_MCC4 in line 9 184-200.
NOTE: Invalid data for TEURSUG_ISKA in line 9 216-225.
NOTE: Invalid data for MATBEA_CHIUV in line 9 232-234.
NOTE: Invalid data for MATBEA_BITZUA_ISKA in line 9 243-245.
NOTE: Invalid data for TEUR_SUG_TOCHNIT in line 9 271-275.
NOTE: Invalid data for COUNTRY_CODE in line 9 289-291.
NOTE: Invalid data for Date_HITZTARFUT in line 9 295-304.
NOTE: Invalid data for BITZUA_ISKA_TIME in line 9 339-343.
9         323433323530343535353231373636333034,14/11/2021,16/11/2021,02/12/2021,02/12/2021,0532610131900144854
     101  7972MT21320003800001044381900,פלטינה,5,מאסטרקארד,4,MAX,רולדין בני ברק,9101577,5451,חנויות למוצרי חלב
     201  ,514611276,111,עסקה רגילה,36,0,ILS,0,0,36,ILS,0,0,36,0,3,0,0,1,0,1000,רגילה,0,0,0,0,0,0,ISR,1,01/11/
     301  2002,2111,3188,2,7500.00,833,12,0,2,1,18:00,0,7426 350
MEZAHE_CARD=3.2343332E35 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=. date_CALC_TRCH=. MEZAHE_TNUA=.
MLI_TEUR_SUG_CARD=. KOD_CHEVRA=5 TEUR_CARD=. KOD_CHEVRA_GLOBAL=4 CHEVRA=. SHEM_SOCHER=. MIS_SOCHER=9101577 MCC4=5451 SHEM_MCC4=.
COMPANY_LEGAL_ID=514611276 SUG_ISKA=111 TEURSUG_ISKA=. SCHUM_CHIUV=36 MIS_TASH_NOCH=0 MATBEA_CHIUV=. MIS_TASH_MEK=0 MIS_TASH_NOTRU=0
SCHUM_ISKA_MAT_MAKOR=36 MATBEA_BITZUA_ISKA=. ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=36 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=0
RIBIT_NOTAR=0 **bleep**AT_PERAON=0 SUG_RIBIT=0 SHIUR_RIBIT=0 MIRVACH_PRIME=0 COUNTRY_CODE=. WhichFile=1 Date_HITZTARFUT=.
month_Nechonut=2111 LAKOACH=3188 groupk_base=2 misg_crd_base=7500 Hativa_base=833 nr_FollowUpMonths=12 Ind_Touch11=0
nr_Months_With_Tnua_CC=2 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=. Ind_Sinun_out=0 MEZAHE_PART=7426 _ERROR_=1 _N_=8
NOTE: Invalid data for date_TAARICH_BITZUA_ISKA in line 10 38-47.
NOTE: Invalid data for date_TAARICH_IBUD_ISKA in line 10 49-58.
NOTE: Invalid data for date_TAARICH_CHIUV in line 10 60-69.
NOTE: Invalid data for date_CALC_TRCH in line 10 71-80.
NOTE: Invalid data for MEZAHE_TNUA in line 10 82-129.
NOTE: Invalid data for MLI_TEUR_SUG_CARD in line 10 131-136.
NOTE: Invalid data for TEUR_CARD in line 10 140-148.
NOTE: Invalid data for CHEVRA in line 10 152-154.
NOTE: Invalid data for SHEM_SOCHER in line 10 156-172.
NOTE: Invalid data for SHEM_MCC4 in line 10 189-210.
NOTE: Invalid data for TEURSUG_ISKA in line 10 226-235.
NOTE: Invalid data for MATBEA_CHIUV in line 10 242-244.
7                                                          The SAS System                              14:08 Monday, October 9, 2023

NOTE: Invalid data for MATBEA_BITZUA_ISKA in line 10 253-255.
NOTE: Invalid data for TEUR_SUG_TOCHNIT in line 10 281-285.
NOTE: Invalid data for COUNTRY_CODE in line 10 299-301.
NOTE: Invalid data for Date_HITZTARFUT in line 10 305-314.
NOTE: Invalid data for BITZUA_ISKA_TIME in line 10 349-353.
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
10        323433323530343535353231373636333034,21/11/2021,23/11/2021,02/12/2021,02/12/2021,0532610132600162043
     101  8538MT21327002800001031396600,פלטינה,5,מאסטרקארד,4,MAX,"מנויים לאשה)הו""ק(",754762,5968,שווק ישיר מכ
     201  ירת מנויים,510103922,111,עסקה רגילה,66,0,ILS,0,0,66,ILS,0,0,66,2,3,0,1,1,0,1000,רגילה,0,0,0,0,0,0,IS
     301  R,1,01/11/2002,2111,3188,2,7500.00,833,12,0,2,1,13:38,0,7426 360
MEZAHE_CARD=3.2343332E35 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=. date_CALC_TRCH=. MEZAHE_TNUA=.
MLI_TEUR_SUG_CARD=. KOD_CHEVRA=5 TEUR_CARD=. KOD_CHEVRA_GLOBAL=4 CHEVRA=. SHEM_SOCHER=. MIS_SOCHER=754762 MCC4=5968 SHEM_MCC4=.
COMPANY_LEGAL_ID=510103922 SUG_ISKA=111 TEURSUG_ISKA=. SCHUM_CHIUV=66 MIS_TASH_NOCH=0 MATBEA_CHIUV=. MIS_TASH_MEK=0 MIS_TASH_NOTRU=0
SCHUM_ISKA_MAT_MAKOR=66 MATBEA_BITZUA_ISKA=. ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=66 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=0
RIBIT_NOTAR=0 **bleep**AT_PERAON=0 SUG_RIBIT=0 SHIUR_RIBIT=0 MIRVACH_PRIME=0 COUNTRY_CODE=. WhichFile=1 Date_HITZTARFUT=.
month_Nechonut=2111 LAKOACH=3188 groupk_base=2 misg_crd_base=7500 Hativa_base=833 nr_FollowUpMonths=12 Ind_Touch11=0
nr_Months_With_Tnua_CC=2 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=. Ind_Sinun_out=0 MEZAHE_PART=7426 _ERROR_=1 _N_=9
NOTE: Invalid data for date_TAARICH_BITZUA_ISKA in line 11 38-47.
NOTE: Invalid data for date_TAARICH_IBUD_ISKA in line 11 49-58.
NOTE: Invalid data for date_TAARICH_CHIUV in line 11 60-69.
NOTE: Invalid data for date_CALC_TRCH in line 11 71-80.
NOTE: Invalid data for MEZAHE_TNUA in line 11 82-129.
NOTE: Invalid data for MLI_TEUR_SUG_CARD in line 11 131-136.
NOTE: Invalid data for TEUR_CARD in line 11 140-148.
NOTE: Invalid data for CHEVRA in line 11 152-154.
NOTE: Invalid data for SHEM_SOCHER in line 11 156-170.
NOTE: Invalid data for SHEM_MCC4 in line 11 185-224.
NOTE: Invalid data for TEURSUG_ISKA in line 11 240-249.
NOTE: Invalid data for MATBEA_CHIUV in line 11 260-262.
NOTE: Invalid data for MATBEA_BITZUA_ISKA in line 11 275-277.
NOTE: Invalid data for TEUR_SUG_TOCHNIT in line 11 307-311.
NOTE: Invalid data for COUNTRY_CODE in line 11 325-327.
NOTE: Invalid data for Date_HITZTARFUT in line 11 331-340.
NOTE: Invalid data for BITZUA_ISKA_TIME in line 11 375-379.
11        323433323530343535353231373636333034,18/11/2021,21/11/2021,02/12/2021,02/12/2021,0532610132300156505
     101  4319MT21325004300001047106400,פלטינה,5,מאסטרקארד,4,MAX,מג'יק מיט בע''מ,9188442,5499,חנויות אוכל שונו
     201  ת נוחיות)שעות פתיחה+(שוו,516207610,111,עסקה רגילה,308.65,0,ILS,0,0,308.65,ILS,0,0,308.65,0,3,0,0,1,0
     301  ,1000,רגילה,0,0,0,0,0,0,ISR,1,01/11/2002,2111,3188,2,7500.00,833,12,0,2,1,16:00,0,7426 386
MEZAHE_CARD=3.2343332E35 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=. date_CALC_TRCH=. MEZAHE_TNUA=.
MLI_TEUR_SUG_CARD=. KOD_CHEVRA=5 TEUR_CARD=. KOD_CHEVRA_GLOBAL=4 CHEVRA=. SHEM_SOCHER=. MIS_SOCHER=9188442 MCC4=5499 SHEM_MCC4=.
COMPANY_LEGAL_ID=516207610 SUG_ISKA=111 TEURSUG_ISKA=. SCHUM_CHIUV=308.65 MIS_TASH_NOCH=0 MATBEA_CHIUV=. MIS_TASH_MEK=0
MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=308.65 MATBEA_BITZUA_ISKA=. ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=308.65
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=0 RIBIT_NOTAR=0 **bleep**AT_PERAON=0 SUG_RIBIT=0 SHIUR_RIBIT=0 MIRVACH_PRIME=0 COUNTRY_CODE=. WhichFile=1
Date_HITZTARFUT=. month_Nechonut=2111 LAKOACH=3188 groupk_base=2 misg_crd_base=7500 Hativa_base=833 nr_FollowUpMonths=12
Ind_Touch11=0 nr_Months_With_Tnua_CC=2 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=. Ind_Sinun_out=0 MEZAHE_PART=7426 _ERROR_=1
_N_=10
NOTE: Invalid data for date_TAARICH_BITZUA_ISKA in line 12 38-47.
NOTE: Invalid data for date_TAARICH_IBUD_ISKA in line 12 49-58.
NOTE: Invalid data for date_TAARICH_CHIUV in line 12 60-69.
NOTE: Invalid data for date_CALC_TRCH in line 12 71-80.
NOTE: Invalid data for MEZAHE_TNUA in line 12 82-128.
NOTE: Invalid data for MLI_TEUR_SUG_CARD in line 12 130-135.
NOTE: Invalid data for TEUR_CARD in line 12 139-147.
NOTE: Invalid data for CHEVRA in line 12 151-153.
NOTE: Invalid data for SHEM_SOCHER in line 12 155-157.
NOTE: Invalid data for SHEM_MCC4 in line 12 172-199.
8                                                          The SAS System                              14:08 Monday, October 9, 2023

NOTE: Invalid data for TEURSUG_ISKA in line 12 215-224.
NOTE: Invalid data for MATBEA_CHIUV in line 12 231-233.
NOTE: Invalid data for MATBEA_BITZUA_ISKA in line 12 242-244.
NOTE: Invalid data for COUNTRY_CODE in line 12 283-285.
NOTE: Invalid data for Date_HITZTARFUT in line 12 289-298.
NOTE: Invalid data for BITZUA_ISKA_TIME in line 12 333-336.
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
12        323433323530343535353231373636333034,05/10/2021,07/10/2021,02/11/2021,02/11/2021,T212790047000200000
     101  161 T21279004700020000016100,פלטינה,5,מאסטרקארד,4,MAX,מקס,5031000,6012,מוסדות פיננסים סחורה ושרותים,
     201  512905423,111,עסקה רגילה,15,0,ILS,0,0,15,ILS,0,0,15,0,1,0,1,0,0,1007,,0,0,0,0,0,0,ISR,1,01/11/2002,2
     301  110,3188,2,7500.00,833,12,0,2,1,0:00,0,7426 343
MEZAHE_CARD=3.2343332E35 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=. date_CALC_TRCH=. MEZAHE_TNUA=.
MLI_TEUR_SUG_CARD=. KOD_CHEVRA=5 TEUR_CARD=. KOD_CHEVRA_GLOBAL=4 CHEVRA=. SHEM_SOCHER=. MIS_SOCHER=5031000 MCC4=6012 SHEM_MCC4=.
COMPANY_LEGAL_ID=512905423 SUG_ISKA=111 TEURSUG_ISKA=. SCHUM_CHIUV=15 MIS_TASH_NOCH=0 MATBEA_CHIUV=. MIS_TASH_MEK=0 MIS_TASH_NOTRU=0
SCHUM_ISKA_MAT_MAKOR=15 MATBEA_BITZUA_ISKA=. ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=15 IND_HOCK=0 KOD_SOLECK=1
IND_ISKA_BERUR=0 IND_ISKA_MISMACH_CHASER=1 IND_ISKA_MEULETZET=0 IND_HALVAA=0 SUG_PLAN=1007 TEUR_SUG_TOCHNIT=. MAHUT_KARTIS=0
RIBIT_NOTAR=0 **bleep**AT_PERAON=0 SUG_RIBIT=0 SHIUR_RIBIT=0 MIRVACH_PRIME=0 COUNTRY_CODE=. WhichFile=1 Date_HITZTARFUT=.
month_Nechonut=2110 LAKOACH=3188 groupk_base=2 misg_crd_base=7500 Hativa_base=833 nr_FollowUpMonths=12 Ind_Touch11=0
nr_Months_With_Tnua_CC=2 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=. Ind_Sinun_out=0 MEZAHE_PART=7426 _ERROR_=1 _N_=11
NOTE: Invalid data for date_TAARICH_BITZUA_ISKA in line 13 38-47.
NOTE: Invalid data for date_TAARICH_IBUD_ISKA in line 13 49-58.
NOTE: Invalid data for date_TAARICH_CHIUV in line 13 60-69.
NOTE: Invalid data for date_CALC_TRCH in line 13 71-80.
NOTE: Invalid data for MEZAHE_TNUA in line 13 82-129.
NOTE: Invalid data for MLI_TEUR_SUG_CARD in line 13 131-136.
NOTE: Invalid data for TEUR_CARD in line 13 140-148.
NOTE: Invalid data for CHEVRA in line 13 152-154.
NOTE: Invalid data for SHEM_SOCHER in line 13 156-161.
NOTE: Invalid data for SHEM_MCC4 in line 13 176-193.
NOTE: Invalid data for TEURSUG_ISKA in line 13 209-218.
NOTE: Invalid data for MATBEA_CHIUV in line 13 226-228.
NOTE: Invalid data for MATBEA_BITZUA_ISKA in line 13 238-240.
NOTE: Invalid data for TEUR_SUG_TOCHNIT in line 13 267-271.
NOTE: Invalid data for COUNTRY_CODE in line 13 285-287.
NOTE: Invalid data for Date_HITZTARFUT in line 13 291-300.
NOTE: Invalid data for BITZUA_ISKA_TIME in line 13 335-339.
13        323433323530343535353231373636333034,24/11/2021,26/11/2021,02/12/2021,02/12/2021,7230233133002100914
     101  9782 T21330002147758000000100,פלטינה,5,מאסטרקארד,4,MAX,I.CARE,6714216,7298,מכוני יופי ובריאות,327167
     201  821,111,עסקה רגילה,140,0,ILS,0,0,140,ILS,0,0,140,1,1,0,1,1,0,1000,רגילה,0,0,0,0,0,0,ISR,1,01/11/2002
     301  ,2111,3188,2,7500.00,833,12,0,2,1,15:00,0,7426 346
MEZAHE_CARD=3.2343332E35 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=. date_CALC_TRCH=. MEZAHE_TNUA=.
MLI_TEUR_SUG_CARD=. KOD_CHEVRA=5 TEUR_CARD=. KOD_CHEVRA_GLOBAL=4 CHEVRA=. SHEM_SOCHER=. MIS_SOCHER=6714216 MCC4=7298 SHEM_MCC4=.
COMPANY_LEGAL_ID=327167821 SUG_ISKA=111 TEURSUG_ISKA=. SCHUM_CHIUV=140 MIS_TASH_NOCH=0 MATBEA_CHIUV=. MIS_TASH_MEK=0
MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=140 MATBEA_BITZUA_ISKA=. ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=140 IND_HOCK=1
KOD_SOLECK=1 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 COUNTRY_CODE=. WhichFile=1 Date_HITZTARFUT=.
month_Nechonut=2111 LAKOACH=3188 groupk_base=2 misg_crd_base=7500 Hativa_base=833 nr_FollowUpMonths=12 Ind_Touch11=0
nr_Months_With_Tnua_CC=2 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=. Ind_Sinun_out=0 MEZAHE_PART=7426 _ERROR_=1 _N_=12
NOTE: Invalid data for date_TAARICH_BITZUA_ISKA in line 14 36-45.
NOTE: Invalid data for date_TAARICH_IBUD_ISKA in line 14 47-56.
NOTE: Invalid data for date_TAARICH_CHIUV in line 14 58-67.
NOTE: Invalid data for date_CALC_TRCH in line 14 69-78.
NOTE: Invalid data for MEZAHE_TNUA in line 14 80-126.
NOTE: Invalid data for MLI_TEUR_SUG_CARD in line 14 128-130.
NOTE: Invalid data for TEUR_CARD in line 14 134-137.
NOTE: Invalid data for CHEVRA in line 14 141-143.
NOTE: Invalid data for SHEM_SOCHER in line 14 145-153.
NOTE: Invalid data for SHEM_MCC4 in line 14 166-193.
9                                                          The SAS System                              14:08 Monday, October 9, 2023

NOTE: Invalid data for TEURSUG_ISKA in line 14 209-218.
NOTE: Invalid data for MATBEA_CHIUV in line 14 225-227.
NOTE: Invalid data for MATBEA_BITZUA_ISKA in line 14 236-238.
NOTE: Invalid data for TEUR_SUG_TOCHNIT in line 14 264-268.
NOTE: Invalid data for COUNTRY_CODE in line 14 282-284.
NOTE: Invalid data for Date_HITZTARFUT in line 14 288-297.
NOTE: Invalid data for BITZUA_ISKA_TIME in line 14 333-336.
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
14        3835313138383334353830313233393336,30/09/2021,03/10/2021,03/10/2021,02/10/2021,T21276003200042000329
     101  9 T21276003200042000329900,זהב,4,ויזה,4,MAX,דמי כרטיס,31220,6012,מוסדות פיננסים סחורה ושרותים,123456
     201  782,111,עסקה רגילה,18,0,ILS,0,0,18,ILS,0,0,18,0,1,0,1,0,0,1000,רגילה,0,0,0,0,0,0,ISR,1,10/01/2001,21
     301  09,3195,2,20000.00,833,12,0,6,1,0:00,0,4039 343
MEZAHE_CARD=3.8353131E33 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=. date_CALC_TRCH=. MEZAHE_TNUA=.
MLI_TEUR_SUG_CARD=. KOD_CHEVRA=4 TEUR_CARD=. KOD_CHEVRA_GLOBAL=4 CHEVRA=. SHEM_SOCHER=. MIS_SOCHER=31220 MCC4=6012 SHEM_MCC4=.
COMPANY_LEGAL_ID=123456782 SUG_ISKA=111 TEURSUG_ISKA=. SCHUM_CHIUV=18 MIS_TASH_NOCH=0 MATBEA_CHIUV=. MIS_TASH_MEK=0 MIS_TASH_NOTRU=0
SCHUM_ISKA_MAT_MAKOR=18 MATBEA_BITZUA_ISKA=. ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=18 IND_HOCK=0 KOD_SOLECK=1
IND_ISKA_BERUR=0 IND_ISKA_MISMACH_CHASER=1 IND_ISKA_MEULETZET=0 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 COUNTRY_CODE=. WhichFile=1 Date_HITZTARFUT=.
month_Nechonut=2109 LAKOACH=3195 groupk_base=2 misg_crd_base=20000 Hativa_base=833 nr_FollowUpMonths=12 Ind_Touch11=0
nr_Months_With_Tnua_CC=6 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=. Ind_Sinun_out=0 MEZAHE_PART=4039 _ERROR_=1 _N_=13
NOTE: Invalid data for date_TAARICH_BITZUA_ISKA in line 15 36-45.
NOTE: Invalid data for date_TAARICH_IBUD_ISKA in line 15 47-56.
NOTE: Invalid data for date_TAARICH_CHIUV in line 15 58-67.
NOTE: Invalid data for date_CALC_TRCH in line 15 69-78.
NOTE: Invalid data for MEZAHE_TNUA in line 15 80-127.
NOTE: Invalid data for MLI_TEUR_SUG_CARD in line 15 129-131.
NOTE: Invalid data for TEUR_CARD in line 15 135-138.
NOTE: Invalid data for CHEVRA in line 15 142-144.
NOTE: Invalid data for SHEM_SOCHER in line 15 146-164.
NOTE: Invalid data for SHEM_MCC4 in line 15 181-191.
NOTE: Invalid data for TEURSUG_ISKA in line 15 207-216.
NOTE: Invalid data for MATBEA_CHIUV in line 15 226-228.
NOTE: Invalid data for MATBEA_BITZUA_ISKA in line 15 240-242.
NOTE: Invalid data for TEUR_SUG_TOCHNIT in line 15 271-275.
NOTE: Invalid data for COUNTRY_CODE in line 15 289-291.
NOTE: Invalid data for Date_HITZTARFUT in line 15 295-304.
NOTE: Invalid data for BITZUA_ISKA_TIME in line 15 340-344.
15        3835313138383334353830313233393336,07/07/2021,09/07/2021,02/08/2021,02/08/2021,745800011891976325202
     101  17VT21192004200001045942700,זהב,4,ויזה,4,MAX,"שופרסל שלי רמה""ש א'",604386,5311,חנויות כלבו,52002273
     201  2,111,עסקה רגילה,95.55,0,ILS,0,0,95.55,ILS,0,0,95.55,0,2,0,0,1,0,1000,רגילה,0,0,0,0,0,0,ISR,1,10/01/
     301  2001,2107,3195,2,20000.00,833,12,0,6,1,12:00,0,4039 351
MEZAHE_CARD=3.8353131E33 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=. date_CALC_TRCH=. MEZAHE_TNUA=.
MLI_TEUR_SUG_CARD=. KOD_CHEVRA=4 TEUR_CARD=. KOD_CHEVRA_GLOBAL=4 CHEVRA=. SHEM_SOCHER=. MIS_SOCHER=604386 MCC4=5311 SHEM_MCC4=.
COMPANY_LEGAL_ID=520022732 SUG_ISKA=111 TEURSUG_ISKA=. SCHUM_CHIUV=95.55 MIS_TASH_NOCH=0 MATBEA_CHIUV=. MIS_TASH_MEK=0
MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=95.55 MATBEA_BITZUA_ISKA=. ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=95.55 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 COUNTRY_CODE=. WhichFile=1 Date_HITZTARFUT=.
month_Nechonut=2107 LAKOACH=3195 groupk_base=2 misg_crd_base=20000 Hativa_base=833 nr_FollowUpMonths=12 Ind_Touch11=0
nr_Months_With_Tnua_CC=6 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=. Ind_Sinun_out=0 MEZAHE_PART=4039 _ERROR_=1 _N_=14
NOTE: Invalid data for date_TAARICH_BITZUA_ISKA in line 16 36-45.
NOTE: Invalid data for date_TAARICH_IBUD_ISKA in line 16 47-56.
NOTE: Invalid data for date_TAARICH_CHIUV in line 16 58-67.
NOTE: Invalid data for date_CALC_TRCH in line 16 69-78.
NOTE: Invalid data for MEZAHE_TNUA in line 16 80-127.
NOTE: Invalid data for MLI_TEUR_SUG_CARD in line 16 129-131.
NOTE: Invalid data for TEUR_CARD in line 16 135-138.
NOTE: Invalid data for CHEVRA in line 16 142-144.
NOTE: Invalid data for SHEM_SOCHER in line 16 146-152.
10                                                         The SAS System                              14:08 Monday, October 9, 2023

NOTE: Invalid data for SHEM_MCC4 in line 16 167-183.
NOTE: Invalid data for TEURSUG_ISKA in line 16 190-199.
NOTE: Invalid data for MATBEA_CHIUV in line 16 210-212.
NOTE: Invalid data for MATBEA_BITZUA_ISKA in line 16 225-227.
NOTE: Invalid data for TEUR_SUG_TOCHNIT in line 16 257-261.
NOTE: Invalid data for COUNTRY_CODE in line 16 275-277.
NOTE: Invalid data for Date_HITZTARFUT in line 16 281-290.
NOTE: Invalid data for BITZUA_ISKA_TIME in line 16 326-330.
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
16        3835313138383334353830313233393336,10/09/2021,12/09/2021,03/10/2021,02/10/2021,045574312550085708313
     101  71VT21256004200001043812400,זהב,4,ויזה,4,MAX,דרך יפו,9371592,5451,חנויות למוצרי חלב,,111,עסקה רגילה,
     201  221.61,0,ILS,0,0,221.61,ILS,0,0,221.61,0,8,0,0,1,0,1000,רגילה,0,0,0,0,0,0,ISR,1,10/01/2001,2109,3195
     301  ,2,20000.00,833,12,0,6,1,11:00,0,4039 337
MEZAHE_CARD=3.8353131E33 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=. date_CALC_TRCH=. MEZAHE_TNUA=.
MLI_TEUR_SUG_CARD=. KOD_CHEVRA=4 TEUR_CARD=. KOD_CHEVRA_GLOBAL=4 CHEVRA=. SHEM_SOCHER=. MIS_SOCHER=9371592 MCC4=5451 SHEM_MCC4=.
COMPANY_LEGAL_ID=. SUG_ISKA=111 TEURSUG_ISKA=. SCHUM_CHIUV=221.61 MIS_TASH_NOCH=0 MATBEA_CHIUV=. MIS_TASH_MEK=0 MIS_TASH_NOTRU=0
SCHUM_ISKA_MAT_MAKOR=221.61 MATBEA_BITZUA_ISKA=. ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=221.61 IND_HOCK=0 KOD_SOLECK=8
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 COUNTRY_CODE=. WhichFile=1 Date_HITZTARFUT=.
month_Nechonut=2109 LAKOACH=3195 groupk_base=2 misg_crd_base=20000 Hativa_base=833 nr_FollowUpMonths=12 Ind_Touch11=0
nr_Months_With_Tnua_CC=6 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=. Ind_Sinun_out=0 MEZAHE_PART=4039 _ERROR_=1 _N_=15
NOTE: Invalid data for date_TAARICH_BITZUA_ISKA in line 17 36-45.
NOTE: Invalid data for date_TAARICH_IBUD_ISKA in line 17 47-56.
NOTE: Invalid data for date_TAARICH_CHIUV in line 17 58-67.
NOTE: Invalid data for date_CALC_TRCH in line 17 69-78.
NOTE: Invalid data for MEZAHE_TNUA in line 17 80-127.
NOTE: Invalid data for MLI_TEUR_SUG_CARD in line 17 129-131.
NOTE: Invalid data for TEUR_CARD in line 17 135-138.
NOTE: Invalid data for CHEVRA in line 17 142-144.
NOTE: Invalid data for SHEM_SOCHER in line 17 146-161.
NOTE: Invalid data for SHEM_MCC4 in line 17 176-190.
NOTE: Invalid data for TEURSUG_ISKA in line 17 206-215.
NOTE: Invalid data for MATBEA_CHIUV in line 17 222-224.
NOTE: Invalid data for MATBEA_BITZUA_ISKA in line 17 233-235.
NOTE: Invalid data for TEUR_SUG_TOCHNIT in line 17 261-265.
NOTE: Invalid data for COUNTRY_CODE in line 17 279-281.
NOTE: Invalid data for Date_HITZTARFUT in line 17 285-294.
NOTE: Invalid data for BITZUA_ISKA_TIME in line 17 330-334.
17        3835313138383334353830313233393336,05/07/2021,07/07/2021,02/08/2021,02/08/2021,745800011871974980475
     101  05VT21188002900001054293200,זהב,4,ויזה,4,MAX,ש.ש. חניונים בעמ,7394197,7523,חניונים ומוסכים,512212416
     201  ,111,עסקה רגילה,34,0,ILS,0,0,34,ILS,0,0,34,0,2,0,0,1,0,1000,רגילה,0,0,0,0,0,0,ISR,1,10/01/2001,2107,
     301  3195,2,20000.00,833,12,0,6,1,10:00,0,4039 341
MEZAHE_CARD=3.8353131E33 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=. date_CALC_TRCH=. MEZAHE_TNUA=.
MLI_TEUR_SUG_CARD=. KOD_CHEVRA=4 TEUR_CARD=. KOD_CHEVRA_GLOBAL=4 CHEVRA=. SHEM_SOCHER=. MIS_SOCHER=7394197 MCC4=7523 SHEM_MCC4=.
COMPANY_LEGAL_ID=512212416 SUG_ISKA=111 TEURSUG_ISKA=. SCHUM_CHIUV=34 MIS_TASH_NOCH=0 MATBEA_CHIUV=. MIS_TASH_MEK=0 MIS_TASH_NOTRU=0
SCHUM_ISKA_MAT_MAKOR=34 MATBEA_BITZUA_ISKA=. ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=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 COUNTRY_CODE=. WhichFile=1 Date_HITZTARFUT=.
month_Nechonut=2107 LAKOACH=3195 groupk_base=2 misg_crd_base=20000 Hativa_base=833 nr_FollowUpMonths=12 Ind_Touch11=0
nr_Months_With_Tnua_CC=6 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=. Ind_Sinun_out=0 MEZAHE_PART=4039 _ERROR_=1 _N_=16
NOTE: Invalid data for date_TAARICH_BITZUA_ISKA in line 18 36-45.
NOTE: Invalid data for date_TAARICH_IBUD_ISKA in line 18 47-56.
NOTE: Invalid data for date_TAARICH_CHIUV in line 18 58-67.
NOTE: Invalid data for date_CALC_TRCH in line 18 69-78.
NOTE: Invalid data for MEZAHE_TNUA in line 18 80-127.
NOTE: Invalid data for MLI_TEUR_SUG_CARD in line 18 129-131.
NOTE: Invalid data for TEUR_CARD in line 18 135-138.
NOTE: Invalid data for CHEVRA in line 18 142-144.
11                                                         The SAS System                              14:08 Monday, October 9, 2023

NOTE: Invalid data for SHEM_SOCHER in line 18 146-164.
NOTE: Invalid data for SHEM_MCC4 in line 18 181-191.
NOTE: Invalid data for TEURSUG_ISKA in line 18 207-216.
NOTE: Invalid data for MATBEA_CHIUV in line 18 227-229.
NOTE: Invalid data for MATBEA_BITZUA_ISKA in line 18 242-244.
NOTE: Invalid data for TEUR_SUG_TOCHNIT in line 18 274-278.
NOTE: Invalid data for COUNTRY_CODE in line 18 292-294.
NOTE: Invalid data for Date_HITZTARFUT in line 18 298-307.
NOTE: Invalid data for BITZUA_ISKA_TIME in line 18 343-347.
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
18        3835313138383334353830313233393336,18/08/2021,20/08/2021,02/09/2021,02/09/2021,745800012311997934863
     101  68VT21234004400001049677100,זהב,4,ויזה,4,MAX,"שופרסל שלי רמה""ש א'",604386,5311,חנויות כלבו,52002273
     201  2,111,עסקה רגילה,150.89,0,ILS,0,0,150.89,ILS,0,0,150.89,0,2,0,0,1,0,1000,רגילה,0,0,0,0,0,0,ISR,1,10/
     301  01/2001,2108,3195,2,20000.00,833,12,0,6,1,19:00,0,4039 354
MEZAHE_CARD=3.8353131E33 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=. date_CALC_TRCH=. MEZAHE_TNUA=.
MLI_TEUR_SUG_CARD=. KOD_CHEVRA=4 TEUR_CARD=. KOD_CHEVRA_GLOBAL=4 CHEVRA=. SHEM_SOCHER=. MIS_SOCHER=604386 MCC4=5311 SHEM_MCC4=.
COMPANY_LEGAL_ID=520022732 SUG_ISKA=111 TEURSUG_ISKA=. SCHUM_CHIUV=150.89 MIS_TASH_NOCH=0 MATBEA_CHIUV=. MIS_TASH_MEK=0
MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=150.89 MATBEA_BITZUA_ISKA=. ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=150.89
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 COUNTRY_CODE=. WhichFile=1
Date_HITZTARFUT=. month_Nechonut=2108 LAKOACH=3195 groupk_base=2 misg_crd_base=20000 Hativa_base=833 nr_FollowUpMonths=12
Ind_Touch11=0 nr_Months_With_Tnua_CC=6 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=. Ind_Sinun_out=0 MEZAHE_PART=4039 _ERROR_=1
_N_=17
NOTE: Invalid data for date_TAARICH_BITZUA_ISKA in line 19 36-45.
NOTE: Invalid data for date_TAARICH_IBUD_ISKA in line 19 47-56.
NOTE: Invalid data for date_TAARICH_CHIUV in line 19 58-67.
NOTE: Invalid data for date_CALC_TRCH in line 19 69-78.
NOTE: Invalid data for MEZAHE_TNUA in line 19 80-127.
NOTE: Invalid data for MLI_TEUR_SUG_CARD in line 19 129-131.
NOTE: Invalid data for TEUR_CARD in line 19 135-138.
NOTE: Invalid data for CHEVRA in line 19 142-144.
NOTE: Invalid data for SHEM_SOCHER in line 19 146-150.
NOTE: Invalid data for SHEM_MCC4 in line 19 165-191.
NOTE: Invalid data for TEURSUG_ISKA in line 19 207-216.
NOTE: Invalid data for MATBEA_CHIUV in line 19 226-228.
NOTE: Invalid data for MATBEA_BITZUA_ISKA in line 19 240-242.
NOTE: Invalid data for TEUR_SUG_TOCHNIT in line 19 271-275.
NOTE: Invalid data for COUNTRY_CODE in line 19 289-291.
NOTE: Invalid data for Date_HITZTARFUT in line 19 295-304.
NOTE: Invalid data for BITZUA_ISKA_TIME in line 19 340-343.
19        3835313138383334353830313233393336,14/09/2021,16/09/2021,03/10/2021,02/10/2021,744030312600460013751
     101  13 T21260004604523000014200,זהב,4,ויזה,4,MAX,פז גז,2392066,4900,שירותי חשמל גז מים וסניטריה,51190333
     201  8,111,עסקה רגילה,312.3,0,ILS,0,0,312.3,ILS,0,0,312.3,1,1,0,1,2,0,1000,רגילה,0,0,0,0,0,0,ISR,1,10/01/
     301  2001,2109,3195,2,20000.00,833,12,0,6,1,9:00,0,4039 350
MEZAHE_CARD=3.8353131E33 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=. date_CALC_TRCH=. MEZAHE_TNUA=.
MLI_TEUR_SUG_CARD=. KOD_CHEVRA=4 TEUR_CARD=. KOD_CHEVRA_GLOBAL=4 CHEVRA=. SHEM_SOCHER=. MIS_SOCHER=2392066 MCC4=4900 SHEM_MCC4=.
COMPANY_LEGAL_ID=511903338 SUG_ISKA=111 TEURSUG_ISKA=. SCHUM_CHIUV=312.3 MIS_TASH_NOCH=0 MATBEA_CHIUV=. MIS_TASH_MEK=0
MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=312.3 MATBEA_BITZUA_ISKA=. ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=312.3 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 COUNTRY_CODE=. WhichFile=1 Date_HITZTARFUT=.
month_Nechonut=2109 LAKOACH=3195 groupk_base=2 misg_crd_base=20000 Hativa_base=833 nr_FollowUpMonths=12 Ind_Touch11=0
nr_Months_With_Tnua_CC=6 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=. Ind_Sinun_out=0 MEZAHE_PART=4039 _ERROR_=1 _N_=18
NOTE: Invalid data for date_TAARICH_BITZUA_ISKA in line 20 36-45.
NOTE: Invalid data for date_TAARICH_IBUD_ISKA in line 20 47-56.
NOTE: Invalid data for date_TAARICH_CHIUV in line 20 58-67.
NOTE: Invalid data for date_CALC_TRCH in line 20 69-78.
NOTE: Invalid data for MEZAHE_TNUA in line 20 80-126.
NOTE: Invalid data for MLI_TEUR_SUG_CARD in line 20 128-130.
12                                                         The SAS System                              14:08 Monday, October 9, 2023

NOTE: Invalid data for TEUR_CARD in line 20 134-137.
NOTE: Invalid data for CHEVRA in line 20 141-143.
NOTE: Invalid data for SHEM_SOCHER in line 20 145-153.
NOTE: Invalid data for SHEM_MCC4 in line 20 166-193.
NOTE: Invalid data for TEURSUG_ISKA in line 20 209-218.
NOTE: Invalid data for MATBEA_CHIUV in line 20 225-227.
NOTE: Invalid data for MATBEA_BITZUA_ISKA in line 20 236-238.
NOTE: Invalid data for TEUR_SUG_TOCHNIT in line 20 264-268.
NOTE: Invalid data for COUNTRY_CODE in line 20 282-284.
NOTE: Invalid data for Date_HITZTARFUT in line 20 288-297.
NOTE: Invalid data for BITZUA_ISKA_TIME in line 20 333-336.
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
20        3835313138383334353830313233393336,30/11/2021,02/12/2021,02/12/2021,02/12/2021,T21336003200042000175
     101  2 T21336003200042000175200,זהב,4,ויזה,4,MAX,דמי כרטיס,31220,6012,מוסדות פיננסים סחורה ושרותים,123456
     201  782,111,עסקה רגילה,18,0,ILS,0,0,18,ILS,0,0,18,0,1,0,1,0,0,1000,רגילה,0,0,0,0,0,0,ISR,1,10/01/2001,21
     301  11,3195,2,20000.00,833,12,0,6,1,0:00,0,4039 343
MEZAHE_CARD=3.8353131E33 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=. date_CALC_TRCH=. MEZAHE_TNUA=.
MLI_TEUR_SUG_CARD=. KOD_CHEVRA=4 TEUR_CARD=. KOD_CHEVRA_GLOBAL=4 CHEVRA=. SHEM_SOCHER=. MIS_SOCHER=31220 MCC4=6012 SHEM_MCC4=.
COMPANY_LEGAL_ID=123456782 SUG_ISKA=111 TEURSUG_ISKA=. SCHUM_CHIUV=18 MIS_TASH_NOCH=0 MATBEA_CHIUV=. MIS_TASH_MEK=0 MIS_TASH_NOTRU=0
SCHUM_ISKA_MAT_MAKOR=18 MATBEA_BITZUA_ISKA=. ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=18 IND_HOCK=0 KOD_SOLECK=1
IND_ISKA_BERUR=0 IND_ISKA_MISMACH_CHASER=1 IND_ISKA_MEULETZET=0 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 COUNTRY_CODE=. WhichFile=1 Date_HITZTARFUT=.
month_Nechonut=2111 LAKOACH=3195 groupk_base=2 misg_crd_base=20000 Hativa_base=833 nr_FollowUpMonths=12 Ind_Touch11=0
nr_Months_With_Tnua_CC=6 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=. Ind_Sinun_out=0 MEZAHE_PART=4039 _ERROR_=1 _N_=19
NOTE: Invalid data for date_TAARICH_BITZUA_ISKA in line 21 36-45.
NOTE: Invalid data for date_TAARICH_IBUD_ISKA in line 21 47-56.
NOTE: Invalid data for date_TAARICH_CHIUV in line 21 58-67.
NOTE: Invalid data for date_CALC_TRCH in line 21 69-78.
NOTE: Invalid data for MEZAHE_TNUA in line 21 80-127.
NOTE: Invalid data for MLI_TEUR_SUG_CARD in line 21 129-131.
NOTE: Invalid data for TEUR_CARD in line 21 135-138.
NOTE: Invalid data for CHEVRA in line 21 142-144.
NOTE: Invalid data for SHEM_SOCHER in line 21 146-170.
NOTE: Invalid data for SHEM_MCC4 in line 21 188-227.
NOTE: Invalid data for TEURSUG_ISKA in line 21 234-243.
NOTE: Invalid data for MATBEA_CHIUV in line 21 250-252.
NOTE: Invalid data for MATBEA_BITZUA_ISKA in line 21 261-263.
NOTE: Invalid data for TEUR_SUG_TOCHNIT in line 21 289-293.
NOTE: Invalid data for COUNTRY_CODE in line 21 307-309.
NOTE: Invalid data for Date_HITZTARFUT in line 21 313-322.
NOTE: Invalid data for BITZUA_ISKA_TIME in line 21 358-361.
WARNING: Limit set by ERRORS= option reached.  Further errors of this type will not be printed.
21        3835313138383334353830313233393336,08/06/2021,10/06/2021,02/07/2021,02/07/2021,045574311600057053046
     101  33VT21162003000001002566900,זהב,4,ויזה,4,MAX,"טנטרה שיווק מזון בע""מ-צמר",6253652,5499,חנויות אוכל ש
     201  ונות נוחיות)שעות פתיחה+(שוו,,111,עסקה רגילה,92,0,ILS,0,0,92,ILS,0,0,92,0,8,0,0,1,0,1000,רגילה,0,0,0,
     301  0,0,0,ISR,1,10/01/2001,2106,3195,2,20000.00,833,12,0,6,1,8:00,0,4039 368
MEZAHE_CARD=3.8353131E33 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=. date_CALC_TRCH=. MEZAHE_TNUA=.
MLI_TEUR_SUG_CARD=. KOD_CHEVRA=4 TEUR_CARD=. KOD_CHEVRA_GLOBAL=4 CHEVRA=. SHEM_SOCHER=. MIS_SOCHER=6253652 MCC4=5499 SHEM_MCC4=.
COMPANY_LEGAL_ID=. SUG_ISKA=111 TEURSUG_ISKA=. SCHUM_CHIUV=92 MIS_TASH_NOCH=0 MATBEA_CHIUV=. MIS_TASH_MEK=0 MIS_TASH_NOTRU=0
SCHUM_ISKA_MAT_MAKOR=92 MATBEA_BITZUA_ISKA=. ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=92 IND_HOCK=0 KOD_SOLECK=8
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 COUNTRY_CODE=. WhichFile=1 Date_HITZTARFUT=.
month_Nechonut=2106 LAKOACH=3195 groupk_base=2 misg_crd_base=20000 Hativa_base=833 nr_FollowUpMonths=12 Ind_Touch11=0
nr_Months_With_Tnua_CC=6 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=. Ind_Sinun_out=0 MEZAHE_PART=4039 _ERROR_=1 _N_=20
NOTE: 287603020 records were read from the infile SOFI.
      The minimum record length was 278.
      The maximum record length was 431.
NOTE: The data set WORK.AAA has 287603020 observations and 57 variables.
13                                                         The SAS System                              14:08 Monday, October 9, 2023

NOTE: Compressing data set WORK.AAA decreased size by 49.25 percent. 
      Compressed is 1020713 pages; un-compressed would require 2011211 pages.
NOTE: DATA statement used (Total process time):
      real time           39:33.97
      user cpu time       25:04.97
      system cpu time     49.21 seconds
      memory              1472.53k
      OS Memory           28324.00k
      Timestamp           10/09/2023 10:29:54 PM
      Step Count                        14  Switch Count  2
      Page Faults                       0
      Page Reclaims                     13242
      Page Swaps                        0
      Voluntary Context Switches        278624
      Involuntary Context Switches      14725
      Block Input Operations            0
      Block Output Operations           0
      

89         
90         GOPTIONS NOACCESSIBLE;
91         %LET _CLIENTTASKLABEL=;
92         %LET _CLIENTPROCESSFLOWNAME=;
93         %LET _CLIENTPROJECTPATH=;
94         %LET _CLIENTPROJECTPATHHOST=;
95         %LET _CLIENTPROJECTNAME=;
96         %LET _SASPROGRAMFILE=;
97         %LET _SASPROGRAMFILEHOST=;
98         
99         ;*';*";*/;quit;run;
100        ODS _ALL_ CLOSE;
101        
102        
103        QUIT; RUN;
104        
14                                                         The SAS System                              14:08 Monday, October 9, 2023

NOTE: SAS threaded sort was used.

Kurt_Bremser · Posted 10-10-2023 12:00 AM

When you read the file back, you have to use the same variable attributes (type, length, format) which you have in the original dataset. Formatted values (like dates) need to be read with the corresponding informat.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

Tom · Posted 10-09-2023 03:19 PM

That note is appearing in your step that is WRITING the CSV file.

I means that one of the variables in the dataset you read in had that format permanently attached. But you have not told your current SAS session where to find that format.

The result will be that the RAW value of the variable will be written to the CSV file instead of the formatted value.

For example if you had a format named YESNO for printing 1 as YES and 0 as NO and you created a variable with the values of 1 and 0 and attached that YESNO format to the variable then when SAS printed the variable it would write YES and NO instead of 1 and 0. But if SAS cannot find the YESNO format then it will just write the digits 1 and 0 instead.

Ronein · Posted 10-10-2023 01:11 AM

Hello Tom,

In the code you provided for export sas data set into ZIP CSV file there was not length statement.

Then I wanted to import back this file and I used length statement with same attributes as in the original sas data set .

But then I received messages that there are numeric fields that I applied for them char attribute....

My question-

Can I add Length statement to the code of export data set into ZIP CSV?

Kurt_Bremser · Posted 10-10-2023 02:10 AM

You have to define the correct types and other attributes. Use a LENGTH statement before the INPUT, or read all variables with proper informats in the INPUT. Use the colon modifier to keep list input.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

Ronein · Posted 10-10-2023 03:13 AM

I tried import back and got error

libname LS '/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/';
filename SOFI zip "/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/RRR1.zip" member="RRR1.CSV";

filename copy temp;
data _null_;
infile sofi;
file copy;
input;/**No need to write the vars here**/
put _infile_ ;
Run;
proc import file=copy dbms=csv  out=Import_Back_Data_Set replace;
Run;

Log

1                                                          The SAS System                            08:15 Tuesday, October 10, 2023

1          ;*';*";*/;quit;run;
2          OPTIONS PAGENO=MIN;
3          %LET _CLIENTTASKLABEL='EXPORT_TO_ZIP_CSV_AND_THEN_IMPORT_BACK_SOFI';
4          %LET _CLIENTPROCESSFLOWNAME='Process Flow';
5          %LET _CLIENTPROJECTPATH='';
6          %LET _CLIENTPROJECTPATHHOST='';
7          %LET _CLIENTPROJECTNAME='';
8          %LET _SASPROGRAMFILE='M:\a.ריכוז
8        ! תוכניות\CS\LightSolver\EXPORT_SAS_DATA_SET_INTO_CSV_FILE\EXPORT_TO_ZIP_CSV_AND_THEN_IMPORT_BACK_SOFI.sas';
9          %LET _SASPROGRAMFILEHOST='VSK1H0103A2021';
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         libname LS '/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/';
NOTE: Libref LS was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: /usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards
27         filename SOFI zip "/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/RRR1.zip" member="RRR1.CSV";
28         
29         filename copy temp;
30         data _null_;
31         infile sofi;
32         file copy;
33         input;/**No need to write the vars here**/
34         put _infile_ ;
35         Run;

NOTE: The infile SOFI is:
      Filename=/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/RRR1.zip,
      Member Name=RRR1.CSV,Size=350120,
      Compressed Size=48887,CRC-32=BC7E83D7,
      Date/Time=10-10-2023 10:07:20

NOTE: The file COPY is:
      Filename=/usr/local/saswork/SAS_workCCB900003020_LINX107717A13/#LN00045,
      Owner Name=Udclk79,
      Group Name=GR_IL_VAS_LOGIN_GROUP,
      Access Permission=-rw-rw-r--,
      Last Modified=10Oct2023:10:08:19

NOTE: 1001 records were read from the infile SOFI.
      The minimum record length was 315.
      The maximum record length was 810.
NOTE: 1001 records were written to the file COPY.
2                                                          The SAS System                            08:15 Tuesday, October 10, 2023

      The minimum record length was 315.
      The maximum record length was 810.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              542.65k
      OS Memory           29604.00k
      Timestamp           10/10/2023 10:08:19 AM
      Step Count                        35  Switch Count  0
      Page Faults                       0
      Page Reclaims                     119
      Page Swaps                        0
      Voluntary Context Switches        13
      Involuntary Context Switches      0
      Block Input Operations            0
      Block Output Operations           0
      

36         proc import file=copy dbms=csv  out=Import_Back_Data_Set replace;
37         Run;

38          /**********************************************************************
39          *   PRODUCT:   SAS
40          *   VERSION:   9.4
41          *   CREATOR:   External File Interface
42          *   DATE:      10OCT23
43          *   DESC:      Generated SAS Datastep Code
44          *   TEMPLATE SOURCE:  (None Specified.)
45          ***********************************************************************/
46             data WORK.IMPORT_BACK_DATA_SET    ;
47             %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
48             infile COPY delimiter = ',' MISSOVER DSD  firstobs=2 ;
49                informat MEZAHE_CARD best32. ;
50                informat date_TAARICH_BITZUA_ISKA ddmmyy10. ;
51                informat date_TAARICH_IBUD_ISKA ddmmyy10. ;
52                informat date_TAARICH_CHIUV mmddyy10. ;
53                informat date_CALC_TRCH mmddyy10. ;
54                informat MEZAHE_TNUA $48. ;
55                informat MLI_TEUR_SUG_CARD $6. ;
56                informat KOD_CHEVRA best32. ;
57                informat TEUR_CARD $9. ;
58                informat KOD_CHEVRA_GLOBAL best32. ;
59                informat CHEVRA $3. ;
60                informat SHEM_SOCHER $24. ;
61                informat MIS_SOCHER best32. ;
62                informat MCC4 best32. ;
63                informat SHEM_MCC4 $40. ;
64                informat COMPANY_LEGAL_ID best32. ;
65                informat SUG_ISKA best32. ;
66                informat TEURSUG_ISKA $10. ;
67                informat SCHUM_CHIUV best32. ;
68                informat MIS_TASH_NOCH best32. ;
69                informat MATBEA_CHIUV $3. ;
70                informat MIS_TASH_MEK best32. ;
71                informat MIS_TASH_NOTRU best32. ;
72                informat SCHUM_ISKA_MAT_MAKOR best32. ;
73                informat MATBEA_BITZUA_ISKA $3. ;
3                                                          The SAS System                            08:15 Tuesday, October 10, 2023

74                informat ACHUZ_RIBIT best32. ;
75                informat IND_ISKAT_CHUL best32. ;
76                informat SCHUM_ISKA_MAT_CHUV best32. ;
77                informat IND_HOCK best32. ;
78                informat KOD_SOLECK best32. ;
79                informat IND_ISKA_BERUR best32. ;
80                informat IND_ISKA_MISMACH_CHASER best32. ;
81                informat IND_ISKA_MEULETZET best32. ;
82                informat IND_HALVAA best32. ;
83                informat SUG_PLAN best32. ;
84                informat TEUR_SUG_TOCHNIT $5. ;
85                informat MAHUT_KARTIS best32. ;
86                informat RIBIT_NOTAR best32. ;
87                informat **bleep**AT_PERAON best32. ;
88                informat SUG_RIBIT best32. ;
89                informat SHIUR_RIBIT best32. ;
90                informat MIRVACH_PRIME best32. ;
91                informat COUNTRY_CODE $3. ;
92                informat WhichFile best32. ;
93                informat Date_HITZTARFUT mmddyy10. ;
94                informat month_Nechonut best32. ;
95                informat LAKOACH best32. ;
96                informat groupk_base best32. ;
97                informat misg_crd_base best32. ;
98                informat Hativa_base best32. ;
99                informat nr_FollowUpMonths best32. ;
100               informat Ind_Touch11 best32. ;
101               informat nr_Months_With_Tnua_CC best32. ;
102               informat Ind_HAve_ISkaCC_BaseMon best32. ;
103               informat BITZUA_ISKA_TIME $5. ;
104               informat Ind_Sinun_out best32. ;
105               informat MEZAHE_PART best32. ;
106               format MEZAHE_CARD best12. ;
107               format date_TAARICH_BITZUA_ISKA ddmmyy10. ;
108               format date_TAARICH_IBUD_ISKA ddmmyy10. ;
109               format date_TAARICH_CHIUV mmddyy10. ;
110               format date_CALC_TRCH mmddyy10. ;
111               format MEZAHE_TNUA $48. ;
112               format MLI_TEUR_SUG_CARD $6. ;
113               format KOD_CHEVRA best12. ;
114               format TEUR_CARD $9. ;
115               format KOD_CHEVRA_GLOBAL best12. ;
116               format CHEVRA $3. ;
117               format SHEM_SOCHER $24. ;
118               format MIS_SOCHER best12. ;
119               format MCC4 best12. ;
120               format SHEM_MCC4 $40. ;
121               format COMPANY_LEGAL_ID best12. ;
122               format SUG_ISKA best12. ;
123               format TEURSUG_ISKA $10. ;
124               format SCHUM_CHIUV best12. ;
125               format MIS_TASH_NOCH best12. ;
126               format MATBEA_CHIUV $3. ;
127               format MIS_TASH_MEK best12. ;
128               format MIS_TASH_NOTRU best12. ;
129               format SCHUM_ISKA_MAT_MAKOR best12. ;
130               format MATBEA_BITZUA_ISKA $3. ;
131               format ACHUZ_RIBIT best12. ;
4                                                          The SAS System                            08:15 Tuesday, October 10, 2023

132               format IND_ISKAT_CHUL best12. ;
133               format SCHUM_ISKA_MAT_CHUV best12. ;
134               format IND_HOCK best12. ;
135               format KOD_SOLECK best12. ;
136               format IND_ISKA_BERUR best12. ;
137               format IND_ISKA_MISMACH_CHASER best12. ;
138               format IND_ISKA_MEULETZET best12. ;
139               format IND_HALVAA best12. ;
140               format SUG_PLAN best12. ;
141               format TEUR_SUG_TOCHNIT $5. ;
142               format MAHUT_KARTIS best12. ;
143               format RIBIT_NOTAR best12. ;
144               format **bleep**AT_PERAON best12. ;
145               format SUG_RIBIT best12. ;
146               format SHIUR_RIBIT best12. ;
147               format MIRVACH_PRIME best12. ;
148               format COUNTRY_CODE $3. ;
149               format WhichFile best12. ;
150               format Date_HITZTARFUT mmddyy10. ;
151               format month_Nechonut best12. ;
152               format LAKOACH best12. ;
153               format groupk_base best12. ;
154               format misg_crd_base best12. ;
155               format Hativa_base best12. ;
156               format nr_FollowUpMonths best12. ;
157               format Ind_Touch11 best12. ;
158               format nr_Months_With_Tnua_CC best12. ;
159               format Ind_HAve_ISkaCC_BaseMon best12. ;
160               format BITZUA_ISKA_TIME $5. ;
161               format Ind_Sinun_out best12. ;
162               format MEZAHE_PART best12. ;
163            input
164                        MEZAHE_CARD
165                        date_TAARICH_BITZUA_ISKA
166                        date_TAARICH_IBUD_ISKA
167                        date_TAARICH_CHIUV
168                        date_CALC_TRCH
169                        MEZAHE_TNUA $
170                        MLI_TEUR_SUG_CARD $
171                        KOD_CHEVRA
172                        TEUR_CARD $
173                        KOD_CHEVRA_GLOBAL
174                        CHEVRA $
175                        SHEM_SOCHER $
176                        MIS_SOCHER
177                        MCC4
178                        SHEM_MCC4 $
179                        COMPANY_LEGAL_ID
180                        SUG_ISKA
181                        TEURSUG_ISKA $
182                        SCHUM_CHIUV
183                        MIS_TASH_NOCH
184                        MATBEA_CHIUV $
185                        MIS_TASH_MEK
186                        MIS_TASH_NOTRU
187                        SCHUM_ISKA_MAT_MAKOR
188                        MATBEA_BITZUA_ISKA $
189                        ACHUZ_RIBIT
5                                                          The SAS System                            08:15 Tuesday, October 10, 2023

190                        IND_ISKAT_CHUL
191                        SCHUM_ISKA_MAT_CHUV
192                        IND_HOCK
193                        KOD_SOLECK
194                        IND_ISKA_BERUR
195                        IND_ISKA_MISMACH_CHASER
196                        IND_ISKA_MEULETZET
197                        IND_HALVAA
198                        SUG_PLAN
199                        TEUR_SUG_TOCHNIT $
200                        MAHUT_KARTIS
201                        RIBIT_NOTAR
202                        **bleep**AT_PERAON
203                        SUG_RIBIT
204                        SHIUR_RIBIT
205                        MIRVACH_PRIME
206                        COUNTRY_CODE $
207                        WhichFile
208                        Date_HITZTARFUT
209                        month_Nechonut
210                        LAKOACH
211                        groupk_base
212                        misg_crd_base
213                        Hativa_base
214                        nr_FollowUpMonths
215                        Ind_Touch11
216                        nr_Months_With_Tnua_CC
217                        Ind_HAve_ISkaCC_BaseMon
218                        BITZUA_ISKA_TIME $
219                        Ind_Sinun_out
220                        MEZAHE_PART
221            ;
222            if _ERROR_ then call symputx('_EFIERR_',1);  /* set ERROR detection macro variable */
223            run;

NOTE: The infile COPY is:
      Filename=/usr/local/saswork/SAS_workCCB900003020_LINX107717A13/#LN00045,
      Owner Name=Udclk79,
      Group Name=GR_IL_VAS_LOGIN_GROUP,
      Access Permission=-rw-rw-r--,
      Last Modified=10Oct2023:10:08:19,
      File Size (bytes)=350120

NOTE: Invalid data for date_TAARICH_CHIUV in line 94 58-67.
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
94        3835313138383334353830313233393336,17/06/2021,20/06/2021,20/06/2021,02/07/2021,749875011680051651058
     101  55VT21171003100121000014200,זהב,4,ויזה,4,MAX,eBay O*22-07218-12772  Luxembourg,0,5311,חנויות כלבו,,1
     201  11,עסקה רגילה,154.76,0,ILS,0,0,33.14,GBP,0,1,150.25,0,4,0,1,2,0,1000,רגילה,0,0,0,0,0,0,LUX,1,10/01/2
     301  001,2106,3195,2,20000.00,833,12,0,6,1,13:00,0,4039 350
MEZAHE_CARD=3.8353131E33 date_TAARICH_BITZUA_ISKA=17/06/2021 date_TAARICH_IBUD_ISKA=20/06/2021 date_TAARICH_CHIUV=.
date_CALC_TRCH=02/07/2021 MEZAHE_TNUA=74987501168005165105855VT21171003100121000014200 MLI_TEUR_SUG_CARD=זהב KOD_CHEVRA=4
TEUR_CARD=ויזה KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=eBay O*22-07218-12772  L MIS_SOCHER=0 MCC4=5311 SHEM_MCC4=חנויות כלבו
COMPANY_LEGAL_ID=. SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה SCHUM_CHIUV=154.76 MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0
MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=33.14 MATBEA_BITZUA_ISKA=GBP ACHUZ_RIBIT=0 IND_ISKAT_CHUL=1 SCHUM_ISKA_MAT_CHUV=150.25
IND_HOCK=0 KOD_SOLECK=4 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 COUNTRY_CODE=LUX
WhichFile=1 Date_HITZTARFUT=10/01/2001 month_Nechonut=2106 LAKOACH=3195 groupk_base=2 misg_crd_base=20000 Hativa_base=833
nr_FollowUpMonths=12 Ind_Touch11=0 nr_Months_With_Tnua_CC=6 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=13:00 Ind_Sinun_out=0
6                                                          The SAS System                            08:15 Tuesday, October 10, 2023

MEZAHE_PART=4039 _ERROR_=1 _N_=93
NOTE: Invalid data for date_TAARICH_CHIUV in line 209 58-67.
NOTE: Invalid data for date_CALC_TRCH in line 209 69-78.
NOTE: Invalid data for Date_HITZTARFUT in line 209 276-285.
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
209       3739323631353735353231373632343136,27/10/2021,29/10/2021,15/11/2021,15/11/2021,053261013010009566023
     101  36MT21302002700001078343400,פלטינה,5,מאסטרקארד,4,MAX,קפה לורן,7787740,5812,מסעדות,515973535,111,עסקה
     201   רגילה,71,0,ILS,0,0,71,ILS,0,0,71,0,3,0,1,1,0,1000,רגילה,0,0,0,0,0,0,ISR,1,28/04/2006,2110,3196,2,24
     301  000.00,833,12,0,6,1,17:00,0,3524 332
MEZAHE_CARD=3.7393236E33 date_TAARICH_BITZUA_ISKA=27/10/2021 date_TAARICH_IBUD_ISKA=29/10/2021 date_TAARICH_CHIUV=. date_CALC_TRCH=.
MEZAHE_TNUA=05326101301000956602336MT21302002700001078343400 MLI_TEUR_SUG_CARD=פלטינה KOD_CHEVRA=5 TEUR_CARD=מאסטרקארד
KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=קפה לורן MIS_SOCHER=7787740 MCC4=5812 SHEM_MCC4=מסעדות COMPANY_LEGAL_ID=515973535
SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה SCHUM_CHIUV=71 MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0
SCHUM_ISKA_MAT_MAKOR=71 MATBEA_BITZUA_ISKA=ILS ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=71 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=0
RIBIT_NOTAR=0 **bleep**AT_PERAON=0 SUG_RIBIT=0 SHIUR_RIBIT=0 MIRVACH_PRIME=0 COUNTRY_CODE=ISR WhichFile=1 Date_HITZTARFUT=.
month_Nechonut=2110 LAKOACH=3196 groupk_base=2 misg_crd_base=24000 Hativa_base=833 nr_FollowUpMonths=12 Ind_Touch11=0
nr_Months_With_Tnua_CC=6 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=17:00 Ind_Sinun_out=0 MEZAHE_PART=3524 _ERROR_=1 _N_=208
NOTE: Invalid data for date_TAARICH_CHIUV in line 211 58-67.
NOTE: Invalid data for date_CALC_TRCH in line 211 69-78.
NOTE: Invalid data for Date_HITZTARFUT in line 211 292-301.
211       3739323631353735353231373632343136,05/10/2021,07/10/2021,15/10/2021,15/10/2021,751004612792021687931
     101  16MT21280002900001014078000,פלטינה,5,מאסטרקארד,4,MAX,מרכז הזול,1757258,5200,מחסני מוצרי בית,55757377
     201  1,111,עסקה רגילה,33.8,0,ILS,0,0,33.8,ILS,0,0,33.8,0,2,0,0,1,0,1000,רגילה,0,0,0,0,0,0,ISR,1,28/04/200
     301  6,2110,3196,2,24000.00,833,12,0,6,1,10:00,0,3524 348
MEZAHE_CARD=3.7393236E33 date_TAARICH_BITZUA_ISKA=05/10/2021 date_TAARICH_IBUD_ISKA=07/10/2021 date_TAARICH_CHIUV=. date_CALC_TRCH=.
MEZAHE_TNUA=75100461279202168793116MT21280002900001014078000 MLI_TEUR_SUG_CARD=פלטינה KOD_CHEVRA=5 TEUR_CARD=מאסטרקארד
KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=מרכז הזול MIS_SOCHER=1757258 MCC4=5200 SHEM_MCC4=מחסני מוצרי בית
COMPANY_LEGAL_ID=557573771 SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה SCHUM_CHIUV=33.8 MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0
MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=33.8 MATBEA_BITZUA_ISKA=ILS ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=33.8 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 COUNTRY_CODE=ISR WhichFile=1
Date_HITZTARFUT=. month_Nechonut=2110 LAKOACH=3196 groupk_base=2 misg_crd_base=24000 Hativa_base=833 nr_FollowUpMonths=12
Ind_Touch11=0 nr_Months_With_Tnua_CC=6 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=10:00 Ind_Sinun_out=0 MEZAHE_PART=3524 _ERROR_=1
_N_=210
NOTE: Invalid data for date_TAARICH_CHIUV in line 212 58-67.
NOTE: Invalid data for date_CALC_TRCH in line 212 69-78.
NOTE: Invalid data for Date_HITZTARFUT in line 212 336-345.
212       3739323631353735353231373632343136,15/11/2021,17/11/2021,15/12/2021,15/12/2021,053261013190014609764
     101  48MT21321003600001035734700,פלטינה,5,מאסטרקארד,4,MAX,"בזק בינלאומי בע""מ-צמרת",8292815,4814,שרותי תק
     201  שורת כולל שיחות רגילות בכרטיסי א,512834896,111,עסקה רגילה,63.91,0,ILS,0,0,63.91,ILS,0,0,63.91,2,3,0,
     301  1,1,0,1000,רגילה,0,0,0,0,0,0,ISR,1,28/04/2006,2111,3196,2,24000.00,833,12,0,6,1,15:43,0,3524 392
MEZAHE_CARD=3.7393236E33 date_TAARICH_BITZUA_ISKA=15/11/2021 date_TAARICH_IBUD_ISKA=17/11/2021 date_TAARICH_CHIUV=. date_CALC_TRCH=.
MEZAHE_TNUA=05326101319001460976448MT21321003600001035734700 MLI_TEUR_SUG_CARD=פלטינה KOD_CHEVRA=5 TEUR_CARD=מאסטרקארד
KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=בזק בינלאומי בע"מ-צמרת MIS_SOCHER=8292815 MCC4=4814
SHEM_MCC4=שרותי תקשורת כולל שיחות רגילות בכרטיסי א COMPANY_LEGAL_ID=512834896 SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה SCHUM_CHIUV=63.91
MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=63.91 MATBEA_BITZUA_ISKA=ILS ACHUZ_RIBIT=0
IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=63.91 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=0 RIBIT_NOTAR=0 **bleep**AT_PERAON=0 SUG_RIBIT=0 SHIUR_RIBIT=0
MIRVACH_PRIME=0 COUNTRY_CODE=ISR WhichFile=1 Date_HITZTARFUT=. month_Nechonut=2111 LAKOACH=3196 groupk_base=2 misg_crd_base=24000
Hativa_base=833 nr_FollowUpMonths=12 Ind_Touch11=0 nr_Months_With_Tnua_CC=6 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=15:43
Ind_Sinun_out=0 MEZAHE_PART=3524 _ERROR_=1 _N_=211
NOTE: Invalid data for date_TAARICH_CHIUV in line 215 58-67.
215       3739323631353734353830313232363234,28/07/2021,30/07/2021,29/07/2021,02/08/2021,743132812091007626351
     101  18VT21210002400262000028900,זהב,4,ויזה,4,MAX,NETFLIX.COM            408-724-9160,0,4899,שירותי כבלים
     201   ושרותי טלוויזיה לפי תשלום,,111,עסקה רגילה,32.9,0,ILS,0,0,32.9,ILS,0,1,32.9,0,4,0,0,2,0,1000,רגילה,0
     301  ,0,0,0,0,0,NLD,1,10/01/2001,2107,3196,2,24000.00,833,12,0,6,1,6:11,0,3730 373
MEZAHE_CARD=3.7393236E33 date_TAARICH_BITZUA_ISKA=28/07/2021 date_TAARICH_IBUD_ISKA=30/07/2021 date_TAARICH_CHIUV=.
7                                                          The SAS System                            08:15 Tuesday, October 10, 2023

date_CALC_TRCH=02/08/2021 MEZAHE_TNUA=74313281209100762635118VT21210002400262000028900 MLI_TEUR_SUG_CARD=זהב KOD_CHEVRA=4
TEUR_CARD=ויזה KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=NETFLIX.COM            4 MIS_SOCHER=0 MCC4=4899
SHEM_MCC4=שירותי כבלים ושרותי טלוויזיה לפי תשלום COMPANY_LEGAL_ID=. SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה SCHUM_CHIUV=32.9
MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=32.9 MATBEA_BITZUA_ISKA=ILS ACHUZ_RIBIT=0
IND_ISKAT_CHUL=1 SCHUM_ISKA_MAT_CHUV=32.9 IND_HOCK=0 KOD_SOLECK=4 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 COUNTRY_CODE=NLD WhichFile=1 Date_HITZTARFUT=10/01/2001 month_Nechonut=2107 LAKOACH=3196 groupk_base=2
misg_crd_base=24000 Hativa_base=833 nr_FollowUpMonths=12 Ind_Touch11=0 nr_Months_With_Tnua_CC=6 Ind_HAve_ISkaCC_BaseMon=1
BITZUA_ISKA_TIME=6:11 Ind_Sinun_out=0 MEZAHE_PART=3730 _ERROR_=1 _N_=214
NOTE: Invalid data for date_TAARICH_CHIUV in line 216 58-67.
NOTE: Invalid data for date_CALC_TRCH in line 216 69-78.
NOTE: Invalid data for Date_HITZTARFUT in line 216 336-345.
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
216       3739323631353735353231373632343136,11/06/2021,13/06/2021,15/06/2021,15/06/2021,053261011620057383461
     101  34MT21164003900001047063500,פלטינה,5,מאסטרקארד,4,MAX,"בזק בינלאומי בע""מ-צמרת",8292815,4814,שרותי תק
     201  שורת כולל שיחות רגילות בכרטיסי א,512834896,111,עסקה רגילה,78.78,0,ILS,0,0,78.78,ILS,0,0,78.78,2,3,0,
     301  1,1,0,1000,רגילה,0,0,0,0,0,0,ISR,1,28/04/2006,2106,3196,2,24000.00,833,12,0,6,1,0:48,0,3524 391
MEZAHE_CARD=3.7393236E33 date_TAARICH_BITZUA_ISKA=11/06/2021 date_TAARICH_IBUD_ISKA=13/06/2021 date_TAARICH_CHIUV=. date_CALC_TRCH=.
MEZAHE_TNUA=05326101162005738346134MT21164003900001047063500 MLI_TEUR_SUG_CARD=פלטינה KOD_CHEVRA=5 TEUR_CARD=מאסטרקארד
KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=בזק בינלאומי בע"מ-צמרת MIS_SOCHER=8292815 MCC4=4814
SHEM_MCC4=שרותי תקשורת כולל שיחות רגילות בכרטיסי א COMPANY_LEGAL_ID=512834896 SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה SCHUM_CHIUV=78.78
MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=78.78 MATBEA_BITZUA_ISKA=ILS ACHUZ_RIBIT=0
IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=78.78 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=0 RIBIT_NOTAR=0 **bleep**AT_PERAON=0 SUG_RIBIT=0 SHIUR_RIBIT=0
MIRVACH_PRIME=0 COUNTRY_CODE=ISR WhichFile=1 Date_HITZTARFUT=. month_Nechonut=2106 LAKOACH=3196 groupk_base=2 misg_crd_base=24000
Hativa_base=833 nr_FollowUpMonths=12 Ind_Touch11=0 nr_Months_With_Tnua_CC=6 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=0:48
Ind_Sinun_out=0 MEZAHE_PART=3524 _ERROR_=1 _N_=215
NOTE: Invalid data for date_TAARICH_CHIUV in line 217 58-67.
NOTE: Invalid data for date_CALC_TRCH in line 217 69-78.
NOTE: Invalid data for Date_HITZTARFUT in line 217 296-305.
217       3739323631353735353231373632343136,16/07/2021,18/07/2021,15/08/2021,15/08/2021,751004611991980558021
     101  75MT21202000700001046331700,פלטינה,5,מאסטרקארד,4,MAX,בהדונס החומוס והפול,7556316,5814,מזנוני אוכל מה
     201  יר,24977308,111,עסקה רגילה,49,0,ILS,0,0,49,ILS,0,0,49,0,2,0,0,1,0,1000,רגילה,0,0,0,0,0,0,ISR,1,28/04
     301  /2006,2107,3196,2,24000.00,833,12,0,6,1,10:00,0,3524 352
MEZAHE_CARD=3.7393236E33 date_TAARICH_BITZUA_ISKA=16/07/2021 date_TAARICH_IBUD_ISKA=18/07/2021 date_TAARICH_CHIUV=. date_CALC_TRCH=.
MEZAHE_TNUA=75100461199198055802175MT21202000700001046331700 MLI_TEUR_SUG_CARD=פלטינה KOD_CHEVRA=5 TEUR_CARD=מאסטרקארד
KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=בהדונס החומוס והפול MIS_SOCHER=7556316 MCC4=5814 SHEM_MCC4=מזנוני אוכל מהיר
COMPANY_LEGAL_ID=24977308 SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה SCHUM_CHIUV=49 MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0
MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=49 MATBEA_BITZUA_ISKA=ILS ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=49 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 COUNTRY_CODE=ISR WhichFile=1
Date_HITZTARFUT=. month_Nechonut=2107 LAKOACH=3196 groupk_base=2 misg_crd_base=24000 Hativa_base=833 nr_FollowUpMonths=12
Ind_Touch11=0 nr_Months_With_Tnua_CC=6 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=10:00 Ind_Sinun_out=0 MEZAHE_PART=3524 _ERROR_=1
_N_=216
NOTE: Invalid data for date_TAARICH_CHIUV in line 218 58-67.
NOTE: Invalid data for date_CALC_TRCH in line 218 69-78.
NOTE: Invalid data for Date_HITZTARFUT in line 218 304-313.
218       3739323631353735353231373632343136,25/11/2021,28/11/2021,15/12/2021,15/12/2021,723023313320210094551
     101  61 T21332002131960000000100,פלטינה,5,מאסטרקארד,4,MAX,חנה HAPPINESS,6285449,5699,חנויות תשונות לביגוד
     201   ועזרים,28987733,111,עסקה רגילה,120,0,ILS,0,0,120,ILS,0,0,120,0,1,0,0,1,0,1000,רגילה,0,0,0,0,0,0,ISR
     301  ,1,28/04/2006,2111,3196,2,24000.00,833,12,0,6,1,17:00,0,3524 360
MEZAHE_CARD=3.7393236E33 date_TAARICH_BITZUA_ISKA=25/11/2021 date_TAARICH_IBUD_ISKA=28/11/2021 date_TAARICH_CHIUV=. date_CALC_TRCH=.
MEZAHE_TNUA=72302331332021009455161 T21332002131960000000100 MLI_TEUR_SUG_CARD=פלטינה KOD_CHEVRA=5 TEUR_CARD=מאסטרקארד
KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=חנה HAPPINESS MIS_SOCHER=6285449 MCC4=5699 SHEM_MCC4=חנויות תשונות לביגוד ועזרים
COMPANY_LEGAL_ID=28987733 SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה SCHUM_CHIUV=120 MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0
MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=120 MATBEA_BITZUA_ISKA=ILS ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=120 IND_HOCK=0
KOD_SOLECK=1 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 COUNTRY_CODE=ISR WhichFile=1
8                                                          The SAS System                            08:15 Tuesday, October 10, 2023

Date_HITZTARFUT=. month_Nechonut=2111 LAKOACH=3196 groupk_base=2 misg_crd_base=24000 Hativa_base=833 nr_FollowUpMonths=12
Ind_Touch11=0 nr_Months_With_Tnua_CC=6 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=17:00 Ind_Sinun_out=0 MEZAHE_PART=3524 _ERROR_=1
_N_=217
NOTE: Invalid data for date_TAARICH_CHIUV in line 219 58-67.
NOTE: Invalid data for date_CALC_TRCH in line 219 69-78.
NOTE: Invalid data for Date_HITZTARFUT in line 219 292-301.
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
219       3739323631353735353231373632343136,09/09/2021,12/09/2021,17/09/2021,15/09/2021,751004612522009047067
     101  40MT21255004100001051296400,פלטינה,5,מאסטרקארד,4,MAX,מרכז הזול,1757258,5200,מחסני מוצרי בית,55757377
     201  1,111,עסקה רגילה,58.7,0,ILS,0,0,58.7,ILS,0,0,58.7,0,2,0,1,1,0,1000,רגילה,0,0,0,0,0,0,ISR,1,28/04/200
     301  6,2109,3196,2,24000.00,833,12,0,6,1,15:00,0,3524 348
MEZAHE_CARD=3.7393236E33 date_TAARICH_BITZUA_ISKA=09/09/2021 date_TAARICH_IBUD_ISKA=12/09/2021 date_TAARICH_CHIUV=. date_CALC_TRCH=.
MEZAHE_TNUA=75100461252200904706740MT21255004100001051296400 MLI_TEUR_SUG_CARD=פלטינה KOD_CHEVRA=5 TEUR_CARD=מאסטרקארד
KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=מרכז הזול MIS_SOCHER=1757258 MCC4=5200 SHEM_MCC4=מחסני מוצרי בית
COMPANY_LEGAL_ID=557573771 SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה SCHUM_CHIUV=58.7 MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0
MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=58.7 MATBEA_BITZUA_ISKA=ILS ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=58.7 IND_HOCK=0
KOD_SOLECK=2 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 COUNTRY_CODE=ISR WhichFile=1
Date_HITZTARFUT=. month_Nechonut=2109 LAKOACH=3196 groupk_base=2 misg_crd_base=24000 Hativa_base=833 nr_FollowUpMonths=12
Ind_Touch11=0 nr_Months_With_Tnua_CC=6 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=15:00 Ind_Sinun_out=0 MEZAHE_PART=3524 _ERROR_=1
_N_=218
NOTE: Invalid data for date_TAARICH_CHIUV in line 220 58-67.
NOTE: Invalid data for date_CALC_TRCH in line 220 69-78.
NOTE: Invalid data for Date_HITZTARFUT in line 220 298-307.
220       3739323631353735353231373632343136,31/10/2021,02/11/2021,15/11/2021,15/11/2021,T21306003200209000016
     101  9 T21306003200209000016900,פלטינה,5,מאסטרקארד,4,MAX,דמי כרטיס,5031220,6012,מוסדות פיננסים סחורה ושרו
     201  תים,123456782,111,עסקה רגילה,21,0,ILS,0,0,21,ILS,0,0,21,0,1,0,1,0,0,1000,רגילה,0,0,0,0,0,0,ISR,1,28/
     301  04/2006,2110,3196,2,24000.00,833,12,0,6,1,0:00,0,3524 353
MEZAHE_CARD=3.7393236E33 date_TAARICH_BITZUA_ISKA=31/10/2021 date_TAARICH_IBUD_ISKA=02/11/2021 date_TAARICH_CHIUV=. date_CALC_TRCH=.
MEZAHE_TNUA=T213060032002090000169 T21306003200209000016900 MLI_TEUR_SUG_CARD=פלטינה KOD_CHEVRA=5 TEUR_CARD=מאסטרקארד
KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=דמי כרטיס MIS_SOCHER=5031220 MCC4=6012 SHEM_MCC4=מוסדות פיננסים סחורה ושרותים
COMPANY_LEGAL_ID=123456782 SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה SCHUM_CHIUV=21 MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0
MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=21 MATBEA_BITZUA_ISKA=ILS ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=21 IND_HOCK=0
KOD_SOLECK=1 IND_ISKA_BERUR=0 IND_ISKA_MISMACH_CHASER=1 IND_ISKA_MEULETZET=0 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 COUNTRY_CODE=ISR WhichFile=1
Date_HITZTARFUT=. month_Nechonut=2110 LAKOACH=3196 groupk_base=2 misg_crd_base=24000 Hativa_base=833 nr_FollowUpMonths=12
Ind_Touch11=0 nr_Months_With_Tnua_CC=6 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=0:00 Ind_Sinun_out=0 MEZAHE_PART=3524 _ERROR_=1
_N_=219
NOTE: Invalid data for date_TAARICH_CHIUV in line 221 58-67.
NOTE: Invalid data for date_CALC_TRCH in line 221 69-78.
NOTE: Invalid data for Date_HITZTARFUT in line 221 304-313.
221       3739323631353735353231373632343136,06/09/2021,08/09/2021,17/09/2021,15/09/2021,053261012520084739711
     101  82MT21253002800001057879300,פלטינה,5,מאסטרקארד,4,MAX,עוף הודו ברקת-צמרת,7784002,5411,מכולות וסופרמרק
     201  טים,512834896,111,עסקה רגילה,29.7,0,ILS,0,0,29.7,ILS,0,0,29.7,0,3,0,0,1,0,1000,רגילה,0,0,0,0,0,0,ISR
     301  ,1,28/04/2006,2109,3196,2,24000.00,833,12,0,6,1,11:00,0,3524 360
MEZAHE_CARD=3.7393236E33 date_TAARICH_BITZUA_ISKA=06/09/2021 date_TAARICH_IBUD_ISKA=08/09/2021 date_TAARICH_CHIUV=. date_CALC_TRCH=.
MEZAHE_TNUA=05326101252008473971182MT21253002800001057879300 MLI_TEUR_SUG_CARD=פלטינה KOD_CHEVRA=5 TEUR_CARD=מאסטרקארד
KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=עוף הודו ברקת-צמרת MIS_SOCHER=7784002 MCC4=5411 SHEM_MCC4=מכולות וסופרמרקטים
COMPANY_LEGAL_ID=512834896 SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה SCHUM_CHIUV=29.7 MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0
MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=29.7 MATBEA_BITZUA_ISKA=ILS ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=29.7 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=0 RIBIT_NOTAR=0 **bleep**AT_PERAON=0 SUG_RIBIT=0 SHIUR_RIBIT=0 MIRVACH_PRIME=0 COUNTRY_CODE=ISR WhichFile=1
Date_HITZTARFUT=. month_Nechonut=2109 LAKOACH=3196 groupk_base=2 misg_crd_base=24000 Hativa_base=833 nr_FollowUpMonths=12
Ind_Touch11=0 nr_Months_With_Tnua_CC=6 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=11:00 Ind_Sinun_out=0 MEZAHE_PART=3524 _ERROR_=1
_N_=220
NOTE: Invalid data for date_TAARICH_CHIUV in line 222 58-67.
NOTE: Invalid data for date_CALC_TRCH in line 222 69-78.
NOTE: Invalid data for Date_HITZTARFUT in line 222 305-314.
9                                                          The SAS System                            08:15 Tuesday, October 10, 2023

RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
222       3739323631353735353231373632343136,19/11/2021,21/11/2021,15/12/2021,15/12/2021,T21325003845197000001
     101  0CT21325003845197000001000,פלטינה,5,מאסטרקארד,4,MAX,ZOO PET,6863703,5995,חנויות חיות בית אוכל לחיות 
     201  וציוד,312004062,111,עסקה רגילה,-2.42,0,ILS,0,0,-69,ILS,0,0,-69,0,1,0,1,1,0,1000,רגילה,0,0,0,0,0,0,IS
     301  R,1,28/04/2006,2111,3196,2,24000.00,833,12,0,6,1,13:16,0,3524 361
MEZAHE_CARD=3.7393236E33 date_TAARICH_BITZUA_ISKA=19/11/2021 date_TAARICH_IBUD_ISKA=21/11/2021 date_TAARICH_CHIUV=. date_CALC_TRCH=.
MEZAHE_TNUA=T213250038451970000010CT21325003845197000001000 MLI_TEUR_SUG_CARD=פלטינה KOD_CHEVRA=5 TEUR_CARD=מאסטרקארד
KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=ZOO PET MIS_SOCHER=6863703 MCC4=5995 SHEM_MCC4=חנויות חיות בית אוכל לחיות וציוד
COMPANY_LEGAL_ID=312004062 SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה SCHUM_CHIUV=-2.42 MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0
MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=-69 MATBEA_BITZUA_ISKA=ILS ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=-69 IND_HOCK=0
KOD_SOLECK=1 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 COUNTRY_CODE=ISR WhichFile=1
Date_HITZTARFUT=. month_Nechonut=2111 LAKOACH=3196 groupk_base=2 misg_crd_base=24000 Hativa_base=833 nr_FollowUpMonths=12
Ind_Touch11=0 nr_Months_With_Tnua_CC=6 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=13:16 Ind_Sinun_out=0 MEZAHE_PART=3524 _ERROR_=1
_N_=221
NOTE: Invalid data for date_TAARICH_CHIUV in line 224 58-67.
NOTE: Invalid data for date_CALC_TRCH in line 224 69-78.
NOTE: Invalid data for Date_HITZTARFUT in line 224 283-292.
224       3739323631353735353231373632343136,07/06/2021,09/06/2021,15/06/2021,15/06/2021,053261011590056502101
     101  64MT21160002400001030947100,פלטינה,5,מאסטרקארד,4,MAX,"ע. רמה""ש - וטרינריה",5676150,742,,500226501,1
     201  11,עסקה רגילה,52,0,ILS,0,0,52,ILS,0,0,52,0,3,0,0,1,0,1000,רגילה,0,0,0,0,0,0,ISR,1,28/04/2006,2106,31
     301  96,2,24000.00,833,12,0,6,1,10:00,0,3524 339
MEZAHE_CARD=3.7393236E33 date_TAARICH_BITZUA_ISKA=07/06/2021 date_TAARICH_IBUD_ISKA=09/06/2021 date_TAARICH_CHIUV=. date_CALC_TRCH=.
MEZAHE_TNUA=05326101159005650210164MT21160002400001030947100 MLI_TEUR_SUG_CARD=פלטינה KOD_CHEVRA=5 TEUR_CARD=מאסטרקארד
KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=ע. רמה"ש - וטרינריה MIS_SOCHER=5676150 MCC4=742 SHEM_MCC4=  COMPANY_LEGAL_ID=500226501
SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה SCHUM_CHIUV=52 MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0
SCHUM_ISKA_MAT_MAKOR=52 MATBEA_BITZUA_ISKA=ILS ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=52 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=0
RIBIT_NOTAR=0 **bleep**AT_PERAON=0 SUG_RIBIT=0 SHIUR_RIBIT=0 MIRVACH_PRIME=0 COUNTRY_CODE=ISR WhichFile=1 Date_HITZTARFUT=.
month_Nechonut=2106 LAKOACH=3196 groupk_base=2 misg_crd_base=24000 Hativa_base=833 nr_FollowUpMonths=12 Ind_Touch11=0
nr_Months_With_Tnua_CC=6 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=10:00 Ind_Sinun_out=0 MEZAHE_PART=3524 _ERROR_=1 _N_=223
NOTE: Invalid data for date_TAARICH_CHIUV in line 226 58-67.
NOTE: Invalid data for date_CALC_TRCH in line 226 69-78.
NOTE: Invalid data for Date_HITZTARFUT in line 226 311-320.
226       3739323631353735353231373632343136,19/08/2021,22/08/2021,17/09/2021,15/09/2021,053261012320078693680
     101  73MT21234004400001038923200,פלטינה,5,מאסטרקארד,4,MAX,מאק/קליניק אונליין-גמא,6798565,5977,חנויות קוסמ
     201  טיקה,512711789,111,עסקה רגילה,222.99,0,ILS,0,0,222.99,ILS,0,0,222.99,0,3,0,1,1,0,1000,רגילה,0,0,0,0,
     301  0,0,ISR,1,28/04/2006,2108,3196,2,24000.00,833,12,0,6,1,21:00,0,3524 367
MEZAHE_CARD=3.7393236E33 date_TAARICH_BITZUA_ISKA=19/08/2021 date_TAARICH_IBUD_ISKA=22/08/2021 date_TAARICH_CHIUV=. date_CALC_TRCH=.
MEZAHE_TNUA=05326101232007869368073MT21234004400001038923200 MLI_TEUR_SUG_CARD=פלטינה KOD_CHEVRA=5 TEUR_CARD=מאסטרקארד
KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=מאק/קליניק אונליין-גמא MIS_SOCHER=6798565 MCC4=5977 SHEM_MCC4=חנויות קוסמטיקה
COMPANY_LEGAL_ID=512711789 SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה SCHUM_CHIUV=222.99 MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0
MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=222.99 MATBEA_BITZUA_ISKA=ILS ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=222.99
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=0 RIBIT_NOTAR=0 **bleep**AT_PERAON=0 SUG_RIBIT=0 SHIUR_RIBIT=0 MIRVACH_PRIME=0 COUNTRY_CODE=ISR
WhichFile=1 Date_HITZTARFUT=. month_Nechonut=2108 LAKOACH=3196 groupk_base=2 misg_crd_base=24000 Hativa_base=833
nr_FollowUpMonths=12 Ind_Touch11=0 nr_Months_With_Tnua_CC=6 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=21:00 Ind_Sinun_out=0
MEZAHE_PART=3524 _ERROR_=1 _N_=225
NOTE: Invalid data for date_TAARICH_CHIUV in line 227 58-67.
NOTE: Invalid data for date_CALC_TRCH in line 227 69-78.
NOTE: Invalid data for Date_HITZTARFUT in line 227 323-332.
227       3739323631353735353231373632343136,26/08/2021,29/08/2021,17/09/2021,15/09/2021,053261012390081150217
     101  82MT21241004000001057693300,פלטינה,5,מאסטרקארד,4,MAX,YES די.בי.אס.ש.לווין,2062552,4899,שירותי כבלים 
     201  ושרותי טלוויזיה לפי תשלום,512705138,111,עסקה רגילה,209,0,ILS,0,0,209,ILS,0,0,209,2,3,0,1,1,0,1000,רג
     301  ילה,0,0,0,0,0,0,ISR,1,28/04/2006,2108,3196,2,24000.00,833,12,0,6,1,12:54,0,3524 379
MEZAHE_CARD=3.7393236E33 date_TAARICH_BITZUA_ISKA=26/08/2021 date_TAARICH_IBUD_ISKA=29/08/2021 date_TAARICH_CHIUV=. date_CALC_TRCH=.
MEZAHE_TNUA=05326101239008115021782MT21241004000001057693300 MLI_TEUR_SUG_CARD=פלטינה KOD_CHEVRA=5 TEUR_CARD=מאסטרקארד
KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=YES די.בי.אס.ש.לווין MIS_SOCHER=2062552 MCC4=4899
10                                                         The SAS System                            08:15 Tuesday, October 10, 2023

SHEM_MCC4=שירותי כבלים ושרותי טלוויזיה לפי תשלום COMPANY_LEGAL_ID=512705138 SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה SCHUM_CHIUV=209
MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=209 MATBEA_BITZUA_ISKA=ILS ACHUZ_RIBIT=0
IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=209 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=0 RIBIT_NOTAR=0 **bleep**AT_PERAON=0 SUG_RIBIT=0 SHIUR_RIBIT=0
MIRVACH_PRIME=0 COUNTRY_CODE=ISR WhichFile=1 Date_HITZTARFUT=. month_Nechonut=2108 LAKOACH=3196 groupk_base=2 misg_crd_base=24000
Hativa_base=833 nr_FollowUpMonths=12 Ind_Touch11=0 nr_Months_With_Tnua_CC=6 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=12:54
Ind_Sinun_out=0 MEZAHE_PART=3524 _ERROR_=1 _N_=226
NOTE: Invalid data for date_TAARICH_CHIUV in line 230 58-67.
NOTE: Invalid data for date_CALC_TRCH in line 230 69-78.
NOTE: Invalid data for Date_HITZTARFUT in line 230 306-315.
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
230       3739323631353735353231373632343136,17/09/2021,19/09/2021,15/10/2021,15/10/2021,053261012620087185763
     101  07MT21263005400001050870300,פלטינה,5,מאסטרקארד,4,MAX,משלוחה הזמנת אוכל אונליין,6868277,5814,מזנוני א
     201  וכל מהיר,514570290,111,עסקה רגילה,389,0,ILS,0,0,389,ILS,0,0,389,0,3,0,1,1,0,1000,רגילה,0,0,0,0,0,0,I
     301  SR,1,28/04/2006,2109,3196,2,24000.00,833,12,0,6,1,13:00,0,3524 362
MEZAHE_CARD=3.7393236E33 date_TAARICH_BITZUA_ISKA=17/09/2021 date_TAARICH_IBUD_ISKA=19/09/2021 date_TAARICH_CHIUV=. date_CALC_TRCH=.
MEZAHE_TNUA=05326101262008718576307MT21263005400001050870300 MLI_TEUR_SUG_CARD=פלטינה KOD_CHEVRA=5 TEUR_CARD=מאסטרקארד
KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=משלוחה הזמנת אוכל אונליי MIS_SOCHER=6868277 MCC4=5814 SHEM_MCC4=מזנוני אוכל מהיר
COMPANY_LEGAL_ID=514570290 SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה SCHUM_CHIUV=389 MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0
MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=389 MATBEA_BITZUA_ISKA=ILS ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=389 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=0 RIBIT_NOTAR=0 **bleep**AT_PERAON=0 SUG_RIBIT=0 SHIUR_RIBIT=0 MIRVACH_PRIME=0 COUNTRY_CODE=ISR WhichFile=1
Date_HITZTARFUT=. month_Nechonut=2109 LAKOACH=3196 groupk_base=2 misg_crd_base=24000 Hativa_base=833 nr_FollowUpMonths=12
Ind_Touch11=0 nr_Months_With_Tnua_CC=6 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=13:00 Ind_Sinun_out=0 MEZAHE_PART=3524 _ERROR_=1
_N_=229
NOTE: Invalid data for date_TAARICH_CHIUV in line 232 58-67.
NOTE: Invalid data for date_CALC_TRCH in line 232 69-78.
NOTE: Invalid data for Date_HITZTARFUT in line 232 307-316.
232       3739323631353735353231373632343136,02/11/2021,04/11/2021,15/11/2021,15/11/2021,751004613072036630011
     101  91MT21308003200001085794700,פלטינה,5,מאסטרקארד,4,MAX,"א.ס גלידות רמת השרון בע""מ",9331320,5451,חנויו
     201  ת למוצרי חלב,516325404,111,עסקה רגילה,36,0,ILS,0,0,36,ILS,0,0,36,0,2,0,1,1,0,1000,רגילה,0,0,0,0,0,0,
     301  ISR,1,28/04/2006,2111,3196,2,24000.00,833,12,0,6,1,19:00,0,3524 363
MEZAHE_CARD=3.7393236E33 date_TAARICH_BITZUA_ISKA=02/11/2021 date_TAARICH_IBUD_ISKA=04/11/2021 date_TAARICH_CHIUV=. date_CALC_TRCH=.
MEZAHE_TNUA=75100461307203663001191MT21308003200001085794700 MLI_TEUR_SUG_CARD=פלטינה KOD_CHEVRA=5 TEUR_CARD=מאסטרקארד
KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=א.ס גלידות רמת השרון בע" MIS_SOCHER=9331320 MCC4=5451 SHEM_MCC4=חנויות למוצרי חלב
COMPANY_LEGAL_ID=516325404 SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה SCHUM_CHIUV=36 MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0
MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=36 MATBEA_BITZUA_ISKA=ILS ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=36 IND_HOCK=0
KOD_SOLECK=2 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 COUNTRY_CODE=ISR WhichFile=1
Date_HITZTARFUT=. month_Nechonut=2111 LAKOACH=3196 groupk_base=2 misg_crd_base=24000 Hativa_base=833 nr_FollowUpMonths=12
Ind_Touch11=0 nr_Months_With_Tnua_CC=6 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=19:00 Ind_Sinun_out=0 MEZAHE_PART=3524 _ERROR_=1
_N_=231
NOTE: Invalid data for date_TAARICH_CHIUV in line 234 58-67.
NOTE: Invalid data for date_CALC_TRCH in line 234 69-78.
NOTE: Invalid data for Date_HITZTARFUT in line 234 306-315.
234       3739323631353735353231373632343136,23/09/2021,26/09/2021,15/10/2021,15/10/2021,053261012670088934905
     101  43MT21269004100001043124800,פלטינה,5,מאסטרקארד,4,MAX,החברה להגנת הטבע,3660107,4722,סוכניות נסיעות+מפ
     201  עילי טיולים,580017499,111,עסקה רגילה,16,0,ILS,0,0,16,ILS,0,0,16,2,3,0,1,1,0,1000,רגילה,0,0,0,0,0,0,I
     301  SR,1,28/04/2006,2109,3196,2,24000.00,833,12,0,6,1,16:00,0,3524 362
MEZAHE_CARD=3.7393236E33 date_TAARICH_BITZUA_ISKA=23/09/2021 date_TAARICH_IBUD_ISKA=26/09/2021 date_TAARICH_CHIUV=. date_CALC_TRCH=.
MEZAHE_TNUA=05326101267008893490543MT21269004100001043124800 MLI_TEUR_SUG_CARD=פלטינה KOD_CHEVRA=5 TEUR_CARD=מאסטרקארד
KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=החברה להגנת הטבע MIS_SOCHER=3660107 MCC4=4722 SHEM_MCC4=סוכניות נסיעות+מפעילי טיולים
COMPANY_LEGAL_ID=580017499 SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה SCHUM_CHIUV=16 MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0
MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=16 MATBEA_BITZUA_ISKA=ILS ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=16 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=0 RIBIT_NOTAR=0 **bleep**AT_PERAON=0 SUG_RIBIT=0 SHIUR_RIBIT=0 MIRVACH_PRIME=0 COUNTRY_CODE=ISR WhichFile=1
Date_HITZTARFUT=. month_Nechonut=2109 LAKOACH=3196 groupk_base=2 misg_crd_base=24000 Hativa_base=833 nr_FollowUpMonths=12
Ind_Touch11=0 nr_Months_With_Tnua_CC=6 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=16:00 Ind_Sinun_out=0 MEZAHE_PART=3524 _ERROR_=1
11                                                         The SAS System                            08:15 Tuesday, October 10, 2023

_N_=233
NOTE: Invalid data for date_TAARICH_CHIUV in line 235 58-67.
NOTE: Invalid data for date_CALC_TRCH in line 235 69-78.
NOTE: Invalid data for Date_HITZTARFUT in line 235 278-287.
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
235       3739323631353735353231373632343136,29/09/2021,01/10/2021,15/10/2021,15/10/2021,723023312740170048878
     101  20 T21274001722591000001500,פלטינה,5,מאסטרקארד,4,MAX,פלאפל דגניה,6033203,5812,מסעדות,40661845,111,עס
     201  קה רגילה,20,0,ILS,0,0,20,ILS,0,0,20,0,1,0,0,1,0,1000,רגילה,0,0,0,0,0,0,ISR,1,28/04/2006,2109,3196,2,
     301  24000.00,833,12,0,6,1,12:00,0,3524 334
MEZAHE_CARD=3.7393236E33 date_TAARICH_BITZUA_ISKA=29/09/2021 date_TAARICH_IBUD_ISKA=01/10/2021 date_TAARICH_CHIUV=. date_CALC_TRCH=.
MEZAHE_TNUA=72302331274017004887820 T21274001722591000001500 MLI_TEUR_SUG_CARD=פלטינה KOD_CHEVRA=5 TEUR_CARD=מאסטרקארד
KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=פלאפל דגניה MIS_SOCHER=6033203 MCC4=5812 SHEM_MCC4=מסעדות COMPANY_LEGAL_ID=40661845
SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה 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=1
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 COUNTRY_CODE=ISR WhichFile=1 Date_HITZTARFUT=.
month_Nechonut=2109 LAKOACH=3196 groupk_base=2 misg_crd_base=24000 Hativa_base=833 nr_FollowUpMonths=12 Ind_Touch11=0
nr_Months_With_Tnua_CC=6 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=12:00 Ind_Sinun_out=0 MEZAHE_PART=3524 _ERROR_=1 _N_=234
NOTE: Invalid data for date_TAARICH_CHIUV in line 237 58-67.
NOTE: Invalid data for date_CALC_TRCH in line 237 69-78.
NOTE: Invalid data for Date_HITZTARFUT in line 237 301-310.
WARNING: Limit set by ERRORS= option reached.  Further errors of this type will not be printed.
237       3739323631353735353231373632343136,24/09/2021,26/09/2021,15/10/2021,15/10/2021,723023312690370038042
     101  01 T21269003715771000000600,פלטינה,5,מאסטרקארד,4,MAX,בס רמת השרון,5881602,5699,חנויות תשונות לביגוד 
     201  ועזרים,514277656,111,עסקה רגילה,98,0,ILS,0,0,98,ILS,0,0,98,0,1,0,0,1,0,1000,רגילה,0,0,0,0,0,0,ISR,1,
     301  28/04/2006,2109,3196,2,24000.00,833,12,0,6,1,10:34,0,3524 357
MEZAHE_CARD=3.7393236E33 date_TAARICH_BITZUA_ISKA=24/09/2021 date_TAARICH_IBUD_ISKA=26/09/2021 date_TAARICH_CHIUV=. date_CALC_TRCH=.
MEZAHE_TNUA=72302331269037003804201 T21269003715771000000600 MLI_TEUR_SUG_CARD=פלטינה KOD_CHEVRA=5 TEUR_CARD=מאסטרקארד
KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=בס רמת השרון MIS_SOCHER=5881602 MCC4=5699 SHEM_MCC4=חנויות תשונות לביגוד ועזרים
COMPANY_LEGAL_ID=514277656 SUG_ISKA=111 TEURSUG_ISKA=עסקה רגילה SCHUM_CHIUV=98 MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0
MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=98 MATBEA_BITZUA_ISKA=ILS ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=98 IND_HOCK=0
KOD_SOLECK=1 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 COUNTRY_CODE=ISR WhichFile=1
Date_HITZTARFUT=. month_Nechonut=2109 LAKOACH=3196 groupk_base=2 misg_crd_base=24000 Hativa_base=833 nr_FollowUpMonths=12
Ind_Touch11=0 nr_Months_With_Tnua_CC=6 Ind_HAve_ISkaCC_BaseMon=1 BITZUA_ISKA_TIME=10:34 Ind_Sinun_out=0 MEZAHE_PART=3524 _ERROR_=1
_N_=236
NOTE: 1000 records were read from the infile COPY.
      The minimum record length was 315.
      The maximum record length was 394.
NOTE: The data set WORK.IMPORT_BACK_DATA_SET has 1000 observations and 57 variables.
NOTE: Compressing data set WORK.IMPORT_BACK_DATA_SET decreased size by 33.33 percent. 
      Compressed is 6 pages; un-compressed would require 9 pages.
NOTE: DATA statement used (Total process time):
      real time           0.03 seconds
      user cpu time       0.02 seconds
      system cpu time     0.01 seconds
      memory              11206.40k
      OS Memory           37652.00k
      Timestamp           10/10/2023 10:08:19 AM
      Step Count                        36  Switch Count  2
      Page Faults                       0
      Page Reclaims                     112
      Page Swaps                        0
      Voluntary Context Switches        22
      Involuntary Context Switches      0
      Block Input Operations            0
      Block Output Operations           0
      
12                                                         The SAS System                            08:15 Tuesday, October 10, 2023


Errors detected in submitted DATA step. Examine log.
1000 rows created in WORK.IMPORT_BACK_DATA_SET from COPY.
  
  
  
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           0.26 seconds
      user cpu time       0.10 seconds
      system cpu time     0.02 seconds
      memory              11206.40k
      OS Memory           38040.00k
      Timestamp           10/10/2023 10:08:19 AM
      Step Count                        36  Switch Count  10
      Page Faults                       0
      Page Reclaims                     1734
      Page Swaps                        0
      Voluntary Context Switches        192
      Involuntary Context Switches      0
      Block Input Operations            0
      Block Output Operations           0
      
224        
225        GOPTIONS NOACCESSIBLE;
226        %LET _CLIENTTASKLABEL=;
227        %LET _CLIENTPROCESSFLOWNAME=;
228        %LET _CLIENTPROJECTPATH=;
229        %LET _CLIENTPROJECTPATHHOST=;
230        %LET _CLIENTPROJECTNAME=;
231        %LET _SASPROGRAMFILE=;
232        %LET _SASPROGRAMFILEHOST=;
233        
234        ;*';*";*/;quit;run;
235        ODS _ALL_ CLOSE;
236        
237        
238        QUIT; RUN;
239

Kurt_Bremser · Posted 10-10-2023 03:33 AM

See this inconsistency with the date informats:

50                informat date_TAARICH_BITZUA_ISKA ddmmyy10. ;
51                informat date_TAARICH_IBUD_ISKA ddmmyy10. ;
52                informat date_TAARICH_CHIUV mmddyy10. ;
53                informat date_CALC_TRCH mmddyy10. ;

As far as I see, all your dates are in DMY order.

Copy the automatically created DATA step from the log, and change the informats and formats.

You can avoid such problems by using YMD formats for dates everywhere. YYMMDD10. prints all dates in the ISO standard format, which is unambiguous.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

Ronein · Posted 10-10-2023 05:14 AM

I dont understand what action is required from me in order to have the ability to import back the file into data set and see the dates fields with correct values and not null?

I changed the format of the date fields and then export and then import and results are same (dates fields with null values)

Data RON;
set LS.lightSolver_sofi(obs=1000);
format 
date_TAARICH_BITZUA_ISKA
date_TAARICH_IBUD_ISKA
date_TAARICH_CHIUV
date_CALC_TRCH
yymmdd10.;
Run;

Tom · Posted 10-10-2023 08:37 AM

When you write a CSV file only the VALUES (actually the values converted to text using the attached, or default, formats) are written to the file. Unlike a SAS dataset a CSV file has not place to store METADATA about the variables. The only thing it has is the optional header line that can be used as a hint for what NAMES to use for the variables. There is nothing in the CSV file that indicates the TYPE or the LENGTH of the variable. Or what type of INFORMAT to use to read the values. Or whether a FORMAT should be attached to the variable.

So when reading back in the file YOU will have to provide the knowledge about the variables to be able to set the TYPE and LENGTH and whether or not to attach a FORMAT or use a special INFORMAT.

If you ask PROC IMPORT to GUESS how to define the variables then it will do a better job of guessing if you add the GUESSINGROWS=MAX statement to the PROC IMPORT step. That way it will check the whole file before deciding how to read each variable. That should solve the invalid data type issues.

But it could still get confused about whether date strings are in MDY or DMY order. For example consider the case where your date variable values were written using the MMDDYY10. format, but for all of the values the day of the month is less than 13. Then SAS could either guess to use MMDDYY or DDMMYY informat to read the values since either one will generate valid date values for all of the observations.

Ronein · Posted 10-10-2023 12:19 PM

But I didnt use proc import .

I used the following code to import and I defined length as was in the original data set (before I exported it).

My question is what change should be done in my code in order to import it correctly?

libname LS '/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/';
filename SOFI zip "/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/RRR1.zip" member="RRR1.CSV";
data Import_Back_Data_Set;
infile SOFI dsd truncover firstobs=2;
Length 
MEZAHE_CARD $   200
date_TAARICH_BITZUA_ISKA  8
date_TAARICH_IBUD_ISKA  8
date_TAARICH_CHIUV  8
date_CALC_TRCH  8
MEZAHE_TNUA  $  48
MLI_TEUR_SUG_CARD $  12
KOD_CHEVRA  8
TEUR_CARD $  9
KOD_CHEVRA_GLOBAL  8
CHEVRA $  3
SHEM_SOCHER $  39
MIS_SOCHER  8
MCC4  8
SHEM_MCC4  $ 40
COMPANY_LEGAL_ID  8
SUG_ISKA  8
TEURSUG_ISKA  $ 25
SCHUM_CHIUV  8
MIS_TASH_NOCH  8
MATBEA_CHIUV $   3
MIS_TASH_MEK  8
MIS_TASH_NOTRU  8
SCHUM_ISKA_MAT_MAKOR  8
MATBEA_BITZUA_ISKA  $ 3
ACHUZ_RIBIT  8
IND_ISKAT_CHUL  8
SCHUM_ISKA_MAT_CHUV  8
IND_HOCK  8
KOD_SOLECK  8
IND_ISKA_BERUR  8
IND_ISKA_MISMACH_CHASER  8
IND_ISKA_MEULETZET  8
IND_HALVAA  8
SUG_PLAN  8
TEUR_SUG_TOCHNIT  $ 18
MAHUT_KARTIS $  1
RIBIT_NOTAR  8
**bleep**AT_PERAON  8
SUG_RIBIT  8
SHIUR_RIBIT  8
MIRVACH_PRIME  8
COUNTRY_CODE  $ 3
WhichFile  8
Date_HITZTARFUT  8
month_Nechonut  8
LAKOACH  8
groupk_base  8
misg_crd_base  8
Hativa_base  8
nr_FollowUpMonths  8
Ind_Touch11  8
nr_Months_With_Tnua_CC  8
Ind_HAve_ISkaCC_BaseMon  8
BITZUA_ISKA_TIME  8
Ind_Sinun_out  8
MEZAHE_PART  $ 200
;
input 
MEZAHE_CARD
date_TAARICH_BITZUA_ISKA
date_TAARICH_IBUD_ISKA
date_TAARICH_CHIUV
date_CALC_TRCH
MEZAHE_TNUA
MLI_TEUR_SUG_CARD
KOD_CHEVRA
TEUR_CARD
KOD_CHEVRA_GLOBAL
CHEVRA
SHEM_SOCHER
MIS_SOCHER
MCC4
SHEM_MCC4
COMPANY_LEGAL_ID
SUG_ISKA
TEURSUG_ISKA
SCHUM_CHIUV
MIS_TASH_NOCH
MATBEA_CHIUV
MIS_TASH_MEK
MIS_TASH_NOTRU
SCHUM_ISKA_MAT_MAKOR
MATBEA_BITZUA_ISKA
ACHUZ_RIBIT
IND_ISKAT_CHUL
SCHUM_ISKA_MAT_CHUV
IND_HOCK
KOD_SOLECK
IND_ISKA_BERUR
IND_ISKA_MISMACH_CHASER
IND_ISKA_MEULETZET
IND_HALVAA
SUG_PLAN
TEUR_SUG_TOCHNIT
MAHUT_KARTIS
RIBIT_NOTAR
**bleep**AT_PERAON
SUG_RIBIT
SHIUR_RIBIT
MIRVACH_PRIME
COUNTRY_CODE
WhichFile
Date_HITZTARFUT
month_Nechonut
LAKOACH
groupk_base
misg_crd_base
Hativa_base
nr_FollowUpMonths
Ind_Touch11
nr_Months_With_Tnua_CC
Ind_HAve_ISkaCC_BaseMon
BITZUA_ISKA_TIME
Ind_Sinun_out
MEZAHE_PART
;
run;

Tom · Posted 10-10-2023 12:27 PM

The answer is the same.

Add the appropriate INFORMAT and FORMAT statements to your data step that is READING the data in.

For the variables that have values that NEED them you must use an INFORMAT to read the values from the CSV. For the variables that have values that NEED them you must attach a FORMAT to the variable so the values will display in a way humans can understand.

PS Don't use the word "import' for the process of creating a dataset from a source text file. That is just READing the data. Using IMPORT to describe that process implies that you want to use some type of guessing process that PROC IMPORT uses.

Kurt_Bremser · Posted 10-10-2023 01:42 PM

@Ronein wrote:

But I didnt use proc import .

I used the following code to import and I defined length as was in the original data set (before I exported it).

My question is what change should be done in my code in order to import it correctly?

Please read my posts. Use an informat.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

Re: export to ZIP TXT and then import

Re: export to ZIP TXT and then import

Re: export to ZIP TXT and then import

Re: export to ZIP TXT and then import

Re: export to ZIP TXT and then import

Re: export to ZIP TXT and then import

Re: export to ZIP TXT and then import

Re: export to ZIP TXT and then import

Re: export to ZIP TXT and then import

Re: export to ZIP TXT and then import

Re: export to ZIP TXT and then import

Re: export to ZIP TXT and then import

Re: export to ZIP TXT and then import

2025 SAS Hackathon: There is still time!

SAS Training: Just a Click Away