topic Re: EXPORT SAS DATA SET INTO ZIP CSV --- in SAS Programming

EXPORT SAS DATA SET INTO ZIP CSV ---

Ronein — Tue, 10 Oct 2023 05:40:49 GMT

Hello

I used following code to export SAS data set into ZIP CSV file.

Please note that the created file has end .CSV and not .TXT

Please note that the real data set has 250 million rows but here I created smaller data set in order to have the ability to open the csv file in EXCEL and look at the values.

My questions:

Question1

In the SAS data set field MEZAHE_CARD is char and have length of 200.

Example for value is :323433323530343535353231373636333034

But in the CSV file the value is 3.23433E+35

What is the way that in CSV file I will see the value 323433323530343535353231373636333034 and not 3.23433E+35


Data RON;
set LS.lightSolver_sofi(obs=1000);
Run;


/*************EXPORT into ZIP CSV FILE*****************/
/***STEP1***/
/*First make a fileref that points to the member in the ZIP file you want write to (or read from)*/
filename SOFI zip "/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/RRR.zip" member="RRR.CSV";

/***STEP2-Export data set LS.lightSolver_sofi into ZIP TXT the file***/
/*To make a proper delimited file you need to use the DSD option*/
/*Otherwise SAS will not write  the null values and values that contain the delimiter properly*/
libname LS '/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/';
data _null_;
set RON;
file SOFI dsd ;
if _n_=1 then 
put  ' List_Of_VARS';
put   List_of_Vars
;
run;

Question2

Let's say that I want to import back the ZIP CSV file into sas data set.

First I look at variables attributes in the original sas data set

Then I applied these attributes in the Length statement

Then I receive error that I applied char format to numeric format.

But these vars are char in the original data set......

Here is the Log and after is the code I used to import back

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

1          ;*';*";*/;quit;run;
2          OPTIONS PAGENO=MIN;
3          %LET _CLIENTTASKLABEL='Program';
4          %LET _CLIENTPROCESSFLOWNAME='Process Flow';
5          %LET _CLIENTPROJECTPATH='';
6          %LET _CLIENTPROJECTPATHHOST='';
7          %LET _CLIENTPROJECTNAME='';
8          %LET _SASPROGRAMFILE='';
9          %LET _SASPROGRAMFILEHOST='';
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
54         MATBEA_BITZUA_ISKA
2                                                          The SAS System                            08:15 Tuesday, October 10, 2023

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         Length
89         MEZAHE_CARD $   200
90         date_TAARICH_BITZUA_ISKA  8
ERROR: Character length cannot be used with numeric variable MEZAHE_CARD.
91         date_TAARICH_IBUD_ISKA  8
92         date_TAARICH_CHIUV  8
93         date_CALC_TRCH  8
94         MEZAHE_TNUA  $  48
95         MLI_TEUR_SUG_CARD $  12
ERROR: Character length cannot be used with numeric variable MEZAHE_TNUA.
96         KOD_CHEVRA  8
ERROR: Character length cannot be used with numeric variable MLI_TEUR_SUG_CARD.
97         TEUR_CARD $  9
98         KOD_CHEVRA_GLOBAL  8
ERROR: Character length cannot be used with numeric variable TEUR_CARD.
99         CHEVRA $  3
100        SHEM_SOCHER $  39
ERROR: Character length cannot be used with numeric variable CHEVRA.
101        MIS_SOCHER  8
ERROR: Character length cannot be used with numeric variable SHEM_SOCHER.
102        MCC4  8
103        SHEM_MCC4  $ 40
104        COMPANY_LEGAL_ID  8
ERROR: Character length cannot be used with numeric variable SHEM_MCC4.
105        SUG_ISKA  8
3                                                          The SAS System                            08:15 Tuesday, October 10, 2023

106        TEURSUG_ISKA  $ 25
107        SCHUM_CHIUV  8
ERROR: Character length cannot be used with numeric variable TEURSUG_ISKA.
108        MIS_TASH_NOCH  8
109        MATBEA_CHIUV $   3
110        MIS_TASH_MEK  8
ERROR: Character length cannot be used with numeric variable MATBEA_CHIUV.
111        MIS_TASH_NOTRU  8
112        SCHUM_ISKA_MAT_MAKOR  8
113        MATBEA_BITZUA_ISKA  $ 3
114        ACHUZ_RIBIT  8
ERROR: Character length cannot be used with numeric variable MATBEA_BITZUA_ISKA.
115        IND_ISKAT_CHUL  8
116        SCHUM_ISKA_MAT_CHUV  8
117        IND_HOCK  8
118        KOD_SOLECK  8
119        IND_ISKA_BERUR  8
120        IND_ISKA_MISMACH_CHASER  8
121        IND_ISKA_MEULETZET  8
122        IND_HALVAA  8
123        SUG_PLAN  8
124        TEUR_SUG_TOCHNIT  $ 18
125        MAHUT_KARTIS $  1
ERROR: Character length cannot be used with numeric variable TEUR_SUG_TOCHNIT.
126        RIBIT_NOTAR  8
ERROR: Character length cannot be used with numeric variable MAHUT_KARTIS.
127        **bleep**AT_PERAON  8
128        SUG_RIBIT  8
129        SHIUR_RIBIT  8
130        MIRVACH_PRIME  8
131        COUNTRY_CODE  $ 3
132        WhichFile  8
ERROR: Character length cannot be used with numeric variable COUNTRY_CODE.
133        Date_HITZTARFUT  8
134        month_Nechonut  8
135        LAKOACH  8
136        groupk_base  8
137        misg_crd_base  8
138        Hativa_base  8
139        nr_FollowUpMonths  8
140        Ind_Touch11  8
141        nr_Months_With_Tnua_CC  8
142        Ind_HAve_ISkaCC_BaseMon  8
143        BITZUA_ISKA_TIME  8
144        Ind_Sinun_out  8
145        MEZAHE_PART  $ 200
146        ;
ERROR: Character length cannot be used with numeric variable MEZAHE_PART.
147        run;

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.AAA may be incomplete.  When this step was stopped there were 0 observations and 57 variables.
WARNING: Data set WORK.AAA was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
      real time           0.02 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              492.50k
4                                                          The SAS System                            08:15 Tuesday, October 10, 2023

      OS Memory           24736.00k
      Timestamp           10/10/2023 08:37:22 AM
      Step Count                        10  Switch Count  0
      Page Faults                       0
      Page Reclaims                     39
      Page Swaps                        0
      Voluntary Context Switches        19
      Involuntary Context Switches      0
      Block Input Operations            0
      Block Output Operations           0
      

148        
149        GOPTIONS NOACCESSIBLE;
150        %LET _CLIENTTASKLABEL=;
151        %LET _CLIENTPROCESSFLOWNAME=;
152        %LET _CLIENTPROJECTPATH=;
153        %LET _CLIENTPROJECTPATHHOST=;
154        %LET _CLIENTPROJECTNAME=;
155        %LET _SASPROGRAMFILE=;
156        %LET _SASPROGRAMFILEHOST=;
157        
158        ;*';*";*/;quit;run;
159        ODS _ALL_ CLOSE;
160        
161        
162        QUIT; RUN;
163

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
;
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
;
run;

Re: EXPORT SAS DATA SET INTO ZIP CSV ---

andreas_lds — Tue, 10 Oct 2023 06:02:45 GMT

The length statement is misplaced, move it before the input statement.

Re: EXPORT SAS DATA SET INTO ZIP CSV ---

Kurt_Bremser — Tue, 10 Oct 2023 06:06:06 GMT

NEVER inspect a csv file with Excel. NEVER.

Excel tries to make sense of the data in its own context, and a string consisting of digits will be read as a number. What Excel shows you is often not what is really contained in the file.

Use a proper programmer's text editor (I prefer Notepad++) to check text files containing tabular data.

Re: EXPORT SAS DATA SET INTO ZIP CSV ---

Ronein — Tue, 10 Oct 2023 06:21:08 GMT

Should I apply Length statement also in export or only in Import or in both?

Here is the export code

Data RON;
set LS.lightSolver_sofi(obs=1000);
Run;

filename SOFI zip "/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/RRR.zip" member="RRR.CSV";

libname LS '/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/';
data _null_;
set RON;
file SOFI dsd ;
if _n_=1 then 
put 
'VAR_LIST';
put 
VAR_LIST
;
run;

Here is the import code

libname LS '/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/';
data AAA;
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
and so on
;
input 
MEZAHE_CARD
date_TAARICH_BITZUA_ISKA
date_TAARICH_IBUD_ISKA
date_TAARICH_CHIUV
date_CALC_TRCH
MEZAHE_TNUA
and so on
;
run;

Re: EXPORT SAS DATA SET INTO ZIP CSV ---

Ronein — Tue, 10 Oct 2023 07:27:52 GMT

Okay,I applied what was told me to do.

However ,the import step didnt work well.

The dates columns have null values . why????


libname LS '/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/';

Data RON;
set LS.lightSolver_sofi(obs=1000);
Run;

/*************EXPORT into ZIP CSV FILE*****************/
/*************EXPORT into ZIP CSV FILE*****************/
/*************EXPORT into ZIP CSV FILE*****************/
/***STEP1***/
/*First make a fileref that points to the member in the ZIP file you want write to (or read from)*/
filename SOFI zip "/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/RRR.zip" member="RRR.CSV";

/***STEP2-Export data set LS.lightSolver_sofi into ZIP TXT the file***/
/*To make a proper delimited file you need to use the DSD option*/
/*Otherwise SAS will not write  the null values and values that contain the delimiter properly*/
/* length statement MUST Be  before the input statemen*/
libname LS '/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/';
data _null_;
set RON;
file SOFI dsd ;
if _n_=1 then 
put 
'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
';
put 
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;

 

/**************Import back the zip CSV file into sas data set*****************/
/**************Import back the zip CSV file into sas data set*****************/
/**************Import back the zip CSV file into sas data set*****************/
/**************Import back the zip CSV file into sas data set*****************/
/*When you read the file back, you have to use the same variable attributes (type length, format)which you have in the original dataset*/
/* length statement MUST Be  before the input statemen*/
libname LS '/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/';
filename SOFI zip "/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/RRR.zip" member="RRR.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;

Here is the Log of the IMPORT STEP.

As you can see the dates columns have null values and it is wrong.

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

1          ;*';*";*/;quit;run;
2          OPTIONS PAGENO=MIN;
3          %LET _CLIENTTASKLABEL='Program (2)';
4          %LET _CLIENTPROCESSFLOWNAME='Process Flow';
5          %LET _CLIENTPROJECTPATH='';
6          %LET _CLIENTPROJECTPATHHOST='';
7          %LET _CLIENTPROJECTNAME='';
8          %LET _SASPROGRAMFILE='';
9          %LET _SASPROGRAMFILEHOST='';
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/RRR.zip" member="RRR.CSV";
28         data Import_Back_Data_Set;
29         infile SOFI dsd truncover firstobs=2;
30         Length
31         MEZAHE_CARD $   200
32         date_TAARICH_BITZUA_ISKA  8
33         date_TAARICH_IBUD_ISKA  8
34         date_TAARICH_CHIUV  8
35         date_CALC_TRCH  8
36         MEZAHE_TNUA  $  48
37         MLI_TEUR_SUG_CARD $  12
38         KOD_CHEVRA  8
39         TEUR_CARD $  9
40         KOD_CHEVRA_GLOBAL  8
41         CHEVRA $  3
42         SHEM_SOCHER $  39
43         MIS_SOCHER  8
44         MCC4  8
45         SHEM_MCC4  $ 40
46         COMPANY_LEGAL_ID  8
47         SUG_ISKA  8
48         TEURSUG_ISKA  $ 25
49         SCHUM_CHIUV  8
50         MIS_TASH_NOCH  8
51         MATBEA_CHIUV $   3
52         MIS_TASH_MEK  8
53         MIS_TASH_NOTRU  8
54         SCHUM_ISKA_MAT_MAKOR  8
2                                                          The SAS System                            08:15 Tuesday, October 10, 2023

55         MATBEA_BITZUA_ISKA  $ 3
56         ACHUZ_RIBIT  8
57         IND_ISKAT_CHUL  8
58         SCHUM_ISKA_MAT_CHUV  8
59         IND_HOCK  8
60         KOD_SOLECK  8
61         IND_ISKA_BERUR  8
62         IND_ISKA_MISMACH_CHASER  8
63         IND_ISKA_MEULETZET  8
64         IND_HALVAA  8
65         SUG_PLAN  8
66         TEUR_SUG_TOCHNIT  $ 18
67         MAHUT_KARTIS $  1
68         RIBIT_NOTAR  8
69         **bleep**AT_PERAON  8
70         SUG_RIBIT  8
71         SHIUR_RIBIT  8
72         MIRVACH_PRIME  8
73         COUNTRY_CODE  $ 3
74         WhichFile  8
75         Date_HITZTARFUT  8
76         month_Nechonut  8
77         LAKOACH  8
78         groupk_base  8
79         misg_crd_base  8
80         Hativa_base  8
81         nr_FollowUpMonths  8
82         Ind_Touch11  8
83         nr_Months_With_Tnua_CC  8
84         Ind_HAve_ISkaCC_BaseMon  8
85         BITZUA_ISKA_TIME  8
86         Ind_Sinun_out  8
87         MEZAHE_PART  $ 200
88         ;
89         input
90         MEZAHE_CARD
91         date_TAARICH_BITZUA_ISKA
92         date_TAARICH_IBUD_ISKA
93         date_TAARICH_CHIUV
94         date_CALC_TRCH
95         MEZAHE_TNUA
96         MLI_TEUR_SUG_CARD
97         KOD_CHEVRA
98         TEUR_CARD
99         KOD_CHEVRA_GLOBAL
100        CHEVRA
101        SHEM_SOCHER
102        MIS_SOCHER
103        MCC4
104        SHEM_MCC4
105        COMPANY_LEGAL_ID
106        SUG_ISKA
107        TEURSUG_ISKA
108        SCHUM_CHIUV
109        MIS_TASH_NOCH
110        MATBEA_CHIUV
111        MIS_TASH_MEK
112        MIS_TASH_NOTRU
3                                                          The SAS System                            08:15 Tuesday, October 10, 2023

113        SCHUM_ISKA_MAT_MAKOR
114        MATBEA_BITZUA_ISKA
115        ACHUZ_RIBIT
116        IND_ISKAT_CHUL
117        SCHUM_ISKA_MAT_CHUV
118        IND_HOCK
119        KOD_SOLECK
120        IND_ISKA_BERUR
121        IND_ISKA_MISMACH_CHASER
122        IND_ISKA_MEULETZET
123        IND_HALVAA
124        SUG_PLAN
125        TEUR_SUG_TOCHNIT
126        MAHUT_KARTIS
127        RIBIT_NOTAR
128        **bleep**AT_PERAON
129        SUG_RIBIT
130        SHIUR_RIBIT
131        MIRVACH_PRIME
132        COUNTRY_CODE
133        WhichFile
134        Date_HITZTARFUT
135        month_Nechonut
136        LAKOACH
137        groupk_base
138        misg_crd_base
139        Hativa_base
140        nr_FollowUpMonths
141        Ind_Touch11
142        nr_Months_With_Tnua_CC
143        Ind_HAve_ISkaCC_BaseMon
144        BITZUA_ISKA_TIME
145        Ind_Sinun_out
146        MEZAHE_PART
147        ;
148        run;

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

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 Date_HITZTARFUT in line 2 294-303.
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=323433323530343535353231373636333034 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=.
date_CALC_TRCH=. MEZAHE_TNUA=05326101297000761601461MT21298002700001059768400 MLI_TEUR_SUG_CARD=פלטינה KOD_CHEVRA=5
TEUR_CARD=מאסטרקארד KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX 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=ILS
4                                                          The SAS System                            08:15 Tuesday, October 10, 2023

MIS_TASH_MEK=0 MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=46 MATBEA_BITZUA_ISKA=ILS 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=ISR
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 Date_HITZTARFUT in line 3 305-314.
NOTE: Invalid data for BITZUA_ISKA_TIME in line 3 349-353.
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
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=323433323530343535353231373636333034 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=.
date_CALC_TRCH=. MEZAHE_TNUA=05326101298000782125978MT21299003300001029920100 MLI_TEUR_SUG_CARD=פלטינה KOD_CHEVRA=5
TEUR_CARD=מאסטרקארד KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX 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=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=66 MATBEA_BITZUA_ISKA=ILS 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=ISR 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 Date_HITZTARFUT in line 4 300-309.
NOTE: Invalid data for BITZUA_ISKA_TIME in line 4 344-347.
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=323433323530343535353231373636333034 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=.
date_CALC_TRCH=. MEZAHE_TNUA=T213360032002230001045 T21336003200223000104500 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=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 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=323433323530343535353231373636333034 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=.
date_CALC_TRCH=. MEZAHE_TNUA=05326101304001047870905MT21305003000001062179400 MLI_TEUR_SUG_CARD=פלטינה KOD_CHEVRA=5
5                                                          The SAS System                            08:15 Tuesday, October 10, 2023

TEUR_CARD=מאסטרקארד KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX 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=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=210 MATBEA_BITZUA_ISKA=ILS 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=ISR 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 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=323433323530343535353231373636333034 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=.
date_CALC_TRCH=. MEZAHE_TNUA=05326101329001738639552MT21330003100001043062800 MLI_TEUR_SUG_CARD=פלטינה KOD_CHEVRA=5
TEUR_CARD=מאסטרקארד KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX 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=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=159.18
MATBEA_BITZUA_ISKA=ILS 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=ISR 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 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=323433323530343535353231373636333034 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=.
date_CALC_TRCH=. MEZAHE_TNUA=T213060032002180000746 T21306003200218000074600 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=8.8
MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=8.8 MATBEA_BITZUA_ISKA=ILS 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=ISR 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 Date_HITZTARFUT in line 8 303-312.
NOTE: Invalid data for BITZUA_ISKA_TIME in line 8 347-350.
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,
6                                                          The SAS System                            08:15 Tuesday, October 10, 2023

RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
     301  1,01/11/2002,2110,3188,2,7500.00,833,12,0,2,1,0:00,0,7426 357
MEZAHE_CARD=323433323530343535353231373636333034 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=.
date_CALC_TRCH=. MEZAHE_TNUA=T213060032002180000745 T21306003200218000074500 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=2.7
MIS_TASH_NOCH=0 MATBEA_CHIUV=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=2.7 MATBEA_BITZUA_ISKA=ILS 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=ISR 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 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=323433323530343535353231373636333034 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=.
date_CALC_TRCH=. MEZAHE_TNUA=05326101319001448547972MT21320003800001044381900 MLI_TEUR_SUG_CARD=פלטינה KOD_CHEVRA=5
TEUR_CARD=מאסטרקארד KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX 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=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=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=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 Date_HITZTARFUT in line 10 305-314.
NOTE: Invalid data for BITZUA_ISKA_TIME in line 10 349-353.
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=323433323530343535353231373636333034 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=.
date_CALC_TRCH=. MEZAHE_TNUA=05326101326001620438538MT21327002800001031396600 MLI_TEUR_SUG_CARD=פלטינה KOD_CHEVRA=5
TEUR_CARD=מאסטרקארד KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX 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=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=66 MATBEA_BITZUA_ISKA=ILS 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=ISR 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 Date_HITZTARFUT in line 11 331-340.
NOTE: Invalid data for BITZUA_ISKA_TIME in line 11 375-379.
7                                                          The SAS System                            08:15 Tuesday, October 10, 2023

RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
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=323433323530343535353231373636333034 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=.
date_CALC_TRCH=. MEZAHE_TNUA=05326101323001565054319MT21325004300001047106400 MLI_TEUR_SUG_CARD=פלטינה KOD_CHEVRA=5
TEUR_CARD=מאסטרקארד KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX 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=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=308.65
MATBEA_BITZUA_ISKA=ILS 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=ISR 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 Date_HITZTARFUT in line 12 289-298.
NOTE: Invalid data for BITZUA_ISKA_TIME in line 12 333-336.
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=323433323530343535353231373636333034 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=.
date_CALC_TRCH=. MEZAHE_TNUA=T212790047000200000161 T21279004700020000016100 MLI_TEUR_SUG_CARD=פלטינה KOD_CHEVRA=5
TEUR_CARD=מאסטרקארד KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX 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=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=15 MATBEA_BITZUA_ISKA=ILS 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=ISR 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 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=323433323530343535353231373636333034 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=.
date_CALC_TRCH=. MEZAHE_TNUA=72302331330021009149782 T21330002147758000000100 MLI_TEUR_SUG_CARD=פלטינה KOD_CHEVRA=5
TEUR_CARD=מאסטרקארד KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX SHEM_SOCHER=I.CARE 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=ILS MIS_TASH_MEK=0
MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=140 MATBEA_BITZUA_ISKA=ILS ACHUZ_RIBIT=0 IND_ISKAT_CHUL=0 SCHUM_ISKA_MAT_CHUV=140 IND_HOCK=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=ISR 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.
8                                                          The SAS System                            08:15 Tuesday, October 10, 2023

NOTE: Invalid data for date_CALC_TRCH in line 14 69-78.
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=3835313138383334353830313233393336 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=.
date_CALC_TRCH=. MEZAHE_TNUA=T212760032000420003299 T21276003200042000329900 MLI_TEUR_SUG_CARD=זהב KOD_CHEVRA=4 TEUR_CARD=ויזה
KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX 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=ILS MIS_TASH_MEK=0
MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=18 MATBEA_BITZUA_ISKA=ILS 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=ISR 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 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=3835313138383334353830313233393336 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=.
date_CALC_TRCH=. MEZAHE_TNUA=74580001189197632520217VT21192004200001045942700 MLI_TEUR_SUG_CARD=זהב KOD_CHEVRA=4 TEUR_CARD=ויזה
KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX 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=ILS MIS_TASH_MEK=0
MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=95.55 MATBEA_BITZUA_ISKA=ILS 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=ISR
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 Date_HITZTARFUT in line 16 281-290.
NOTE: Invalid data for BITZUA_ISKA_TIME in line 16 326-330.
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=3835313138383334353830313233393336 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=.
date_CALC_TRCH=. MEZAHE_TNUA=04557431255008570831371VT21256004200001043812400 MLI_TEUR_SUG_CARD=זהב KOD_CHEVRA=4 TEUR_CARD=ויזה
KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX 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=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0
SCHUM_ISKA_MAT_MAKOR=221.61 MATBEA_BITZUA_ISKA=ILS 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=ISR 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.
9                                                          The SAS System                            08:15 Tuesday, October 10, 2023

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 Date_HITZTARFUT in line 17 285-294.
NOTE: Invalid data for BITZUA_ISKA_TIME in line 17 330-334.
RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      
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=3835313138383334353830313233393336 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=.
date_CALC_TRCH=. MEZAHE_TNUA=74580001187197498047505VT21188002900001054293200 MLI_TEUR_SUG_CARD=זהב KOD_CHEVRA=4 TEUR_CARD=ויזה
KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX 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=ILS MIS_TASH_MEK=0
MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=34 MATBEA_BITZUA_ISKA=ILS 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=ISR 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 Date_HITZTARFUT in line 18 298-307.
NOTE: Invalid data for BITZUA_ISKA_TIME in line 18 343-347.
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=3835313138383334353830313233393336 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=.
date_CALC_TRCH=. MEZAHE_TNUA=74580001231199793486368VT21234004400001049677100 MLI_TEUR_SUG_CARD=זהב KOD_CHEVRA=4 TEUR_CARD=ויזה
KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX 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=ILS MIS_TASH_MEK=0
MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=150.89 MATBEA_BITZUA_ISKA=ILS 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=ISR
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 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=3835313138383334353830313233393336 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=.
date_CALC_TRCH=. MEZAHE_TNUA=74403031260046001375113 T21260004604523000014200 MLI_TEUR_SUG_CARD=זהב KOD_CHEVRA=4 TEUR_CARD=ויזה
KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX 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=ILS MIS_TASH_MEK=0
MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=312.3 MATBEA_BITZUA_ISKA=ILS 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=ISR
WhichFile=1 Date_HITZTARFUT=. month_Nechonut=2109 LAKOACH=3195 groupk_base=2 misg_crd_base=20000 Hativa_base=833
10                                                         The SAS System                            08:15 Tuesday, October 10, 2023

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 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=3835313138383334353830313233393336 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=.
date_CALC_TRCH=. MEZAHE_TNUA=T213360032000420001752 T21336003200042000175200 MLI_TEUR_SUG_CARD=זהב KOD_CHEVRA=4 TEUR_CARD=ויזה
KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX 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=ILS MIS_TASH_MEK=0
MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=18 MATBEA_BITZUA_ISKA=ILS 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=ISR 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 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=3835313138383334353830313233393336 date_TAARICH_BITZUA_ISKA=. date_TAARICH_IBUD_ISKA=. date_TAARICH_CHIUV=.
date_CALC_TRCH=. MEZAHE_TNUA=04557431160005705304633VT21162003000001002566900 MLI_TEUR_SUG_CARD=זהב KOD_CHEVRA=4 TEUR_CARD=ויזה
KOD_CHEVRA_GLOBAL=4 CHEVRA=MAX 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=ILS MIS_TASH_MEK=0 MIS_TASH_NOTRU=0 SCHUM_ISKA_MAT_MAKOR=92 MATBEA_BITZUA_ISKA=ILS 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=ISR 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: 1000 records were read from the infile SOFI.
      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 53.33 percent. 
      Compressed is 7 pages; un-compressed would require 15 pages.
NOTE: DATA statement used (Total process time):
      real time           0.03 seconds
      user cpu time       0.02 seconds
      system cpu time     0.00 seconds
      memory              1040.50k
      OS Memory           29092.00k
      Timestamp           10/10/2023 09:27:22 AM
      Step Count                        18  Switch Count  2
11                                                         The SAS System                            08:15 Tuesday, October 10, 2023

      Page Faults                       0
      Page Reclaims                     140
      Page Swaps                        0
      Voluntary Context Switches        28
      Involuntary Context Switches      0
      Block Input Operations            0
      Block Output Operations           0
      

149        
150        
151        GOPTIONS NOACCESSIBLE;
152        %LET _CLIENTTASKLABEL=;
153        %LET _CLIENTPROCESSFLOWNAME=;
154        %LET _CLIENTPROJECTPATH=;
155        %LET _CLIENTPROJECTPATHHOST=;
156        %LET _CLIENTPROJECTNAME=;
157        %LET _SASPROGRAMFILE=;
158        %LET _SASPROGRAMFILEHOST=;
159        
160        ;*';*";*/;quit;run;
161        ODS _ALL_ CLOSE;
162        
163        
164        QUIT; RUN;
165

Re: EXPORT SAS DATA SET INTO ZIP CSV ---

Kurt_Bremser — Tue, 10 Oct 2023 07:26:46 GMT

In the INPUT statement, add

:ddmmyy10.

to all date variables to use the proper informat. Similarly, use a TIME5. informat for the one time value.

Or use a separate INFORMAT statement after LENGTH to set the informats.

Re: EXPORT SAS DATA SET INTO ZIP CSV ---

Tom — Tue, 10 Oct 2023 12:57:26 GMT

SAS does not normally NEED to be told to use a special INFORMAT when reading in data. But for DATE, TIME and DATETIME values you almost always to need to use a special informat to read the human recognizable string and a special format to write human recognizable strings.

The SAS log shows you the information you need to decide what INFORMAT should be used for those DATE values. For example the value in the column mentioned in the first invalid data note has the string "23/10/2021". So that looks like a date in DMY order. So use the DDMMYY informat to read it. You will also want to attach a date type format to the variable so it will print in a human readable style. I would discourage using DDMMYY format because when the day of the month is less than 13 the values can be confused for those written with the MMDDYY format. Use either the DATE format or the YYMMDD format and that confusion will disappear.

So to fix that first error you need to add these two statements to your step that is reading the file.

informat date_TAARICH_BITZUA_ISKA ddmmyy.;
format date_TAARICH_BITZUA_ISKA yymmdd10.;

If all of the variables that start with DATE_ are also date values and were written using the DDMMYY format then you can use a variable list to make the program easier to type.

informat date_: ddmmyy.;
format date_: yymmdd10.;

Make sure to place the FORMAT and INFORMAT statement(s) after the LENGTH statement otherwise there will not be any variables yet defined with names that match that pattern.

For the variable(s) with time values using the TIME informat and the TIME format.