topic Re: export to ZIP TXT and then import in SAS Programming

export to ZIP TXT and then import

Ronein — Mon, 09 Oct 2023 09:27:37 GMT

Hello

I want to export big data set of 250 million rows and 30 columns into TXT ZIP file.

I used this code


libname LS '/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/';
options missing='';
filename outfile
zip "/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/lightSolver_sofi.zip"
member="lightSolver_sofi.txt";
data _null_;
file outfile dlm=',';
set LS.lightSolver_sofi;
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;
options missing='.';

Now I want to Import this file into SAS data set in order to see that it was exported well.

I used this code and it produce wrong results.

The values look Gibrish and only have 8 columns and only 56 million rows.

Why???

PROC IMPORT OUT=newdata
    DATAFILE="/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/lightSolver_sofi.zip"
    DBMS=CSV
    REPLACE;
    GETNAMES=YES;
RUN;

Re: export to ZIP TXT and then import

andreas_lds — Mon, 09 Oct 2023 10:17:51 GMT

I would expect something interesting in the log of the export. Having

filename outfile clear;

after the data step could be useful, too.

Re: export to ZIP TXT and then import

Ronein — Mon, 09 Oct 2023 10:41:56 GMT

Thanks,

Do you want me to run this code?

and then copy the log message?


filename outfile clear;
PROC IMPORT OUT=newdata
    DATAFILE="/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/lightSolver_sofi.zip"
    DBMS=CSV
    REPLACE;
    GETNAMES=YES;
RUN;

Re: export to ZIP TXT and then import

Kurt_Bremser — Mon, 09 Oct 2023 10:44:29 GMT

Don't use PROC IMPORT if you're looking for consistent results
Use the same fileref you used in the export DATA step in your import; you use the ZIP file as INFILE, which won't work, as a ZIP file is no longer text. If PROC IMPORT doesn't like a fileref with ZIP and MEMBER, see #1

Re: export to ZIP TXT and then import

Ronein — Mon, 09 Oct 2023 10:44:34 GMT

Here is the log

1                                                          The SAS System                              07:52 Monday, October 9, 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         
27         filename outfile clear;
NOTE: Fileref OUTFILE has been deassigned.
28         PROC IMPORT OUT=newdata
29             DATAFILE="/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/lightSolver_sofi.zip"
30             DBMS=CSV
31             REPLACE;
32             GETNAMES=YES;
33         RUN;

Number of names found is less than number of variables found. 
Name 
PK   EIW      lightSolver_sofi.txt                  ה½wq/ת~Š^zqœƒ/w2i™”´$‰ו$¾‰9±JגsoC G#€F„žn
{wןימט¦€\¦÷z PS»>~ץ«—ל³ח‾?}צץ/Vפ»רכWž}ש§Ÿ½שח‾~ם³Ÿ
truncated to PK   EIW      li.
Problems were detected with provided names.  See LOG. 
34          /**********************************************************************
35          *   PRODUCT:   SAS
36          *   VERSION:   9.4
37          *   CREATOR:   External File Interface
38          *   DATE:      09OCT23
39          *   DESC:      Generated SAS Datastep Code
40          *   TEMPLATE SOURCE:  (None Specified.)
41          ***********************************************************************/
42             data WORK.NEWDATA    ;
43             %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
44             infile '/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/lightSolver_sofi.zip' delimiter = ',' MISSOVER DSD
44       ! lrecl=32767 firstobs=2 ;
45                informat "PKEIWli"N $1029. ;
46                informat VAR2 $252. ;
47                informat VAR3 $183. ;
48                informat VAR4 $169. ;
2                                                          The SAS System                              07:52 Monday, October 9, 2023

49                informat VAR5 $149. ;
50                informat VAR6 $8. ;
51                informat VAR7 $36. ;
52                informat VAR8 $2. ;
53                format "PKEIWli"N $1029. ;
54                format VAR2 $252. ;
55                format VAR3 $183. ;
56                format VAR4 $169. ;
57                format VAR5 $149. ;
58                format VAR6 $8. ;
59                format VAR7 $36. ;
60                format VAR8 $2. ;
61             input
62                         "PKEIWli"N $
63                         VAR2 $
64                         VAR3 $
65                         VAR4 $
66                         VAR5 $
67                         VAR6 $
68                         VAR7 $
69                         VAR8 $
70             ;
71             if _ERROR_ then call symputx('_EFIERR_',1);  /* set ERROR detection macro variable */
72             run;

NOTE: The infile '/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/lightSolver_sofi.zip' is:
      Filename=/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/lightSolver_sofi.zip,
      Owner Name=Udclk79,
      Group Name=GR_IL_SAS_USERS_LabRet,
      Access Permission=-rwxrwxr-x,
      Last Modified=09Oct2023:09:59:46,
      File Size (bytes)=14630108879

NOTE: 56523337 records were read from the infile '/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/lightSolver_sofi.zip'.
      The minimum record length was 0.
      The maximum record length was 4633.
NOTE: The data set WORK.NEWDATA has 56523337 observations and 8 variables.
NOTE: Compressing data set WORK.NEWDATA decreased size by 86.23 percent. 
      Compressed is 222361 pages; un-compressed would require 1614953 pages.
NOTE: DATA statement used (Total process time):
      real time           2:18.95
      user cpu time       1:58.60
      system cpu time     14.08 seconds
      memory              9701.07k
      OS Memory           33556.00k
      Timestamp           10/09/2023 01:43:35 PM
      Step Count                        62  Switch Count  2
      Page Faults                       0
      Page Reclaims                     4739
      Page Swaps                        0
      Voluntary Context Switches        65365
      Involuntary Context Switches      1160
      Block Input Operations            0
      Block Output Operations           0
      

56523337 rows created in WORK.NEWDATA from /usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/lightSolver_sofi.zip.
  
3                                                          The SAS System                              07:52 Monday, October 9, 2023

  
  
NOTE: WORK.NEWDATA data set was successfully created.
NOTE: The data set WORK.NEWDATA has 56523337 observations and 8 variables.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           2:19.45
      user cpu time       1:58.64
      system cpu time     14.11 seconds
      memory              9701.07k
      OS Memory           34072.00k
      Timestamp           10/09/2023 01:43:35 PM
      Step Count                        62  Switch Count  12
      Page Faults                       0
      Page Reclaims                     7803
      Page Swaps                        0
      Voluntary Context Switches        65597
      Involuntary Context Switches      1161
      Block Input Operations            0
      Block Output Operations           0
      

73         
74         
75         GOPTIONS NOACCESSIBLE;
76         %LET _CLIENTTASKLABEL=;
77         %LET _CLIENTPROCESSFLOWNAME=;
78         %LET _CLIENTPROJECTPATH=;
79         %LET _CLIENTPROJECTPATHHOST=;
80         %LET _CLIENTPROJECTNAME=;
81         %LET _SASPROGRAMFILE=;
82         %LET _SASPROGRAMFILEHOST=;
83         
84         ;*';*";*/;quit;run;
85         ODS _ALL_ CLOSE;
86         
87         
88         QUIT; RUN;
89

Re: export to ZIP TXT and then import

Ronein — Mon, 09 Oct 2023 11:41:41 GMT

May you please show the code?

This it the code format that I made the export from sas data set into CSV file.

libname LS '/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/';
options missing='';
filename outfile
zip "/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/lightSolver_sofi.zip"
member="lightSolver_sofi.txt";
data _null_;
file outfile dlm=',';
set LS.lightSolver_sofi;
if _n_ = 1 then put 
'Var_Names with comma between them';
put 
Var_Names
;
run;
options missing='.';

Re: export to ZIP TXT and then import

Kurt_Bremser — Mon, 09 Oct 2023 11:44:46 GMT

You just use the same file reference you used in the export in the following import. No rocket science.

Re: export to ZIP TXT and then import

Ronein — Mon, 09 Oct 2023 11:50:18 GMT

Can you show code example please?

Re: export to ZIP TXT and then import

Kurt_Bremser — Mon, 09 Oct 2023 14:28:43 GMT

You omit the FILENAME CLEAR statement and use

infile outfile dlm="," firstobs=2 dsd truncover;

in the DATA step with which you read the file back.

Re: export to ZIP TXT and then import

Tom — Mon, 09 Oct 2023 15:01:32 GMT

To make a proper delimited file you need to use the DSD option, not just change the delimiter. Otherwise SAS will not write the null values and values that contain the delimiter properly.

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/lightSolver_sofi.zip"
  member="lightSolver_sofi.txt"
;

Then you can write to the file (no need to mess with the OPTIONS settings):

libname LS '/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/';
data _null_;
  file SOFI dsd ;
  if _n_ = 1 then put  'Var_Names with comma between them';
  set LS.lightSolver_sofi;
  put Var_Names ;
run;

Or read from the file:

libname LS '/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/';
data LS.lightSolver_sofi;
  infile SOFI dsd truncover firstobs=2;
* Define the variables ;
  length .... ;
* read the variables ;
  input Var_Names ;
run;

If you really want to force SAS to make guesses about how to read the file you can try using PROC IMPORT, but you will first have to copy the file to an actual file.

filename copy temp;
data _null_;
  infile SOFI;
  file copy;
  input;
  put _infile_;
run;
proc import file=copy dbms=csv out=want replace;
run;

If you want you can use some other tool to guess how to import the file that does not require you to copy the file out of the ZIP file first.

Try using %CSV2DS() macro https://github.com/sasutils/macros/blob/master/csv2ds.sas

%csv2ds(SOFI,out=want,replace=1)

And you will get other advantages.

Differences from PROC IMPORT
- Supports header lines with more than 32,767 characters
- Supports ZIP and GZIP source files
- Generates unique variable names by adding numeric suffix
- Does not overestimate maxlength when longest value is quoted
- Does NOT force character type if all values are quoted
- Generates label when generated variable name is different than header
- Supports NAMEROW option
- Supports numeric fields with special missing values (MISSING statement)
- Does not attach unneeded informats or formats
- Allows overriding calculated metadata
- Allow using random sample of rows to guess metadata
- Generates more compact SAS code
- Generates analysis summary dataset and raw data view
- Saves generated SAS code to a file
- Forces DATE and DATETIME formats to show century
- Difference in generated V7 compatible variable names
  - Replaces adjacent non-valid characters with single underscore

Re: export to ZIP TXT and then import

Ronein — Mon, 09 Oct 2023 18:46:33 GMT

Thanks so much Tom.

I applied your code and here is the Log.

I have some questions please:

1-There is a note in Log "NOTE: Format SINUN_REASON_FMT was not found or could not be loaded."

I don't see any variable with this name SINUN_REASON_FMT.

Why this note came from? Any action is required from me about it?

2-In Order to Import the ZIP file (In order to check that it was exported correctly) I need to use following statements:

Input (List of variables in same order they appear in the ZIP file)

Length

I am looking in the log in order to know what length to apply for each var.

How can I know it?

I dont see it in the log (Log of the export activity)

3- What type of file was created? Is it called CSV ZIP file?

is the end of the file is file_name.ZIP or file_name.ZIP.CSV or file_name.CSV?

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

1          ;*';*";*/;quit;run;
2          OPTIONS PAGENO=MIN;
3          %LET _CLIENTTASKLABEL='Export_final_DatSet_into_CSV_File';
4          %LET _CLIENTPROCESSFLOWNAME='Process Flow';
5          %LET _CLIENTPROJECTPATH='';
6          %LET _CLIENTPROJECTPATHHOST='';
7          %LET _CLIENTPROJECTNAME='';
8          %LET _SASPROGRAMFILE='M:\a.ריכוז
8        ! תוכניות\CS\LightSolver\EXPORT_SAS_DATA_SET_INTO_CSV_FILE\Export_final_DatSet_into_CSV_File.sas';
9          %LET _SASPROGRAMFILEHOST='VSK1H0103A2021';
10         
11         ODS _ALL_ CLOSE;
12         OPTIONS DEV=PNG;
13         GOPTIONS XPIXELS=0 YPIXELS=0;
14         FILENAME EGSR TEMP;
15         ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR
16             STYLE=HTMLBlue
17             STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HTMLBlue.css")
18             NOGTITLE
19             NOGFOOTNOTE
20             GPATH=&sasworklocation
21             ENCODING=UTF8
22             options(rolap="on")
23         ;
NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
24         
25         GOPTIONS ACCESSIBLE;
26         libname LS '/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/';
NOTE: Libref LS was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: /usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards
27         data _null_;
28         set LS.lightSolver_sofi;
29         file SOFI dsd ;
30         if _n_=1 then
31         put
32         'MEZAHE_CARD,
33         date_TAARICH_BITZUA_ISKA,
34         date_TAARICH_IBUD_ISKA,
35         date_TAARICH_CHIUV,
36         date_CALC_TRCH,
37         MEZAHE_TNUA,
38         MLI_TEUR_SUG_CARD,
39         KOD_CHEVRA,
40         TEUR_CARD,
41         KOD_CHEVRA_GLOBAL,
42         CHEVRA,
43         SHEM_SOCHER,
44         MIS_SOCHER,
45         MCC4,
46         SHEM_MCC4,
47         COMPANY_LEGAL_ID,
48         SUG_ISKA,
49         TEURSUG_ISKA,
50         SCHUM_CHIUV,
51         MIS_TASH_NOCH,
NOTE: The quoted string currently being processed has become more than 262 characters long.  You might have unbalanced quotation 
      marks.
2                                                          The SAS System                              14:08 Monday, October 9, 2023

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

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

NOTE: Format SINUN_REASON_FMT was not found or could not be loaded.
NOTE: Format SINUN_REASON_FMT was not found or could not be loaded.
NOTE: The file SOFI is:
      Filename=/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/lightSolver_sofi.zip,
      Member Name=lightSolver_sofi.txt

NOTE: 287603021 records were written to the file SOFI.
      The minimum record length was 278.
      The maximum record length was 810.
NOTE: There were 287603020 observations read from the data set LS.LIGHTSOLVER_SOFI.
NOTE: DATA statement used (Total process time):
      real time           1:28:15.18
      user cpu time       1:27:03.14
      system cpu time     1:00.15
      memory              1804.53k
      OS Memory           28584.00k
      Timestamp           10/09/2023 09:11:00 PM
4                                                          The SAS System                              14:08 Monday, October 9, 2023

      Step Count                        13  Switch Count  8475
      Page Faults                       0
      Page Reclaims                     59463
      Page Swaps                        0
      Voluntary Context Switches        83036
      Involuntary Context Switches      26775
      Block Input Operations            0
      Block Output Operations           0
      

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 to ZIP TXT and then import

Kurt_Bremser — Mon, 09 Oct 2023 18:56:59 GMT

1. It means you have a format of that name assigned to a variable, but the format cannot be found in the path given in the FMTSEARCH system option. You must create it anew, or add the location to FMTSEARCH.

Re: export to ZIP TXT and then import

Ronein — Mon, 09 Oct 2023 19:00:30 GMT

Other question about import the ZP CSV file.

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

Re: export to ZIP TXT and then import

Tom — Mon, 09 Oct 2023 19:13:19 GMT

@Ronein wrote:

Other question about import the ZP CSV file.

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

That step is to COPY the lines.

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

Re: export to ZIP TXT and then import

Tom — Mon, 09 Oct 2023 19:19:52 GMT

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

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

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

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

Re: export to ZIP TXT and then import

Ronein — Mon, 09 Oct 2023 19:20:55 GMT

So needed action is to create proc format?

After create proc format than the value in ZIP CSV file will be the formatted value?

And If I don't write proc format then the values in ZIP CSV will be the non-formatted values?

Re: export to ZIP TXT and then import

Tom — Mon, 09 Oct 2023 19:33:32 GMT

@Ronein wrote:

So needed action is to create proc format?

After create proc format than the value in ZIP CSV file will be the formatted value?

And If I don't write proc format then the values in ZIP CSV will be the non-formatted values?

Depends on what you want to put into the CSV file. Do you want the values are stored in the dataset? or the values that SAS would display if it could find the format?

Re: export to ZIP TXT and then import

Ronein — Tue, 10 Oct 2023 03:28:40 GMT

Hello Tom.

I used the code to import the zip csv file.

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

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

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

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

How can I know it?

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

Here is also the log of the import

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

1          ;*';*";*/;quit;run;
2          OPTIONS PAGENO=MIN;
3          %LET _CLIENTTASKLABEL='Export_final_DatSet_into_CSV_File';
4          %LET _CLIENTPROCESSFLOWNAME='Process Flow';
5          %LET _CLIENTPROJECTPATH='';
6          %LET _CLIENTPROJECTPATHHOST='';
7          %LET _CLIENTPROJECTNAME='';
8          %LET _SASPROGRAMFILE='M:\a.ריכוז
8        ! תוכניות\CS\LightSolver\EXPORT_SAS_DATA_SET_INTO_CSV_FILE\Export_final_DatSet_into_CSV_File.sas';
9          %LET _SASPROGRAMFILEHOST='VSK1H0103A2021';
10         
11         ODS _ALL_ CLOSE;
12         OPTIONS DEV=PNG;
13         GOPTIONS XPIXELS=0 YPIXELS=0;
14         FILENAME EGSR TEMP;
15         ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR
16             STYLE=HTMLBlue
17             STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HTMLBlue.css")
18             NOGTITLE
19             NOGFOOTNOTE
20             GPATH=&sasworklocation
21             ENCODING=UTF8
22             options(rolap="on")
23         ;
NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
24         
25         GOPTIONS ACCESSIBLE;
26         libname LS '/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/';
NOTE: Libref LS was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: /usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards
27         data AAA;
28         infile SOFI dsd truncover firstobs=2;
29         input
30         MEZAHE_CARD
31         date_TAARICH_BITZUA_ISKA
32         date_TAARICH_IBUD_ISKA
33         date_TAARICH_CHIUV
34         date_CALC_TRCH
35         MEZAHE_TNUA
36         MLI_TEUR_SUG_CARD
37         KOD_CHEVRA
38         TEUR_CARD
39         KOD_CHEVRA_GLOBAL
40         CHEVRA
41         SHEM_SOCHER
42         MIS_SOCHER
43         MCC4
44         SHEM_MCC4
45         COMPANY_LEGAL_ID
46         SUG_ISKA
47         TEURSUG_ISKA
48         SCHUM_CHIUV
49         MIS_TASH_NOCH
50         MATBEA_CHIUV
51         MIS_TASH_MEK
52         MIS_TASH_NOTRU
53         SCHUM_ISKA_MAT_MAKOR
2                                                          The SAS System                              14:08 Monday, October 9, 2023

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

NOTE: SAS threaded sort was used.

Re: export to ZIP TXT and then import

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

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

Re: export to ZIP TXT and then import

Ronein — Tue, 10 Oct 2023 05:11:18 GMT

Hello Tom,

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

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

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

My question-

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