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;
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
How to Concatenate Values
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
-
1180 views
-
3 likes
-
-
