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
Click image to register for webinar
