SAS-Log
1 Das SAS System 12:45 Monday, December 13, 2021
NOTE: Copyright (c) 2016 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software 9.4 (TS1M7)
Licensed to DEUTSCHE RENTE BUND, Site 70121776.
NOTE: This session is executing on the Linux 4.18.0-305.19.1.el8_4.x86_64 (LIN X64) platform.
NOTE: Analytical products:
SAS/STAT 15.2
NOTE: Additional host information:
Linux LIN X64 4.18.0-305.19.1.el8_4.x86_64 #1 SMP Tue Sep 7 07:07:31 EDT 2021 x86_64 Red Hat Enterprise Linux release 8.4 (Ootpa)
You are running SAS 9. Some SAS 8 files will be automatically converted
by the V9 engine; others are incompatible. Please see
http://support.sas.com/rnd/migration/planning/platform/64bit.html
PROC MIGRATE will preserve current SAS file attributes and is
recommended for converting all your SAS libraries from any
SAS 8 release to SAS 9. For details and examples, please see
http://support.sas.com/rnd/migration/index.html
This message is contained in the SAS news file, and is presented upon
initialization. Edit the file "news" in the "misc/base" directory to
display site-specific news and information in the program log.
The command line option "-nonews" will prevent this display.
NOTE: Verwendet wurde: SAS-Initialisierung - (Gesamtverarbeitungszeit):
real time 0.02 seconds
cpu time 0.01 seconds
NOTE: The autoexec file, /opt/sas/config/Lev1/SASApp/StoredProcessServer/autoexec.sas, was executed at server initialization.
>>> SAS Macro Variables:
BB_DATA=SBDAT520
BB_FMT=fmt
BB_REF=SBREF520
END=202111
FILTERBRNR=gesamt
FILTERLEAT=gesamt
FILTERVOAT=neus
FILTERWHOT=gesamt
GMETAHOST=sastestbi1.test.drv.drv
GMETAPORT=8561
PEXPORT=createHTML
REEW_KTAT_L1=Kontenklasse 9 Investitionshaushalts- u. Verrechnungskonten der Vermögensrechnung
REF_TOC=/daten/sy0520/di/stage/statistikband/extReferenzen
START=202101
TABLEHEAD=leat
TECHLADEDTORA=TO_TIMESTAMP('09DEC2021 10:54:56', 'DDMonYYYY HH24:MI:SS', 'NLS_DATE_LANGUAGE = AMERICAN')
TECHLADEDTSAS='09DEC2021 10:54:56'dt
UMGEBUNG=test
_APSLIST=_srvport,_reqencoding,_userlocale,pexport,start,_sessionid,_htcook,_rmthost,tablehead,_rmtaddr,_grafloc,_reqmeth,filterwhot,_srvname,filterbrnr,filtervoat,end,_program,_username,_htua,_
url,filterleat,_version,_result,_metaperson,_metauser,_metafolder,_client,_SECUREUSERNAME
_CLIENT=StoredProcessService 9.4; JVM 1.8.0_312; Linux (amd64) 4.18.0-305.19.1.el8_4.x86_64
_GRAFLOC=/sasweb/graph
_HTCOOK=8e3a311e370a36db105cdea5632a7985_Cluster1=BAA8C3AC06BF158158D947662C1CC0C1.8e3a311e370a36db105cdea5632a7985_SASServer1_1 8e3a311e370a36db105cdea5632a7985_Cluster1=796733FF48BBB72D5687F2
8BB9CDFBDB.8e3a311e370a36db105cdea5632a7985_SASServer1_1
_HTUA=Mozilla/5.0 (Windows NT 10.0 Win64 x64 rv:91.0) Gecko/20100101 Firefox/91.0
_METAFOLDER=/20_SY0520/20_BI_Intern/10_Global/25_Rentenantraege/10_Allgemein/30_StoredProcesses/
_METAPERSON=Jürgen Hofmann
_METAUSER=v990045
_PROGRAM=/20_SY0520/20_BI_Intern/10_Global/25_Rentenantraege/10_Allgemein/30_StoredProcesses/02_RTAQ_Generate
_REPLAY="&_URL?_sessionid=8EF6120C-A4C5-0D4C-9599-35BE4E226ABE&_program=replay&_entry=&_TMPCAT.."
_REQENCODING=UTF-8
_REQMETH=GET
_RESULT=STREAM
_RMTADDR=190.199.9.103
_RMTHOST=190.199.9.103
_SECUREUSERNAME=v990045
_SESSIONID=8EF6120C-A4C5-0D4C-9599-35BE4E226ABE
_SRVNAME=sastestas101.test.tdmz.drv.drv
_SRVPORT=8343
_THISSESSION=/SASStoredProcess/do?_SESSIONID=8EF6120C-A4C5-0D4C-9599-35BE4E226ABE
_TMPCAT=SAVE.TMPCAT
_URL=/SASStoredProcess/do
_USERLOCALE=de
_USERNAME=Jürgen Hofmann
_VERSION=Version 9.4 (Build 526)
NOTE: %INCLUDE (level 1) file /daten/sy0520/bi_intern/global/rentenantraege/stored_processes/02_sk85_rtaq_generate_report.sas is file
/daten/sy0520/bi_intern/global/rentenantraege/stored_processes/02_sk85_rtaq_generate_report.sas.
3 +***************************************************************************************
4 +* rep_performance_report
5 +
Das SAS System
6 + Aufbau der Berichtsdaten und dessen Ausgabe. Die Steuerungsparameter werden vom Hauptprogramm
7 + generiert und übergeben. Ansprechpartner seitens des Fachbereichs ist Herr Wunderlich.
8 +
9 + Version:
10 + 1.0 - Initiale Erstellung
11 + F. Roeder / M.Heidemann - SAS Institute GmbH - 30.04.2018
12 + 1.1 - Initiale Erstellung
13 + Torsten Hammer 18.12.2019 - Anpassung VOAT Filter
14 + 1.2 - Änderung 03.06.2020 Hagen Meyer
15 + Neue Versicherungsträgerfilter: Allgemeine Rentenversicherung, Knappschaftliche Rentenversicherung
16 +
17 + Abhängigkeiten:
18 + STP: 01_RTAQ_Prepare
19 +
20 + Eingabeparameter:
21 + start - Datum für den Beginn des Auswertungszeitraums
22 + end - Datum für das Ende des Auswertungszeitraums
23 + tabelle - Art der Tabelle, anhand derer die Vorspalte und der Filter auf die Daten bestimmt wird
24 +
25 +**************************************************************************************;
26 +
27 +
28 +
29 +* Falls keine Parameter übergeben worden, diese erstellen um Fehlermeldungen zu verhindern.;
30 +%macro listControl;
31 + %if not %symexist(start) %then %global start;
32 + %if not %symexist(end) %then %global end;
33 + %if not %symexist(filterVOAT) %then %global filterVOAT;
34 + %if not %symexist(filterBRNR) %then %global filterBRNR;
35 + %if not %symexist(filterLEAT) %then %global filterLEAT;
36 + %if not %symexist(filterWHOT) %then %global filterWHOT;
37 + %if not %symexist(tableHead) %then %global tableHead;
38 + %if not %symexist(tableSubHeadline2) %then %global tableSubHeadline2;
39 + %if not %symexist(tableSubHeadline3) %then %global tableSubHeadline3;
40 + %if not %symexist(tableSubHeadline4) %then %global tableSubHeadline4;
41 + %if not %symexist(tableSubHeadline5) %then %global tableSubHeadline5;
42 + %if not %symexist(tableFilter) %then %global tableFilter;
43 + %if not %symexist(tableFilterVOAT) %then %global tableFilterVOAT;
Das SAS System
44 + %if not %symexist(tableFilterBRNR) %then %global tableFilterBRNR;
45 + %if not %symexist(tableFilterLEAT) %then %global tableFilterLEAT;
46 + %if not %symexist(tableFilterWHOT) %then %global tableFilterWHOT;
47 + %if not %symexist(tableBox) %then %global tableBox;
48 + %if not %symexist(tablemonth) %then %global tablemonth;
49 + %if not %symexist(printTable) %then %global printTable;
50 + %if not %symexist(date_end) %then %global date_end;
51 + %if not %symexist(date_begin) %then %global date_begin;
52 + %if not %symexist(fmt) %then %global fmt;
53 + %if not %symexist(fmt2) %then %global fmt2;
54 + %if not %symexist(str) %then %global str;
55 + %if not %symexist(reason) %then %global reason;
56 + %if not %symexist(outputfile) %then %global outputfile;
57 + %if not %symexist(tableSaveMonth) %then %global tableSaveMonth;
58 + %if not %symexist(month_begin_print) %then %global month_begin_print;
59 + %if not %symexist(month_end_print) %then %global month_end_print;
60 + %if not %symexist(additionalColsSqlQuery) %then %global additionalColsSqlQuery;
61 + %if not %symexist(classVar) %then %global classVar;
62 +%mend;
63 +%listControl;
64 +
65 +%macro isBlank(param);
66 + %sysevalf(%superq(param)=,boolean)
67 +%mend isBlank;
68 +
69 +%macro incrementvar(vartoincrement);
70 + %let &vartoincrement = %eval(&&&vartoincrement. + 1);
71 +%mend;
72 +
73 + /* Escape Zeichen fuer Zeilenumbruch im Tabellenkopf */
74 + ods escapechar='~';
75 +
76 +%macro getTableTitles;
77 +
78 + %let day_begin = 01;
79 + %let date_begin = &start.&day_begin.;
80 + %let month_begin = %sysfunc(mod(&start.,100));
81 + %let year_begin = %sysfunc(int(&start./100));
Das SAS System
82 + %let month_end = %sysfunc(mod(&end.,100));
83 + %let year_end = %sysfunc(int(&end./100));
84 + %IF &month_end. = 1 | &month_end. = 3 | &month_end. = 5 | &month_end. = 7 | &month_end. = 8 | &month_end. = 10 | &month_end. = 12 %THEN
85 + %let day_end = 31;
86 + %ELSE %IF &month_end. = 4 | &month_end. = 6 | &month_end. = 9 | &month_end. = 11 %THEN
87 + %let day_end = 30;
88 + %ELSE %IF %sysfunc(mod(&year_end.,400)) = 0 | %sysfunc(mod(&year_end.,4)) = 0 & %sysfunc(mod(&year_end.,100)) ^= 0 %THEN
89 + %let day_end = 29;
90 + %ELSE
91 + %let day_end = 28;
92 +
93 + %let date_end = &end.&day_end.;
94 + /*%put &date_begin.;
95 + %put &date_end.;*/
96 +
97 + %IF &month_begin. = 1 %THEN
98 + %let month_begin_print = Januar;
99 + %ELSE %IF &month_begin. = 2 %THEN
100 + %let month_begin_print = Februar;
101 + %ELSE %IF &month_begin. = 3 %THEN
102 + %let month_begin_print = März;
103 + %ELSE %IF &month_begin. = 4 %THEN
104 + %let month_begin_print = April;
105 + %ELSE %IF &month_begin. = 5 %THEN
106 + %let month_begin_print = Mai;
107 + %ELSE %IF &month_begin. = 6 %THEN
108 + %let month_begin_print = Juni;
109 + %ELSE %IF &month_begin. = 7 %THEN
110 + %let month_begin_print = Juli;
111 + %ELSE %IF &month_begin. = 8 %THEN
112 + %let month_begin_print = August;
113 + %ELSE %IF &month_begin. = 9 %THEN
114 + %let month_begin_print = September;
115 + %ELSE %IF &month_begin. = 10 %THEN
116 + %let month_begin_print = Oktober;
117 + %ELSE %IF &month_begin. = 11 %THEN
118 + %let month_begin_print = November;
119 + %ELSE %IF &month_begin. = 12 %THEN
Das SAS System
120 + %let month_begin_print = Dezember;
121 + %ELSE
122 + %let month_begin_print = Fehler;
123 +
124 +
125 + %IF &month_end. = 1 %THEN
126 + %let month_end_print = Januar;
127 + %ELSE %IF &month_end. = 2 %THEN
128 + %let month_end_print = Februar;
129 + %ELSE %IF &month_end. = 3 %THEN
130 + %let month_end_print = März;
131 + %ELSE %IF &month_end. = 4 %THEN
132 + %let month_end_print = April;
133 + %ELSE %IF &month_end. = 5 %THEN
134 + %let month_end_print = Mai;
135 + %ELSE %IF &month_end. = 6 %THEN
136 + %let month_end_print = Juni;
137 + %ELSE %IF &month_end. = 7 %THEN
138 + %let month_end_print = Juli;
139 + %ELSE %IF &month_end. = 8 %THEN
140 + %let month_end_print = August;
141 + %ELSE %IF &month_end. = 9 %THEN
142 + %let month_end_print = September;
143 + %ELSE %IF &month_end. = 10 %THEN
144 + %let month_end_print = Oktober;
145 + %ELSE %IF &month_end. = 11 %THEN
146 + %let month_end_print = November;
147 + %ELSE %IF &month_end. = 12 %THEN
148 + %let month_end_print = Dezember;
149 + %ELSE
150 + %let month_end_print = Fehler;
151 +
152 +
153 +
154 + %IF &start. = &end. %THEN
155 + %do;
156 + %let tablemonth = Berichtsmonat &month_begin_print. &year_begin.;
157 + %let outputfileMonth = &month_begin_print._&year_begin.;
Das SAS System
158 + %end;
159 + %ELSE
160 + %do;
161 + %let tablemonth = Berichtszeitraum von &month_begin_print. &year_begin. bis &month_end_print. &year_end.;
162 + %let outputfileMonth = &month_begin_print._&year_begin._bis_&month_end_print._&year_end;
163 + %end;
164 +
165 + /* Name der exportierten Dateien (PDF, Excel...) */
166 + %let outputfile =Nachrichtlich_gemeldete_Fallgruppen_&outputfileMonth.;
167 +
168 + %let additionalColsForFilter = ;
169 + %IF &filterBRNR. = gesamt %THEN %DO;
170 + %let tableSubHeadline2 = ;
171 + %let tableFilterBRNR = ;
172 + %END;
173 + %ELSE %IF &filterBRNR. = tr %THEN %DO;
174 + %let tableSubHeadline2 = Regionalträger;
175 + %let tableFilterBRNR = AND BRNR_FILTER < 70;
176 + %END;
177 + %ELSE %IF &filterBRNR. = btr %THEN %DO;
178 + %let tableSubHeadline2 = Bundesträger;
179 + %let tableFilterBRNR = AND BRNR_FILTER >= 70;
180 + %END;
181 + %ELSE %IF &filterBRNR. = arv %THEN %DO;
182 + %let tableSubHeadline2 = Allgemeine Rentenversicherung;
183 + %let tableFilterBRNR = AND BRNR_FILTER IN (02,09,10,11,12,13,15,16,17,18,21,24,25,28,70,80) AND VSKN = 0;
184 + %let additionalColsForFilter = VSKN, ;
185 + %END;
186 + %ELSE %IF &filterBRNR. = krv %THEN %DO;
187 + %let tableSubHeadline2 = Knappschaftliche Rentenversicherung;
188 + %let tableFilterBRNR = AND BRNR_FILTER = 80 AND VSKN IN (1,2);
189 + %let additionalColsForFilter = VSKN, ;
190 + %END;
191 + %ELSE %IF &filterBRNR. = nord %THEN %DO;
192 + %let tableSubHeadline2 = DRV Nord;
193 + %let tableFilterBRNR = AND BRNR_FILTER = 2;
194 + %END;
195 + %ELSE %IF &filterBRNR. = md %THEN %DO;
Das SAS System
196 + %let tableSubHeadline2 = DRV Mitteldeutschland;
197 + %let tableFilterBRNR = AND BRNR_FILTER = 9;
198 + %END;
199 + %ELSE %IF &filterBRNR. = bh %THEN %DO;
200 + %let tableSubHeadline2 = DRV Braunschweig-Hannover;
201 + %let tableFilterBRNR = AND BRNR_FILTER = 10;
202 + %END;
203 + %ELSE %IF &filterBRNR. = wf %THEN %DO;
204 + %let tableSubHeadline2 = DRV Westfalen;
205 + %let tableFilterBRNR = AND BRNR_FILTER = 11;
206 + %END;
207 + %ELSE %IF &filterBRNR. = he %THEN %DO;
208 + %let tableSubHeadline2 = DRV Hessen;
209 + %let tableFilterBRNR = AND BRNR_FILTER = 12;
210 + %END;
211 + %ELSE %IF &filterBRNR. = rl %THEN %DO;
212 + %let tableSubHeadline2 = DRV Rheinland;
213 + %let tableFilterBRNR = AND BRNR_FILTER = 13;
214 + %END;
215 + %ELSE %IF &filterBRNR. = bs %THEN %DO;
216 + %let tableSubHeadline2 = DRV Bayern Süd;
217 + %let tableFilterBRNR = AND BRNR_FILTER = 15;
218 + %END;
219 + %ELSE %IF &filterBRNR. = rp %THEN %DO;
220 + %let tableSubHeadline2 = DRV Rheinland-Pfalz;
221 + %let tableFilterBRNR = AND BRNR_FILTER = 16;
222 + %END;
223 + %ELSE %IF &filterBRNR. = sa %THEN %DO;
224 + %let tableSubHeadline2 = DRV Saarland;
225 + %let tableFilterBRNR = AND BRNR_FILTER = 17;
226 + %END;
227 + %ELSE %IF &filterBRNR. = nb %THEN %DO;
228 + %let tableSubHeadline2 = DRV Nordbayern;
229 + %let tableFilterBRNR = AND BRNR_FILTER = 18;
230 + %END;
231 + %ELSE %IF &filterBRNR. = sw %THEN %DO;
232 + %let tableSubHeadline2 = DRV Schwaben;
233 + %let tableFilterBRNR = AND BRNR_FILTER = 21;
Das SAS System
234 + %END;
235 + %ELSE %IF &filterBRNR. = bw %THEN %DO;
236 + %let tableSubHeadline2 = DRV Baden-Württemberg;
237 + %let tableFilterBRNR = AND BRNR_FILTER = 24;
238 + %END;
239 + %ELSE %IF &filterBRNR. = bb %THEN %DO;
240 + %let tableSubHeadline2 = DRV Berlin-Brandenburg;
241 + %let tableFilterBRNR = AND BRNR_FILTER = 25;
242 + %END;
243 + %ELSE %IF &filterBRNR. = ob %THEN %DO;
244 + %let tableSubHeadline2 = DRV Oldenburg-Bremen;
245 + %let tableFilterBRNR = AND BRNR_FILTER = 28;
246 + %END;
247 + %ELSE %IF &filterBRNR. = bund %THEN %DO;
248 + %let tableSubHeadline2 = DRV Bund;
249 + %let tableFilterBRNR = AND BRNR_FILTER = 70;
250 + %END;
251 + %ELSE %IF &filterBRNR. = kbs %THEN %DO;
252 + %let tableSubHeadline2 = DRV Knappschaft-Bahn-See;
253 + %let tableFilterBRNR = AND BRNR_FILTER = 80;
254 + %END;
255 +
256 +
257 + %IF &filterVOAT. = a %THEN %DO;
258 + %let tableSubHeadline3 = Anträge insgesamt;
259 + %let tableFilterVOAT = WHERE VOAT_FILTER IN (10,20,30,31,40,41,42,43,44,45,46,60,61,62);
260 + %END;
261 + %ELSE %IF &filterVOAT. = anv %THEN %DO;
262 + %let tableSubHeadline3 = Anträge insgesamt - Nichtvertragsrenten;
263 + %let tableFilterVOAT = WHERE VOAT_FILTER IN (10,20,30,31,40,41,42,43,44,45,46,60,61,62) AND VTKZ = 1;
264 + %END;
265 + %ELSE %IF &filterVOAT. = av %THEN %DO;
266 + %let tableSubHeadline3 = Anträge insgesamt - Vertragsrenten;
267 + %let tableFilterVOAT = WHERE VOAT_FILTER IN (10,20,30,31,40,41,42,43,44,45,46,60,61,62) AND VTKZ = 2;
268 + %END;
269 + %ELSE %IF &filterVOAT. = n %THEN %DO;
270 + %let tableSubHeadline3 = Normalfälle;
271 + %let tableFilterVOAT = WHERE VOAT_FILTER IN (10,20,30,31);
Das SAS System
272 + %END;
273 + %ELSE %IF &filterVOAT. = nnv %THEN %DO;
274 + %let tableSubHeadline3 = Normalfälle (Nichtvertragsrenten);
275 + %let tableFilterVOAT = WHERE VOAT_FILTER IN (10,20,30,31) AND VTKZ = 1;
276 + %END;
277 + %ELSE %IF &filterVOAT. = nv %THEN %DO;
278 + %let tableSubHeadline3 = Normalfälle (Vertragsrenten);
279 + %let tableFilterVOAT = WHERE VOAT_FILTER IN (10,20,30,31) AND VTKZ = 2;
280 + %END;
281 + %ELSE %IF &filterVOAT. = s %THEN %DO;
282 + %let tableSubHeadline3 = Sonderfälle;
283 + %let tableFilterVOAT = WHERE VOAT_FILTER IN (40,41,42,43,44,45,46,60,61,62);
284 + %END;
285 + %ELSE %IF &filterVOAT. = snv %THEN %DO;
286 + %let tableSubHeadline3 = Sonderfälle (Nichtvertragsrenten);
287 + %let tableFilterVOAT = WHERE VOAT_FILTER IN (40,41,42,43,44,45,46,60,61,62) AND VTKZ = 1;
288 + %END;
289 + %ELSE %IF &filterVOAT. = sv %THEN %DO;
290 + %let tableSubHeadline3 = Sonderfälle (Vertragsrente);
291 + %let tableFilterVOAT = WHERE VOAT_FILTER IN (40,41,42,43,44,45,46,60,61,62) AND VTKZ = 2;
292 + %END;
293 + %ELSE %IF &filterVOAT. = neu %THEN %DO;
294 + %let tableSubHeadline3 = Neuanträge;
295 + %let tableFilterVOAT = WHERE VOAT_FILTER = 10;
296 + %END;
297 + %ELSE %IF &filterVOAT. = neus %THEN %DO;
298 + %let tableSubHeadline3 = Neuanträge und Sonderfälle;
299 + %let tableFilterVOAT = WHERE VOAT_FILTER IN (10,40,41,42,43,44,45,46,60,61,62);
300 + %END;
301 + %ELSE %IF &filterVOAT. = neunv %THEN %DO;
302 + %let tableSubHeadline3 = Neuanträge - Nichtvertragsrenten;
303 + %let tableFilterVOAT = WHERE VOAT_FILTER IN (10) AND VTKZ = 1;
304 + %END;
305 + %ELSE %IF &filterVOAT. = neuv %THEN %DO;
306 + %let tableSubHeadline3 = Neuanträge - Vertragsrenten;
307 + %let tableFilterVOAT = WHERE VOAT_FILTER IN (10) AND VTKZ = 2;
308 + %END;
309 + %ELSE %IF &filterVOAT. = aendnv %THEN %DO;
Das SAS System
310 + %let tableSubHeadline3 = Änderung der Leistungsart - Nichtvertragsrenten;
311 + %let tableFilterVOAT = WHERE VOAT_FILTER IN (20) AND VTKZ = 1;
312 + %END;
313 + %ELSE %IF &filterVOAT. = aendv %THEN %DO;
314 + %let tableSubHeadline3 = Änderung der Leistungsart - Vertragsrenten;
315 + %let tableFilterVOAT = WHERE VOAT_FILTER IN (20) AND VTKZ = 2;
316 + %END;
317 + %ELSE %IF &filterVOAT. = umnv %THEN %DO;
318 + %let tableSubHeadline3 = Umgedeuteter Rehaantrag - Nichtvertragsrenten;
319 + %let tableFilterVOAT = WHERE VOAT_FILTER IN (40) AND VTKZ = 1;
320 + %END;
321 + %ELSE %IF &filterVOAT. = umv %THEN %DO;
322 + %let tableSubHeadline3 = Umgedeuteter Rehaantrag - Vertragsrenten;
323 + %let tableFilterVOAT = WHERE VOAT_FILTER IN (40) AND VTKZ = 2;
324 + %END;
325 + %ELSE %IF &filterVOAT. = antrehanv %THEN %DO;
326 + %let tableSubHeadline3 = Antrag mit Reha-Leistung nach dem Rentenantrag - Nichtvertragsrenten;
327 + %let tableFilterVOAT = WHERE VOAT_FILTER IN (42) AND VTKZ = 1;
328 + %END;
329 + %ELSE %IF &filterVOAT. = antrehav %THEN %DO;
330 + %let tableSubHeadline3 = Antrag mit Reha-Leistung nach dem Rentenantrag - Vertragsrenten;
331 + %let tableFilterVOAT = WHERE VOAT_FILTER IN (42) AND VTKZ = 2;
332 + %END;
333 + %ELSE %IF &filterVOAT. = antrechtnv %THEN %DO;
334 + %let tableSubHeadline3 = Antrag der bereits erledigt war, aber aufgrund eines Rechtsbehelfs erneut als Rentenantrag zu behandeln ist - Nichtvertragsrenten;
335 + %let tableFilterVOAT = WHERE VOAT_FILTER IN (60,61,62) AND VTKZ = 1;
336 + %END;
337 + %ELSE %IF &filterVOAT. = antrechtv %THEN %DO;
338 + %let tableSubHeadline3 = Antrag der bereits erledigt war, aber aufgrund eines Rechtsbehelfs erneut als Rentenantrag zu behandeln ist - Vertragsrenten;
339 + %let tableFilterVOAT = WHERE VOAT_FILTER IN (60,61,62) AND VTKZ = 2;
340 + %END;
341 + %ELSE %IF &filterVOAT. = ausk %THEN %DO;
342 + %let tableSubHeadline3 = Auskunft an Familiengerichte und sonstige Berechtigte, Antrag nach §§ 33, 35, 37 VersAusglG;
343 + %let tableFilterVOAT = WHERE VOATSO IN (91) AND VOAT_FILTER IN (0);
344 + %END;
345 +
346 + %IF &filterLEAT. = gesamt %THEN %DO;
347 + %let tableSubHeadline4 = ;
Das SAS System
348 + %let tableFilterLEAT = ;
349 + %END;
350 + %ELSE %IF &filterLEAT. = alt %THEN %DO;
351 + %let tableSubHeadline4 = Renten wegen Alters;
352 + %let tableFilterLEAT = AND LEAT_FILTER IN (16,17,18,19,62,63,65);
353 + %END;
354 + %ELSE %IF &filterLEAT. = em %THEN %DO;
355 + %let tableSubHeadline4 = Renten wegen verminderter Erwerbsfähigkeit;
356 + %let tableFilterLEAT = AND LEAT_FILTER IN (11,12,13,14,15,43,71,72,73,74,75,76);
357 + %END;
358 + %ELSE %IF &filterLEAT. = tod %THEN %DO;
359 + %let tableSubHeadline4 = Renten wegen Todes;
360 + %let tableFilterLEAT = AND LEAT_FILTER IN (20,21,25,26,45);
361 + %END;
362 +
363 + %IF &filterWHOT. = gesamt %THEN %DO;
364 + %let tableSubHeadline5 = ;
365 + %let tableFilterWHOT = ;
366 + %END;
367 + %ELSE %IF &filterWHOT. = alt %THEN %DO;
368 + %let tableSubHeadline5 = Ursprüngliches Bundesgebiet;
369 + %let tableFilterWHOT = AND (WHOT_FILTER IN (99999, 00000) OR WHOT_FILTER >=01000 AND WHOT_FILTER < 11200);
370 + %END;
371 + %ELSE %IF &filterWHOT. = neu %THEN %DO;
372 + %let tableSubHeadline5 = Neue Länder und Ostteil Berlins;
373 + %let tableFilterWHOT = AND WHOT_FILTER >=11200 AND WHOT_FILTER < 17000;
374 + %END;
375 +
376 + %let tableFilter = &tableFilterVOAT. &tableFilterBRNR. &tableFilterLEAT. &tableFilterWHOT.;
377 + %put &tableFilter.;
378 +
379 + %let additionalColsSqlQuery = &tableHead., ;
380 + %let classVar = &tableHead.;
381 + %IF &tableHead. = brnr %THEN %DO;
382 + %let tableBox = Versicherungsträger;
383 + %END;
384 + %ELSE %IF &tableHead. = leat %THEN %DO;
385 + %let tableBox = Beantragte Leistungsart~n(Rente);
Das SAS System
386 + %END;
387 + %ELSE %IF &tableHead. = voat %THEN %DO;
388 + %let tableBox = Vorgangsart;
389 + %END;
390 + %ELSE %IF &tableHead. = tlrtal %THEN %DO;
391 + %let tableBox = Beantragter Teilrentenanteil~n(Altersrenten);
392 + %END;
393 + %ELSE %IF &tableHead. = leatso %THEN %DO;
394 + %let tableBox = Beantragte Leistungsart~n(Auskünfte Familiengericht, Härtefälle);
395 + %END;
396 + %ELSE %IF &tableHead. = rtat %THEN %DO;
397 + %let tableBox = Rentenart;
398 + %let classVar = leat;
399 + %let additionalColsSqlQuery = leat, ;
400 + %END;
401 +
402 + %let additionalColsSqlQuery = &additionalColsSqlQuery. &additionalColsForFilter.;
403 +
404 + %put &additionalColsSqlQuery.;
405 + %put &classVar.;
406 +
407 +%mend;
408 +
409 +%macro validateInput;
410 +
411 +%if (&filterVOAT. = ausk & &tableHead. ~= leatso) | (&tableHead. = leatso & &filterVOAT. ~= ausk) %then
412 + %do;
413 + %let printTable = 0;
414 + %let reason = Für die ausgewählte Kombination an Vorgangsartfilter und Vorspalte gibt es keine gültigen Fälle.;
415 + %end;
416 +%else %if &filterLEAT. ~= gesamt & &filterVOAT. = ausk & &tableHead. = leatso %then
417 + %do;
418 + %let printTable = 0;
419 + %let reason = Für die ausgewählte Kombination an Vorgangsartfilter und Rentenart gibt es keine gültigen Fälle.;
420 + %end;
421 +%else %if (&date_end. < &date_begin.) %then
422 + %do;
423 + %let printTable = 0;
Das SAS System
424 + %let reason = 'Monat Beginn' darf nicht nach 'Monat Ende' liegen.;
425 + %end;
426 +%else %if &month_begin_print. = Fehler %then
427 + %do;
428 + %let printTable = 0;
429 + %let reason = Im Feld 'Monat Beginn' wurde kein gültiger Berichtsmonat angegeben.;
430 + %end;
431 +%else %if &month_end_print. = Fehler %then
432 + %do;
433 + %let printTable = 0;
434 + %let reason = Im Feld 'Monat Ende' wurde kein gültiger Berichtsmonat angegeben.;
435 + %end;
436 +
437 +%mend;
438 +
439 +%macro getReportData;
440 +
441 + proc sql noprint;
442 +
443 + connect to ORACLE
444 + (
445 + PATH=&Umgebung. AUTHDOMAIN="ORAAUTH_SYSK85"
446 + );
447 + reset noprint;
448 +
449 + create table save.report_full as
450 + select * from connection to ORACLE
451 + (
452 + select t1.*, (t1.ABST - t1.BERI + t1.ZUG - t1.ERL) AS EBST, (t1.ZUG - t1.BERI) AS ZUG_EFF, (t1.ABST + t1.ZUG - t1.BERI) AS ANTR_INSG, (t1.ABL_WART + t1.ABL_EM + t1.ABL_MW +
452 !+t1.ABL_HINZ + t1.ABL_SONST) AS ABL, (t1.SONST_VSTR + t1.SONST_RUECK + t1.SONST_AND) AS SONST, (t1.ZUG - t1.BERI - t1.ERL) AS AEND_PROZ FROM
453 + (SELECT
454 + &additionalColsSqlQuery. VOAT AS VOAT_FILTER, BRNR AS BRNR_FILTER, LEAT AS LEAT_FILTER, WHOTIN AS WHOT_FILTER, VTKZ, VOATSO,
455 + SUM(CASE WHEN STAND_DATUM < TO_DATE(&date_begin., 'YYYYMMDD') AND AQEQ = 1 then 1 ELSE (CASE WHEN STAND_DATUM < TO_DATE(&date_begin., 'YYYYMMDD') AND AQEQ = 2 AND ELDT <
455 !+&date_begin. THEN -1 ELSE 0 END) END) AS ABST,
456 + SUM(CASE WHEN STAND_DATUM >= TO_DATE(&date_begin., 'YYYYMMDD') AND STAND_DATUM <= TO_DATE(&date_end., 'YYYYMMDD') AND AQEQ = 2 AND ELAT = 98 then 1 ELSE 0 END) AS BERI,
457 + SUM(CASE WHEN STAND_DATUM >= TO_DATE(&date_begin., 'YYYYMMDD') AND STAND_DATUM <= TO_DATE(&date_end., 'YYYYMMDD') AND (AQEQ = 1 OR AQEQ = 3) AND NOT ELAT = 98 then 1 ELSE 0 END)
457 !+ AS ZUG,
458 + SUM(CASE WHEN STAND_DATUM >= TO_DATE(&date_begin., 'YYYYMMDD') AND STAND_DATUM <= TO_DATE(&date_end., 'YYYYMMDD') AND ELAT = 1 then 1 ELSE 0 END) AS BEWI,
Das SAS System
459 + SUM(CASE WHEN STAND_DATUM >= TO_DATE(&date_begin., 'YYYYMMDD') AND STAND_DATUM <= TO_DATE(&date_end., 'YYYYMMDD') AND ELAT = 3 then 1 ELSE 0 END) AS ABL_WART,
460 + SUM(CASE WHEN STAND_DATUM >= TO_DATE(&date_begin., 'YYYYMMDD') AND STAND_DATUM <= TO_DATE(&date_end., 'YYYYMMDD') AND ELAT = 4 then 1 ELSE 0 END) AS ABL_EM,
461 + SUM(CASE WHEN STAND_DATUM >= TO_DATE(&date_begin., 'YYYYMMDD') AND STAND_DATUM <= TO_DATE(&date_end., 'YYYYMMDD') AND ELAT = 5 then 1 ELSE 0 END) AS ABL_MW,
462 + SUM(CASE WHEN STAND_DATUM >= TO_DATE(&date_begin., 'YYYYMMDD') AND STAND_DATUM <= TO_DATE(&date_end., 'YYYYMMDD') AND ELAT = 6 then 1 ELSE 0 END) AS ABL_HINZ,
463 + SUM(CASE WHEN STAND_DATUM >= TO_DATE(&date_begin., 'YYYYMMDD') AND STAND_DATUM <= TO_DATE(&date_end., 'YYYYMMDD') AND ELAT = 7 then 1 ELSE 0 END) AS ABL_SONST,
464 + SUM(CASE WHEN STAND_DATUM >= TO_DATE(&date_begin., 'YYYYMMDD') AND STAND_DATUM <= TO_DATE(&date_end., 'YYYYMMDD') AND ELAT = 10 then 1 ELSE 0 END) AS SONST_VSTR,
465 + SUM(CASE WHEN STAND_DATUM >= TO_DATE(&date_begin., 'YYYYMMDD') AND STAND_DATUM <= TO_DATE(&date_end., 'YYYYMMDD') AND ELAT = 11 then 1 ELSE 0 END) AS SONST_RUECK,
466 + SUM(CASE WHEN STAND_DATUM >= TO_DATE(&date_begin., 'YYYYMMDD') AND STAND_DATUM <= TO_DATE(&date_end., 'YYYYMMDD') AND ELAT = 15 then 1 ELSE 0 END) AS SONST_AND,
467 + SUM(CASE WHEN ((AQEQ = 2 AND NOT ELAT = 98) OR (AQEQ = 3 AND NOT ELAT = 98)) AND STAND_DATUM >= TO_DATE(&date_begin., 'YYYYMMDD') AND STAND_DATUM <= TO_DATE(&date_end.,
467 !+'YYYYMMDD') then 1 ELSE 0 END) AS ERL
468 + From sysk85.CVF_SK85_BESTAND_2019
469 + GROUP BY &additionalColsSqlQuery. VOAT, BRNR, LEAT, WHOTIN, VTKZ, VOATSO) t1
470 + );
471 +
472 + disconnect from ORACLE;
473 +
474 + quit;
475 +
476 +%mend;
477 +
478 +
479 +%macro determineOutput;
480 +
481 +/* PROC SQL step creates a macro variable whose */
482 +/* value will be the number of observations */
483 +/* meeting WHERE clause criteria. */
484 +PROC SQL noprint;
485 +select count(*)
486 +into :numobs
487 +from save.report_full
488 +&tableFilter.;
489 +QUIT;
490 +
491 +
492 +
493 +/* Conditionally execute steps when no observations met criteria. */
494 +%if &numobs.=0 %then
495 + %do;
Das SAS System
496 + %let fmt = allzero.; /* Print all cell values as zeroes */
497 + %let fmt2 = allzero.; /* Print all cell values as zeroes */
498 + %let str = ; /*No Cases in Subset - WHERE cannot be used */
499 + %end;
500 +
501 +%else
502 + %do;
503 + %let fmt = commax20.;
504 + %let fmt2 = commax22.2;
505 + %let str = &tableFilter.;
506 + %end;
507 +
508 +%mend;
509 +
510 +%macro printOutput;
511 +
512 +
513 + /* Erzeugen des Berichts mit PROC TABULATE */
514 + PROC TABULATE DATA=save.report_full f=&fmt.;
515 +
516 +
517 + &str.;
518 +
519 + VAR VOAT_FILTER VOATSO VTKZ ABST ZUG BERI ZUG_EFF ANTR_INSG BEWI ABL ABL_WART ABL_EM ABL_MW ABL_HINZ ABL_SONST SONST SONST_VSTR SONST_RUECK SONST_AND ERL EBST AEND_PROZ;
520 + CLASS &classVar. / MISSING MLF PRELOADFMT order=data;
521 + CLASSLEV &classVar. / S=[background=#F5F5F5/*$VT_BG. font_weight=$VT_FW.*/ foreground=black FONTSIZE=8pt FONTFAMILY="ARIAL"];
522 + TABLE /* Zeilendimension */
523 + &classVar.=''*{style={FONTSIZE=9pt}} ALL={LABEL="Insgesamt" style={background=#EDF2F9 foreground=black FONTSIZE=8pt}}*{style={font_weight=bold background=#EDF2F9 foreground=black
523 !+FONTSIZE=9pt}},
524 + /* Spaltendimension */
525 + ABST={LABEL="Anfangs-~nbestand" style={ background=#F5F5F5 foreground=black FONTSIZE=8pt}}*Sum=''
526 + /*ZUG={LABEL="Zugänge" style={ background=#F5F5F5 foreground=black FONTSIZE=8pt}}*Sum=''*/
527 + /*BERI={LABEL="Berichti-~ngungen" style={ background=#F5F5F5 foreground=black FONTSIZE=8pt}}*Sum=''*/
528 + ZUG_EFF={LABEL="Zugänge~n(effektiv)*" style={ background=#F5F5F5 foreground=black FONTSIZE=8pt}}*Sum=''
529 + ANTR_INSG={LABEL="Anträge~ninsgesamt**" style={ background=#F5F5F5 foreground=black FONTSIZE=8pt}}*Sum=''
530 + ALL={LABEL="Erledigungen" style={ background=#F5F5F5 foreground=black FONTSIZE=8pt}}*(
531 + BEWI={LABEL="Bewilli-~ngungen" style={ background=#F5F5F5 foreground=black FONTSIZE=8pt}}*Sum=''
532 + ALL={LABEL="Ablehnungen" style={ background=#F5F5F5 foreground=black FONTSIZE=8pt}}*(
Das SAS System
533 + ABL={LABEL="insgesamt" style={ background=#F5F5F5 foreground=black FONTSIZE=8pt}}*Sum=''
534 + ABL_WART={LABEL="Wartezeit~nnicht~nerfüllt" style={ background=#F5F5F5 foreground=black FONTSIZE=8pt}}*Sum=''
535 + ABL_EM={LABEL="keine~nvermind.~nErwerbsfä-~nhigkeit" style={ background=#F5F5F5 foreground=black FONTSIZE=8pt}}*Sum=''
536 + ABL_MW={LABEL="mangelnde~nMitwirkung" style={ background=#F5F5F5 foreground=black FONTSIZE=8pt}}*Sum=''
537 + ABL_HINZ={LABEL="Hinzu-~nverdienst-~ngrenze" style={ background=#F5F5F5 foreground=black FONTSIZE=8pt}}*Sum=''
538 + ABL_SONST={LABEL="sonstiger~nGrund" style={ background=#F5F5F5 foreground=black FONTSIZE=8pt}}*Sum='')
539 + ALL={LABEL="sonstige Erledigungen" style={ background=#F5F5F5 foreground=black FONTSIZE=8pt}}*(
540 + SONST={LABEL="insgesamt" style={ background=#F5F5F5 foreground=black FONTSIZE=8pt}}*Sum=''
541 + SONST_VSTR={LABEL="andere~nVSTR" style={ background=#F5F5F5 foreground=black FONTSIZE=8pt}}*Sum=''
542 + SONST_RUECK={LABEL="Rück-~nnahme" style={ background=#F5F5F5 foreground=black FONTSIZE=8pt}}*Sum=''
543 + SONST_AND={LABEL="ander-~nweitige~nErledigung" style={ background=#F5F5F5 foreground=black FONTSIZE=8pt}}*Sum='')
544 + ERL={LABEL="insgesamt" style={ background=#F5F5F5 foreground=black FONTSIZE=8pt}}*Sum='')
545 + EBST={LABEL="Endbestand" style={ background=#F5F5F5 foreground=black FONTSIZE=8pt}}*Sum=''
546 + AEND_PROZ={LABEL="Änderung~nzum An-~nfangs-~nbestand" style={ background=#F5F5F5 foreground=black FONTSIZE=8pt}}*(SUM={LABEL="Anzahl" style={ background=#F5F5F5 foreground=black
546 !+FONTSIZE=8pt}}*f=&fmt. rowpctsum<ABST>={LABEL="in %" style={ background=#F5F5F5 foreground=black FONTSIZE=8pt}}*f=&fmt2.)
547 + / ROW=FLOAT BOX={LABEL="&tableBox." style={VJUST=BOTTOM JUST=LEFT background=#F5F5F5 foreground=black FONTSIZE=8pt}} style={JUST=LEFT} printmiss misstext='0'
548 + ;
549 + format &classVar. &tableHead._RTAQ.;
550 + footnote justify=left '*nach Bestandsberichtigungen';
551 + footnote2 justify=left '**Anfangsbestand + effektive Zugänge';
552 +
553 + %if &pExport.=createXLS %then %do;
554 + ods excel text="~S={just=left}Statistik über Rentenanträge gemäß § 5 RSVwV - &tablemonth.";
555 +
556 + %if &filterBRNR. ~= gesamt %then %do;
557 + ods excel text="~S={just=left}Versicherungsträger = &tableSubHeadline2.";
558 + %end;
559 +
560 + /* Filter für Vorgansgarten immer anzeigen*/
561 + ods excel text="~S={just=left}Vorgangsart = &tableSubHeadline3.";
562 +
563 +
564 + %if &filterLEAT. ~= gesamt %then %do;
565 + ods excel text="~S={just=left}Rentenart = &tableSubHeadline4.";
566 + %end;
567 +
568 + %if &filterWHOT. ~= gesamt %then %do;
569 + ods excel text="~S={just=left}Gebiet = &tableSubHeadline5.";
Das SAS System
570 + %end;
571 +
572 + ods excel text=" ";
573 + %end;
574 + %else %do;
575 + title justify=left "Statistik über Rentenanträge gemäß § 5 RSVwV - &tablemonth.";
576 +
577 + %if &pExport.=createHTML | &pExport.=createPDF %then %do;
578 + %let subHeadlineCount = 2;
579 +
580 + %if &filterBRNR. ~= gesamt %then %do;
581 + title&subHeadlineCount. justify=left "Versicherungsträger = &tableSubHeadline2.";
582 + %incrementvar(subHeadlineCount);
583 + %end;
584 +
585 + /* Filter für Vorgansgarten immer anzeigen*/
586 + title&subHeadlineCount. justify=left "Vorgangsart = &tableSubHeadline3.";
587 + %incrementvar(subHeadlineCount);
588 +
589 + %if &filterLEAT. ~= gesamt %then %do;
590 + title&subHeadlineCount. justify=left "Rentenart = &tableSubHeadline4.";
591 + %incrementvar(subHeadlineCount);
592 + %end;
593 +
594 + %if &filterWHOT. ~= gesamt %then %do;
595 + title&subHeadlineCount. justify=left "Gebiet = &tableSubHeadline5.";
596 + %incrementvar(subHeadlineCount);
597 + %end;
598 + %end;
599 + %end;
600 +
601 + %if &pExport.=createXLS %then %do;
602 + %end;
603 + %else %do;
604 + %if &pExport.=createPDF %then %do;
605 + footnote justify=left '*nach Bestandsberichtigungen';
606 + footnote2 justify=left '**Anfangsbestand + effektive Zugänge';
607 + footnote3 justify=left ' ';
Das SAS System
608 + footnote4 justify=left "%sysfunc(today(),dateFormatStaticReports.) %sysfunc(time(),tod5.) Uhr" justify=right "Seite ~{thispage} von ~{lastpage}";
609 + %end;
610 + %else %do;
611 + footnote justify=left '*nach Bestandsberichtigungen';
612 + footnote2 justify=left '**Anfangsbestand + effektive Zugänge';
613 + footnote3 justify=left ' ';
614 + footnote4 justify=left "%sysfunc(today(),dateFormatStaticReports.) %sysfunc(time(),tod5.) Uhr ";
615 + %end;
616 + footnote5 justify=left '© Deutsche Rentenversicherung Bund';
617 + %end;
618 + RUN;
619 +
620 + %let day = %sysfunc(date(),nldatewn10.);
621 + %let date = %sysfunc(date(),nldate.);
622 + %let time = %sysfunc(time(),hhmm.);
623 + ods excel text="~S={bordercolor=white} ";
624 + ods excel text="*nach Bestandsberichtigungen";
625 + ods excel text="**Anfangsbestand + effektive Zugänge";
626 + ods excel text=" ";
627 + ods excel text="&day., &date. - &time. Uhr";
628 + ods excel text="~S={just=left}© Deutsche Rentenversicherung Bund";
629 +
630 +%mend;
631 +
632 +%macro printError;
633 + data _null_ ;
634 + file print;
635 + put "&reason.";
636 + stop ;
637 + run;
638 +%mend;
639 +
640 +%macro generateReport;
641 + /**************************************************************************************/
642 + /** Wenn keine Tabelle (z.B.wegen fehlerhaften Daten) angezeigt werden soll, */
643 + /** diesen Teil einkommentieren und angezeigten TEXT entsprechend anpassen. */
644 + /**************************************************************************************/
645 + /*%let printTable = 0; */
Das SAS System
646 + /*%let reason = Es stehen momentan leider keine Daten zur Verfügung.; */
647 + /**************************************************************************************/
648 + /** Wenn keine Tabelle (z.B.wegen fehlerhaften Daten) angezeigt werden soll, */
649 + /** diesen Teil einkommentieren und angezeigten TEXT entsprechend anpassen. */
650 + /**************************************************************************************/
651 +
652 +
653 + %getTableTitles;
654 + %validateInput;
655 + %if &printTable.=0 %then %do;
656 + %STPBEGIN;
657 + %printError;
658 + %STPEND;
659 + %end;
660 + %else %do;
661 + %getReportData;
662 + %determineOutput
663 + /* Andruck der Fehlermeldung, falls vorhanden */
664 + %if &printTable.=0 %then
665 + %do;
666 + %STPBEGIN;
667 + %printError;
668 + %STPEND;
669 + %end;
670 + %else %do;
671 + %if &pExport.=createHTML %then %do;
672 +
673 + data _null_;
674 + rc = stpsrv_header('Content-disposition',"attachment; filename=&outputfile..html");
675 + run;
676 +
677 + ods html file=_webout;
678 + %printOutput;
679 + ods html close;
680 +
681 + %end;
682 + %else %if &pExport.=createPDF %then %do;
683 +
Das SAS System
684 + options papersize="ISO A3" orientation=landscape topmargin=0.9cm bottommargin=0.9cm leftmargin=0.9cm rightmargin=0.9cm;
685 +
686 + data _null_;
687 + rc=stpsrv_header('Content-type','application/pdf');
688 + rc=stpsrv_header('Content-disposition',"attachment; filename=&outputfile..pdf");
689 + run;
690 +
691 + ods listing close;
692 +
693 + ods pdf body=_webout;
694 + %printOutput;
695 + ods pdf close;
696 +
697 + %end;
698 + %else %if &pExport.=createXLS %then %do;
699 +
700 + data _null_;
701 + rc = stpsrv_header('Content-type','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
702 + rc = stpsrv_header('Content-disposition',"attachment; filename=&outputfile..xlsx");
703 + run;
704 +
705 + proc template;
706 + define style mystyle;
707 + parent=styles.Plateau;
708 + style usertext from usertext /
709 + bordertopcolor=white
710 + borderbottomcolor=white
711 + borderleftcolor=white
712 + borderrightcolor=white;
713 + end;
714 + run;
715 +
716 + ods excel file = _webout style = mystyle;
717 +
718 + /* Setzen des Blattintervalls auf Table (pro Tabelle ein Tabellenblatt) und Hinterlegung des Blattnamens aus Bericht und Merkmal (z.B. 001.00 Z) */
719 + ods excel options(sheet_interval='table' sheet_name="RTAQ");
720 +
721 + %printOutput;
Das SAS System
722 + ods excel close;
723 +
724 + %end;
725 + %else %do;
726 +
727 + %STPBEGIN;
728 + %printOutput;
729 + %STPEND;
730 +
731 + %end;
732 + %end;
733 + %end;
734 +
735 +%mend;
736 +
737 +%generateReport;
WHERE VOAT_FILTER IN (10,40,41,42,43,44,45,46,60,61,62)
leat,
leat
NOTE: Credential obtained from SAS metadata server.
NOTE: Table SAVE.REPORT_FULL created, with 137306 rows and 26 columns.
NOTE: Verwendet wurde: PROZEDUR SQL - (Gesamtverarbeitungszeit):
real time 22.41 seconds
cpu time 0.81 seconds
NOTE: Verwendet wurde: PROZEDUR SQL - (Gesamtverarbeitungszeit):
real time 0.03 seconds
cpu time 0.03 seconds
NOTE: Verwendet wurde: DATA statement - (Gesamtverarbeitungszeit):
real time 0.00 seconds
cpu time 0.00 seconds
Das SAS System
NOTE: Writing HTML Body file: _WEBOUT
NOTE: There were 102314 observations read from the data set SAVE.REPORT_FULL.
WHERE VOAT_FILTER in (10, 40, 41, 42, 43, 44, 45, 46, 60, 61, 62);
NOTE: The PROCEDURE TABULATE printed pages 1-11.
NOTE: Verwendet wurde: PROZEDUR TABULATE - (Gesamtverarbeitungszeit):
real time 0.27 seconds
cpu time 0.19 seconds
738 +
739 +/*Fehler erzwingen, wenn Log unbedingt angezeigt werden soll.;*/
740 +%let syscc=8;
741 +
742 +
NOTE: %INCLUDE (level 1) ending.
