· 6 years ago · Jul 24, 2019, 11:38 AM
1
2Ошибка Ошибка хранимого процесса
3
4Этот запрос был выполнен с ошибками
5
6
7Журнал SAS
8
91 The SAS System 14:31 Wednesday, July 24, 2019
10
11NOTE: Copyright (c) 2002-2012 by SAS Institute Inc., Cary, NC, USA.
12NOTE: SAS (r) Proprietary Software 9.4 (TS1M3)
13 Licensed to TINKOFF - ANTI-MONEY LAUNDERING, Site 70187129.
14NOTE: This session is executing on the Linux 2.6.32-504.23.4.el6.x86_64 (LIN X64) platform.
15
16
17
18NOTE: Additional host information:
19
20 Linux LIN X64 2.6.32-504.23.4.el6.x86_64 #1 SMP Fri May 29 10:16:43 EDT 2015 x86_64 Red Hat Enterprise Linux Server release 6.6 (Santiago)
21
22You are running SAS 9. Some SAS 8 files will be automatically converted
23by the V9 engine; others are incompatible. Please see
24http://support.sas.com/rnd/migration/planning/platform/64bit.html
25
26PROC MIGRATE will preserve current SAS file attributes and is
27recommended for converting all your SAS libraries from any
28SAS 8 release to SAS 9. For details and examples, please see
29http://support.sas.com/rnd/migration/index.html
30
31
32This message is contained in the SAS news file, and is presented upon
33initialization. Edit the file "news" in the "misc/base" directory to
34display site-specific news and information in the program log.
35The command line option "-nonews" will prevent this display.
36
37
38
39
40NOTE: SAS Initialization used (Total process time):
41 real time 0.00 seconds
42 user cpu time 0.00 seconds
43 system cpu time 0.00 seconds
44 memory 0.00k
45 OS Memory 188756.00k
46 Timestamp 24.07.2019 02:31:10 после полудня
47 Step Count 1911 Switch Count 76
48 Page Faults 0
49 Page Reclaims 6
50 Page Swaps 0
51 Voluntary Context Switches 251
52 Involuntary Context Switches 246
53 Block Input Operations 0
54 Block Output Operations 0
55
56NOTE: The autoexec file, /sas/config/Lev1/SASApp/StoredProcessServer/autoexec.sas, was executed at server initialization.
57
58>>> SAS Macro Variables:
59
60 AMLROOT=/sas/config/Lev1/Applications/SASComplianceSolutions
61 AML_AUTOEXEC_RUN=1
62 AUTOROUTE2CURRENTINVESTIGATOR=N
63 CMNROOT=/sas/config/Lev1/Applications/SASComplianceSolutions
64 COREAUTHDOMAIN=Core
65 COREDBCONNOPTS=path=AML
66 COREDBLIBOPTS=DEFER=YES OR_ENABLE_INTERRUPT=YES DB_LENGTH_SEMANTICS_BYTE=NO DIRECT_EXE=DELETE MULTI_DATASRC_OPT=IN_CLAUSE DBMAX_TEXT=32767 DBCOMMIT=0 READBUFF=1000 INSERTBUFF=1000
67 COREDBUSER=FCFCORE
68 CORESCHEMA=FCFCORE
69 CURRENCY_CODE=
70 DBFLAVOR=oracle
71 DB_CORE_LIBNAME=db_core
72 DB_KC_LIBNAME=db_kc
73 DISPLAY_ALERTS=Y
74 DISPLAY_TRANSACTIONS=Y
75 ECM_CHARMULTIPLIER=1
76 ECM_CONFIG_PATH=/sas/config/Lev1/Applications/SASEnterpriseCaseManagement
77 ECM_CONFIG_UCMACRO_PATH=/sas/config/Lev1/Applications/SASEnterpriseCaseManagement/Source/ucmacros
78 ECM_DBAUTH=casemgmt_db_auth
79 ECM_DBHOST='ds-db-dev.tcsbank.ru'
80 ECM_DBNAME='AML'
81 ECM_DBPORT=1522
82 ECM_DBSERVER=oracle
83 ECM_DB_CONOPTS=path=AML
84 ECM_DEBUG=N
85 ECM_DTFMT=nldate10
86 ECM_DTTMFMT=nldatm20
87 ECM_EFILE_PATH=/sas/config/Lev1/Applications/SASEnterpriseCaseManagement/Source/efiles
88 ECM_ETL_OUTPUT_PATH=/sas/config/Lev1/Applications/SASEnterpriseCaseManagement/Libraries
89 ECM_INSTALL_CMACRO_PATH=/sas/home/SASFoundation/9.4/cmacros/casemgmtmva
90 ECM_INSTALL_UCMACRO_PATH=/sas/home/SASFoundation/9.4/ucmacros/casemgmtmva
91 ECM_MIDTIER_COMPONENT_NM=Ent Case Mgmt Mid-Tier 6.3
92 ECM_RESP_CASE_WF_ACCEPT=''
93 ECM_RESP_CASE_WF_ACCEPT_ERR=''
94 ECM_RESP_CASE_WF_ACCEPT_WARN=''
95 ECM_RESP_CASE_WF_LABEL=''
96 ECM_RESP_CASE_WF_PATH=''
97 ECM_RESP_CASE_WF_REJECT=''
98 ECM_RESP_CASE_WF_UPDT_YN=N
99 ECM_RESP_PARENT_COMMENT_UPDT_YN=Y
100 ECM_RESP_RR_WF_ACCEPT='Accepted'
101 ECM_RESP_RR_WF_ACCEPT_ERR='Accepted with Errors'
102 ECM_RESP_RR_WF_ACCEPT_WARN='Accepted with Warnings'
103 ECM_RESP_RR_WF_LABEL='In Process'
104 ECM_RESP_RR_WF_PATH='/'
105 ECM_RESP_RR_WF_REJECT='Rejected'
106 ECM_RESP_RR_WF_UPDT_YN=Y
107 ECM_RUN_SOAP=Y
108 ECM_SASMISC_PATH=/sas/home/SASFoundation/9.4/misc/casemgmtmva
109 ECM_SDTM_EFILE_PATH_NEWCTR=/sas/config/Lev1/Applications/SASEnterpriseCaseManagement/Source/FINCEN_SDTM_efiles/fincen-newctr-v1
110 ECM_SDTM_EFILE_PATH_SAR=/sas/config/Lev1/Applications/SASEnterpriseCaseManagement/Source/FINCEN_SDTM_efiles/fincen-sar-v1
111 ECM_SDTM_RESP_PATH_NEWCTR=/sas/config/Lev1/Applications/SASEnterpriseCaseManagement/Source/FINCEN_SDTM_responses/fincen-newctr-v1
112 ECM_SDTM_RESP_PATH_SAR=/sas/config/Lev1/Applications/SASEnterpriseCaseManagement/Source/FINCEN_SDTM_responses/fincen-sar-v1
113 ECM_SDTM_SUFFIX_NEWCTR=CTR_ORG
114 ECM_SDTM_SUFFIX_SAR=SAR_ORG
115 ECM_SDTM_YN_NEWCTR=Y
116 ECM_SDTM_YN_SAR=Y
117 ECM_SERVER_COMPONENT_NM=Ent Case Mgmt Server 6.3
118 ECM_SNA_MATCH_LIB=ECM_RPT
119 ECM_UNIX_ZIP_CMD=zip -j
120 ECM_USER=ecmadmin
121 ECM_USER_GROUP=Ent Case Mgmt Users
122 ECM_WEBPASSWORD=
123 ECM_WEBUSERNAME=
124 ECM_WIN_ZIP_CMD=C:\Program Files\WinZip\WZZIP.exe
125 ECM_WSAUTHDOMAIN=DefaultAuth
126 ENABLE_BASE_CURRENCY=N
127 ENABLE_FORMATS=Y
128 FCFDATA=/sas/config/Lev1/Applications/SASComplianceSolutions/data
129 FCFLAND=/sas/config/Lev1/Applications/SASComplianceSolutions/landing
130 FCFROOT=/sas/config/Lev1/Applications/SASComplianceSolutions
131 FCF_APPLICATION_NAME=Compliance Solutions Mid 6.3
132 FCF_AUTOEXEC_RUN=1
133 FCF_BUSINESS_UNIT_NORMALIZED=
134 FCF_CONFIG_LOCALE=en
135 FCF_DAV_ROOT=http://vm-sasaml01t.tcsbank.ru:7980/SASContentServer/repository/default/sasdav/
136 FCF_ENABLE_BULKLOAD=
137 FCF_MAX_UDF_LEN=1024
138 FCF_SOURCE_SYSTEM_CD=FCFBU1
139 FCF_SUPPORTED_LOCALE_LIST=en ar es fr it ja ko nl ru zh_CN
140 FCF_XML_MAP_PATH=/sas/home/SASFoundation/9.4/misc/antimnycmn/xml/map
141 ID=
142 IEM_BRIDGE_LOAD=yes
143 IEM_BULK_LOAD=no
144 IEM_BULK_LOAD_OPTIONS=
145 IEM_PERFORMANCE_LOAD=yes
146 IEM_SAR_TYPE_CD=SAR
147 IEM_SAR_WINDOW=540
148 JOB_RC=1012
149 KCAUTHDOMAIN=Knowledge Center
150 KCDBCONNOPTS=path=AML
151 KCDBLIBOPTS=DEFER=YES OR_ENABLE_INTERRUPT=YES DB_LENGTH_SEMANTICS_BYTE=NO DIRECT_EXE=DELETE MULTI_DATASRC_OPT=IN_CLAUSE DBMAX_TEXT=32767 DBCOMMIT=0 READBUFF=1000 INSERTBUFF=1000
152 KCDBUSER=FCFKC
153 KCSCHEMA=FCFKC
154 KEYS=10170323
155 LOCALE_DEFAULT=ru
156 LOCALE_REPORT=ru_RU
157 LOCALE_SAS=ru_RU
158 ML_RISK=1000
159 MSG_ENCODING=windows
160 MVGDBFGUIDIR=\\v6250-ds\pod_FT$\SAS_AML_TEST
161 MVGDBFNETDIR=/mnt/sas_aml_test
162 MVGDBFSRVDIR=/sas/env/DBF
163 MVGDQDEFLOCALE=RURUS
164 MVGDQDEFSENSITIVITY=90
165 MVGENVDIR=/sas/env
166 MVGFTCMACRODIR=/sas/env/FTC/macro
167 MVGFTCMODULEPATH=/sas/env/FTC
168 MVGGBCORMACRODIR=/sas/env/COR/macro
169 MVGGBCORMAPSDIR=/sas/env/COR/map
170 MVGGBCORPATH=/sas/env/COR
171 MVGMETASERVERHOST=vm-sasaml01t.tcsbank.ru
172 MVGMETASERVERPORT=8561
173 MVGPGUNPENDINGMAP=/sas/env/COR/map/pg_unpending_resp.map
174 MVGPGURL=http://pg-unpending-test.tcsbank.ru/services/
175 MVGSASMACRODIR=/sas/env/sasmacro
176 MVGSASROOT=/sas
177 MVGSNCDJDOWNLOADDIR=/sas/download/SNC
178 MVGSNCDJUPDATESVCLOGIN=tinkWL
179 MVGSNCDJUPDATESVCPWD=Tin1530
180 MVGSNCDJUPDATESVCURL=sftp://djrcfeed.dowjones.com/xml/
181 MVGSNCINITMAPPATH=/sas/env/SNC/src/dj_xml_init/DJ_parse_xml.map
182 MVGSNCMODULEPATH=/sas/env/SNC
183 MVGSNCONLINETRANSCENMAPPATH=/sas/env/SNC/src/dj_xml_init/dj_transaction_map.map
184 MVGSOAPAUTHHOST=vm-sasaml01t.tcsbank.ru
185 MVGSOAPAUTHPORT=7980
186 MVGSOAPECMHOST=vm-sasaml01t.tcsbank.ru
187 MVGSOAPECMLOGIN=sasdemo@host
188 MVGSOAPECMPORT=7980
189 MVGSOAPECMPW={SAS002}B4A65E031BE538CE5958CE40477E27853BEC7FA9
190 MVORACLECONNECTION=connect using SAS_AML as oracle
191 MVORACLECONNECTIONCORE=connect using db_core as oracle
192 NBSP=
193 OMAAUTHDOMAIN=DefaultAuth
194 REPLICATE_SUPPRESSED_ALERTS=N
195 REPLICATION_PERIOD=31
196 RESERVED_CASE_CONFIG=4
197 RESERVED_FINANCIAL_ITEM_CONFIG=7
198 RESERVED_INCIDENT_CONFIG=4
199 RESERVED_PARTY_CONFIG=3
200 RPTXML=
201 RUNASOFDATE=20190701
202 SAMPLESIZE=0
203 SEGKCAUTHDOMAIN=Segmented Knowledge Center
204 SEGKCDBCONNOPTS=path=AML
205 SEGKCDBLIBOPTS=DEFER=YES OR_ENABLE_INTERRUPT=YES DB_LENGTH_SEMANTICS_BYTE=NO DIRECT_EXE=DELETE MULTI_DATASRC_OPT=IN_CLAUSE DBMAX_TEXT=32767 DBCOMMIT=0 READBUFF=1000 INSERTBUFF=1000
206 SEGKCDBUSER=FCFBU1
207 SEGKCSCHEMA=FCFBU1
208 SEG_KC_LIBNAME=seg_kc
209 SERVICE_ENDPOINT=http://vm-sasaml01t.tcsbank.ru:7980/SASWIPSoapServices/services/DAVService
210 SERVICE_IS_SECURED=1
211 SLASH=/
212 SMDDS=sashelp.entcm
213 SYSADMIN=System.Administrator@yourcompany.com
214 SYSDBMSG=
215 SYSDBRC=0
216 SYSDMS=0
217 SYS_SQL_IP_ALL=0
218 SYS_SQL_IP_STMT= select param1."PARM_VALUE", param2."PARM_VALUE" from FSK_SCENARIO scn left join FSK_SCENARIO_PARAMETER param1 on ((param1."SCENARIO_ID" = scn."SCENARIO_ID") and (param1."SEGMENT
219 _ID" = scn."SEGMENT_ID")) and ((param1."PARM_NAME" = 'pSNC_PTYONL_city_regex')) left join FSK_SCENARIO_PARAMETER param2 on ((param2."SCENARIO_ID" = scn."SCENARIO_ID") and (param2."SEGMENT_ID
220 " = scn."SEGMENT_ID")) and ((param2."PARM_NAME" = 'pSNC_PTYONL_region_regex')) where (scn."SCENARIO_NAME" = 'TCS_DJ_TRANSACTION') and (scn."CURRENT_IND" = 'Y')
221 TERADATA_MODE=
222 TF_RISK=1000
223 TRANS_RC=99
224 USE_HP=N
225 USE_ODS=Y
226 WATCH_LIST_PROCESSING_METHOD=HASH_ARRAY
227 _APSLIST=keys,runasofdate,samplesize,msg_encoding,id,use_ods,display_alerts,display_transactions,_srvname,_rmthost,_htcook,_username,_srvport,_reqmeth,_htua,use_hp,_grafloc,_version,_url,_rmtadd
228 r,_reqencoding,_userlocale,_program,_result,_metaperson,_metauser,_metafolder,_client,_SECUREUSERNAME
229 _CLIENT=StoredProcessService 9.4; JVM 1.7.0_76; Linux (amd64) 2.6.32-504.23.4.el6.x86_64
230 _FCFMODULEVER_=6.3HF4 T69004-T68004
231 _FCFMODULE_=
232 _FCFMSG_=ERROR: Выполнение сценария завершилось с ошибками, см. подробности в журнале SAS.
233 _GRAFLOC=/sasweb/graph
234 _HTCOOK=469dd09f9e6e124507b5c3950f7ed592_Cluster1=9195744BB055F2545E2ED9959802128F.469dd09f9e6e124507b5c3950f7ed592_SASServer1_1
235 _HTUA=Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/44.0.2403.157 Safari/537.36
236 _METAFOLDER=/System/Applications/SAS Compliance Solutions/Compliance Solutions Svr 6.3/Application SAS Code/
237 _METAPERSON=sasdemo
238 _METAUSER=sasdemo
239 _PROGRAM=/System/Applications/SAS Compliance Solutions/Compliance Solutions Svr 6.3/Application SAS Code/fcf_sa_test_scenarios_sp
240 _REPLAY="&_URL?_sessionid=0DFCA146-A8B6-A14E-9CE1-5DE64552192B&_program=replay&_entry=&_TMPCAT.."
241 _REQENCODING=UTF-8
242 _REQMETH=GET
243 _RESULT=STREAM
244 _RMTADDR=10.216.25.15
245 _RMTHOST=10.216.25.15
246 _SECUREUSERNAME=sasdemo
247 _SRVNAME=vm-sasaml01t.tcsbank.ru
248 _SRVPORT=7980
249 _TMPCAT=APSWORK.TCAT0060
250 _URL=/SASStoredProcess/do
251 _USERLOCALE=ru_RU
252 _USERNAME=sasdemo
253 _VERSION=Version 9.4 (Build 506)
254
255NOTE: %INCLUDE (level 1) file /sas/config/Lev1/Applications/SASComplianceSolutions/sasstp/fcf_sa_test_scenarios_sp.sas is file
256 /sas/config/Lev1/Applications/SASComplianceSolutions/sasstp/fcf_sa_test_scenarios_sp.sas.
2573 +/* MAINDOC
2584 ++------------------------------------------------------------------------------+
2595 +| NAME: fcf_sa_test_scenarios_sp.sas
2606 +| PRODUCT: SAS Compliance Solutions
2617 +| SYSTEM: Windows, Unix
2628 +| DESC: Stored process to test Scenario Administrator scenarios
2639 ++------------------------------------------------------------------------------+
264 The SAS System
265
26610 +MAINDOCEND */
26711 +
26812 +/*-------------------------------------------------------------------
26913 + * Copyright (c) 2012-2014 by SAS Institute Inc., Cary, NC 27513 USA
27014 + * ---All Rights Reserved.
27115 + *-------------------------------------------------------------------*/
27216 +
27317 +%inc "/sas/config/Lev1/Applications/SASEnterpriseCaseManagement/Source/control/ecm_autoexec.sas";
274NOTE: %INCLUDE (level 2) file /sas/config/Lev1/Applications/SASEnterpriseCaseManagement/Source/control/ecm_autoexec.sas is file
275 /sas/config/Lev1/Applications/SASEnterpriseCaseManagement/Source/control/ecm_autoexec.sas.
27618 +/***********************************************************************************/
27719 +/* Copyright (c) 2009-2010, SAS Institute Inc., Cary, NC, USA, All Rights Reserved */
27820 +/* NAME: ecm_autoexec.sas */
27921 +/* */
28022 +/* PRODUCT: Enterprise Case Management */
28123 +/* PURPOSE: */
28224 +/* */
28325 +/* USAGE: autoexec for the batch programs */
28426 +/* */
28527 +/* PARAMETERS: I|O|U - comments */
28628 +/* DOCUMENT: */
28729 +/* TEST PROGRAM: */
28830 +/* NOTES: */
28931 +/* END */
29032 +/***********************************************************************************/
29133 +
29234 +%macro ecm_setup;
29335 +
29436 +
29537 +
29638 + /* ECM file paths */
29739 + %global ecm_config_path
29840 + ecm_config_ucmacro_path
29941 + ecm_install_ucmacro_path
30042 + ecm_install_cmacro_path
30143 + ecm_etl_output_path
30244 + ecm_sasmisc_path
30345 + ecm_dbserver
304 The SAS System
305
30646 + ecm_dbauth
30747 + ecm_dbname
30848 + ecm_dbhost
30949 + ecm_dbport
31050 + ecm_efile_path
31151 + ecm_wsauthdomain
31252 + ecm_server_component_nm
31353 + ecm_midtier_component_nm
31454 + ;
31555 +
31656 + %let ecm_config_path=/sas/config/Lev1/Applications/SASEnterpriseCaseManagement;
31757 + %let ecm_config_ucmacro_path=/sas/config/Lev1/Applications/SASEnterpriseCaseManagement/Source/ucmacros;
31858 + %let ecm_install_ucmacro_path=/sas/home/SASFoundation/9.4/ucmacros/casemgmtmva;
31959 + %let ecm_install_cmacro_path=/sas/home/SASFoundation/9.4/cmacros/casemgmtmva;
32060 + %let ecm_etl_output_path=/sas/config/Lev1/Applications/SASEnterpriseCaseManagement/Libraries;
32161 + %let ecm_sasmisc_path=/sas/home/SASFoundation/9.4/misc/casemgmtmva;
32262 + %let ecm_dbserver=oracle;
32363 + %let ecm_dbauth=casemgmt_db_auth;
32464 + %let ecm_dbhost='ds-db-dev.tcsbank.ru';
32565 + %let ecm_dbport=1522;
32666 + %let ecm_dbname='AML';
32767 + %let ecm_wsauthdomain=DefaultAuth;
32868 + %let ecm_server_component_nm=Ent Case Mgmt Server 6.3;
32969 + %let ecm_midtier_component_nm=Ent Case Mgmt Mid-Tier 6.3;
33070 +
33171 +
33272 +
33373 +
33474 + %global sysdms /* 0 for SAS non-interactively environment, 1 for SAS interactive enviroment */
33575 + smdds /* location of message file */
33676 + slash /* OS specific directory separator */
33777 + locale_sas /* locale for SAS server */
33878 + locale_default /* default locale */
33979 + locale_report /* locale for reports */
34080 + ;
34181 +
34282 + %let smdds=sashelp.entcm;
34383 + %let locale_sas=%SYSFUNC(getpxlocale()) ;
344 The SAS System
345
34684 + %let locale_default=%substr(&locale_sas,1,2);
34785 + %let locale_report=&locale_sas;
34886 +
34987 + options locale=&locale_sas;
35088 +
35189 + data _null_;
35290 + if getoption('DMS') eq 'NODMS' then call symput('SYSDMS','0');
35391 + else call symput('SYSDMS','1');
35492 +
35593 + if symget('sysscp') eq "WIN" then
35694 + do;
35795 + call symput('slash','\');
35896 + call symput( 'mkdirCmd', 'mkdir');
35997 + call symput( 'moveCmd', 'move/y' );
36098 + call symput( 'copyCmd', 'xcopy');
36199 + call symput( 'delCmd', 'erase' );
362100 + call symput( 'dirCmd', 'dir /B' );
363101 + end;
364102 + else
365103 + do;
366104 + call symput('slash','/');
367105 + call symput( 'mkdirCmd', 'mkdir');
368106 + call symput( 'moveCmd', 'mv -f' );
369107 + call symput( 'copyCmd', 'cp' );
370108 + call symput( 'delCmd', 'rm -f' );
371109 + call symput( 'dirCmd', 'ls' );
372110 + end;
373111 + run;
374112 +
375113 + %let ecm_efile_path=&ecm_config_path&slash.Source&slash.efiles;
376114 +
377115 + %local sasmstore_path;
378116 + %let sasmstore_path=;
379117 + proc sql noprint;
380118 + select distinct quote(strip(path)) into :sasmstore_path separated by ','
381119 + from dictionary.libnames where upcase(libname)=upcase("%sysfunc(getoption(sasmstore))");
382120 + quit;
383121 +
384 The SAS System
385
386122 + %SYSMSTORECLEAR ;
387123 +
388124 + data _null_;
389125 +
390126 + /* Define ucompiled macro search path */
391127 +
392128 + length autocall_path $ 4096
393129 + sasmstore_path $ 4096
394130 + ;
395131 + autocall_path=kcompress(getoption('sasautos'),'()');
396132 +
397133 + if index(upcase(autocall_path),"SASAUTOS") =0 then
398134 + autocall_path='sasautos'||' , '||strip(autocall_path);
399135 + if index(autocall_path,"&ecm_install_ucmacro_path") =0 then
400136 + autocall_path=quote("&ecm_install_ucmacro_path")||' , '||strip(autocall_path);
401137 + if index(autocall_path,"&ecm_config_ucmacro_path") =0 then
402138 + autocall_path=quote("&ecm_config_ucmacro_path")||' , '||strip(autocall_path);
403139 + call execute('options sasautos=('||strip(autocall_path)||');');
404140 +
405141 + /* Define compiled macro search path */
406142 +
407143 + sasmstore_path=symget('sasmstore_path');
408144 + if sasmstore_path ne '' then do;
409145 + if index(sasmstore_path,"&ecm_install_cmacro_path") =0 then
410146 + sasmstore_path=quote("&ecm_install_cmacro_path")||' ,'||strip(sasmstore_path);
411147 + end;
412148 + else sasmstore_path=quote("&ecm_install_cmacro_path");
413149 +
414150 + call execute('libname ECMCMAC ('||strip(sasmstore_path)||') access=readonly;');
415151 + call execute('options sasmstore=ECMCMAC mstored;');
416152 +
417153 +
418154 +
419155 + run;
420156 +
421157 +
422158 + %ecm_global_mvar; /* define more ECM global variables */
423159 +
424 The SAS System
425
426160 +
427161 +
428162 +
429163 + /* Libname to reporting data mart */
430164 + libname ecm_rpt BASE "&ecm_etl_output_path/ecmreport";
431165 + %if (%sysfunc(libref(ecm_rpt))) %then
432166 + %do;
433167 + %put %sysfunc(sysmsg());
434168 + %if ^&SYSDMS %then
435169 + %do;
436170 + %abort return;
437171 + %end;
438172 + %end;
439173 +
440174 +
441175 + /* Libname to regulary form information mart */
442176 + %let form_path=&ecm_config_path&slash.Source&slash.form_template;
443177 + libname ecm_form "&form_path";
444178 +
445179 + %if (%sysfunc(libref(ecm_form))) %then
446180 + %do;
447181 + %put %sysfunc(sysmsg());
448182 + %if ^&SYSDMS %then
449183 + %do;
450184 + %abort return;
451185 + %end;
452186 + %end;
453187 +
454188 +%mend ecm_setup;
455189 +
456190 +options metaserver="vm-sasaml01t.tcsbank.ru" metaport=8561 metarepository="Foundation";
457191 +
458192 +%ecm_setup;
459
460NOTE: DATA statement used (Total process time):
461 real time 0.00 seconds
462 user cpu time 0.01 seconds
463 system cpu time 0.00 seconds
464 The SAS System
465
466 memory 932.09k
467 OS Memory 188752.00k
468 Timestamp 24.07.2019 02:31:10 после полудня
469 Step Count 1912 Switch Count 20
470 Page Faults 0
471 Page Reclaims 125
472 Page Swaps 0
473 Voluntary Context Switches 10
474 Involuntary Context Switches 0
475 Block Input Operations 0
476 Block Output Operations 0
477
478
479NOTE: PROCEDURE SQL used (Total process time):
480 real time 0.00 seconds
481 user cpu time 0.00 seconds
482 system cpu time 0.00 seconds
483 memory 5175.28k
484 OS Memory 193620.00k
485 Timestamp 24.07.2019 02:31:10 после полудня
486 Step Count 1913 Switch Count 14
487 Page Faults 0
488 Page Reclaims 12
489 Page Swaps 0
490 Voluntary Context Switches 0
491 Involuntary Context Switches 0
492 Block Input Operations 0
493 Block Output Operations 0
494
495
496
497NOTE: DATA statement used (Total process time):
498 real time 0.00 seconds
499 user cpu time 0.01 seconds
500 system cpu time 0.00 seconds
501 memory 787.81k
502 OS Memory 189008.00k
503 Timestamp 24.07.2019 02:31:10 после полудня
504 The SAS System
505
506 Step Count 1914 Switch Count 16
507 Page Faults 0
508 Page Reclaims 115
509 Page Swaps 0
510 Voluntary Context Switches 10
511 Involuntary Context Switches 7
512 Block Input Operations 0
513 Block Output Operations 0
514
515
516NOTE: Libref ECMCMAC was successfully assigned as follows:
517 Levels: 5
518 Engine(1): V9
519 Physical Name(1): /sas/config/Lev1/Applications/SASComplianceSolutions/custom/source
520 Engine(2): V9
521 Physical Name(2): /sas/env/sasmacro/sasmacr_fundstracker
522 Engine(3): V9
523 Physical Name(3): /sas/env/sasmacro/sasmarc_replicate
524 Engine(4): V9
525 Physical Name(4): /sas/home/SASFoundation/9.4/cmacros/antimnycmn
526 Engine(5): V9
527 Physical Name(5): /sas/home/SASFoundation/9.4/cmacros/casemgmtmva
528NOTE: Libref ECM_RPT refers to the same physical library as ECM_RPT.
529NOTE: Libref ECM_RPT was successfully assigned as follows:
530 Engine: BASE
531 Physical Name: /sas/config/Lev1/Applications/SASEnterpriseCaseManagement/Libraries/ecmreport
532NOTE: Libref ECM_FORM refers to the same physical library as ECM_FORM.
533NOTE: Libref ECM_FORM was successfully assigned as follows:
534 Engine: V9
535 Physical Name: /sas/config/Lev1/Applications/SASEnterpriseCaseManagement/Source/form_template
536NOTE: %INCLUDE (level 2) ending.
537NOTE: %INCLUDE (level 1) resuming.
538193 +
539194 +%macro aml_setup_test_env();
540195 + %if &use_hp eq Y %then %do;
541196 + %inc "/sas/config/Lev1/Applications/Applications/SASHighPerformanceAntiMoneyLaundering6.3/custom/config/autoexec.sas";
542197 + %end;
543198 + %else %do;
544 The SAS System
545
546199 + %inc "/sas/config/Lev1/Applications/SASComplianceSolutions/custom/config/aml_autoexec.sas";
547200 + %end;
548201 +%mend aml_setup_test_env;
549202 +
550203 +%aml_setup_test_env()
551NOTE: %INCLUDE (level 2) file /sas/config/Lev1/Applications/SASComplianceSolutions/custom/config/aml_autoexec.sas is file
552 /sas/config/Lev1/Applications/SASComplianceSolutions/custom/config/aml_autoexec.sas.
553204 +/* MAINDOC
554205 ++------------------------------------------------------------------------------+
555206 +| NAME: aml_autoexec.sas
556207 +| PRODUCT: SAS Anti-Money Laundering
557208 +| SYSTEM: Windows, Unix
558209 +| DESC: Set up the SAS Anti-Money Laundering environment.
559210 +| Used as an autoexec or include.
560211 ++------------------------------------------------------------------------------+
561212 +MAINDOCEND */
562213 +
563214 +/*-------------------------------------------------------------------
564215 + * Copyright (c) 2012-2014 by SAS Institute Inc., Cary, NC 27513 USA
565216 + * ---All Rights Reserved.
566217 + *-------------------------------------------------------------------*/
567218 +
568219 +%inc "/sas/config/Lev1/Applications/SASComplianceSolutions/custom/config/fcf_autoexec.sas";
569NOTE: %INCLUDE (level 3) file /sas/config/Lev1/Applications/SASComplianceSolutions/custom/config/fcf_autoexec.sas is file
570 /sas/config/Lev1/Applications/SASComplianceSolutions/custom/config/fcf_autoexec.sas.
571220 +/* MAINDOC
572221 ++------------------------------------------------------------------------------+
573222 +| NAME: fcf_autoexec.sas
574223 +| PRODUCT: SAS Compliance Solutions
575224 +| SYSTEM: Windows, Unix
576225 +| DESC: Sets up the SAS Compliance Solutions environment.
577226 ++------------------------------------------------------------------------------+
578227 +| USAGE: Use as an autoexec or include it into another program.
579228 ++-------------+----------------------------------------------------------------+
580229 +MAINDOCEND */
581230 +
582231 +/*-------------------------------------------------------------------
583232 + * Copyright (c) 2012-2014 by SAS Institute Inc., Cary, NC 27513 USA
584 The SAS System
585
586233 + * ---All Rights Reserved.
587234 + *-------------------------------------------------------------------*/
588235 +
589236 +%macro fcf_run_autoexec;
590237 +
591238 + %global fcf_autoexec_run;
592239 +
593240 + /*---------------------------------------
594241 + * Global Error Handling Macro Variables
595242 + *---------------------------------------*/
596243 + %global _fcfmodule_
597244 + _fcfmodulever_
598245 + _fcfmsg_
599246 + job_rc
600247 + trans_rc;
601248 +
602249 + /*---------------------
603250 + * Global FCF settings
604251 + *---------------------*/
605252 + %global ml_risk tf_risk sysadmin fcf_enable_bulkload enable_formats
606253 + enable_base_currency replication_period replicate_suppressed_alerts
607254 + autoroute2currentinvestigator watch_list_processing_method rptxml
608255 + currency_code teradata_mode fcf_application_name fcfroot cmnroot
609256 + fcfdata fcfland fcf_business_unit_normalized fcf_xml_map_path
610257 + fcf_config_locale fcf_supported_locale_list fcf_dav_root
611258 + iem_performance_load iem_bulk_load iem_bulk_load_options iem_bridge_load
612259 + iem_sar_type_cd iem_sar_window
613260 + ;
614261 +
615262 + /* set fcf_config_locale to the default locale */
616263 + /* default.locale is set during deployment to language part of the system locale
617264 + * for zh_* locales it is set as:
618265 + * zh_CN -> zh, zh_TW -> zt, zh_HK -> zt, zh_* -> en
619266 + * fcf_config_locale is set to match the locale names for sashelp files.
620267 + */
621268 + %let fcf_config_locale=en; /* system locale used during install */
622269 + %let fcf_supported_locale_list=en ar es fr it ja ko nl ru zh_CN;
623270 +
624 The SAS System
625
626271 + /*---------------------------------
627272 + * Global DBMS connection settings
628273 + *---------------------------------*/
629274 + %global dbflavor
630275 + kcSchema kcDBUser kcDBConnOpts kcDBLibOpts
631276 + segKCSchema segKCDBUser segKCDBConnOpts segKCDBLibOpts
632277 + coreSchema coreDBUser coreDBConnOpts coreDBLibOpts
633278 + coreAuthDomain kcAuthDomain segkcAuthDomain omaAuthDomain
634279 + db_core_libname db_kc_libname seg_kc_libname fcf_max_udf_len
635280 + ecm_user_group ecm_db_conopts ecm_user
636281 + ;
637282 +
638283 + /*---------------------------------
639284 + * Global ECM reservations.
640285 + *---------------------------------*/
641286 + %global reserved_case_config reserved_incident_config
642287 + reserved_party_config reserved_financial_item_config;
643288 +
644289 + /*---------------------------------------
645290 + * Make sure this code is run only once.
646291 + *---------------------------------------*/
647292 + %if &fcf_autoexec_run ne 1 %then %do;
648293 + %let metaserver = "vm-sasaml01t.tcsbank.ru";
649294 + %let metaport = 8561;
650295 + %let metarepository = "Foundation";
651296 +
652297 + options metaserver = &metaserver
653298 + metaport = &metaport
654299 + metaprotocol = bridge
655300 + metarepository = &metarepository;
656301 +
657302 + /*------------------------------------------------------
658303 + * Set index page size for indexing large unicode values
659304 + *------------------------------------------------------ */
660305 + options ibufsize=32767;
661306 +
662307 + /*-----------------------
663308 + * Assign path to macros
664 The SAS System
665
666309 + *-----------------------*/
667310 + %local fcf_cmacro_path;
668311 + %local fcf_ucmacro_path;
669312 + %let fcf_cmacro_path=/sas/home/SASFoundation/9.4/cmacros/antimnycmn;
670313 + %let fcf_ucmacro_path=/sas/home/SASFoundation/9.4/ucmacros/antimnycmn;
671314 + %let fcf_custsrc_path=/sas/config/Lev1/Applications/SASComplianceSolutions/custom/source;
672315 +
673316 + /*--------------------------
674317 + * Configuration parameters
675318 + *--------------------------*/
676319 + options set=FCFROOT "/sas/config/Lev1/Applications/SASComplianceSolutions";
677320 + %let FCFROOT=%sysfunc(sysget(FCFROOT));
678321 + options set=CMNROOT "/sas/config/Lev1/Applications/SASComplianceSolutions";
679322 + %let CMNROOT=%sysfunc(sysget(CMNROOT));
680323 + options set=FCFDATA "/sas/config/Lev1/Applications/SASComplianceSolutions/data";
681324 + %let FCFDATA=%sysfunc(sysget(FCFDATA));
682325 + options set=FCFLAND "/sas/config/Lev1/Applications/SASComplianceSolutions/landing";
683326 + %let FCFLAND=%sysfunc(sysget(FCFLAND));
684327 +
685328 + %let sysadmin = System.Administrator@yourcompany.com;
686329 +
687330 + /* max size of the CHAR UDF for FCF/AML parties in the ECM database
688331 + * this value is also used when generating XML UI data for ECM, see
689332 + * fcf_write_ecm_ui_xml_data macro.
690333 + */
691334 + %let fcf_max_udf_len = 1024;
692335 +
693336 + /*----------------------------------------------------------
694337 + * Risk Ranking
695338 + * By default, alerts are not create for Risk Factors.
696339 + * TF_RISK and ML_RISK set the score threshold for creating
697340 + * risk factor alerts, the value 1000 means disabled.
698341 + *----------------------------------------------------------*/
699342 + %let tf_risk=1000;
700343 + %let ml_risk=1000;
701344 +
702345 + /*---------------------------------------------------------------
703346 + * Risk Ranking
704 The SAS System
705
706347 + * Sets the maximum number of days of alert history that
707348 + * will be considered as input in the ranking of future alerts.
708349 + *---------------------------------------------------------------*/
709350 + %let replication_period = 31;
710351 +
711352 + /*--------------------------------------------------------------------
712353 + * Replication
713354 + * By default, only transactions for active alerts are replicated.
714355 + * N - replicate transactions for active alerts.
715356 + * Y - replicate transactions for active and batch suppressed alerts.
716357 + *--------------------------------------------------------------------*/
717358 + %let replicate_suppressed_alerts=N;
718359 +
719360 + /*---------------------
720361 + * Match Code Settings
721362 + *---------------------*/
722363 + options DQLOCALE=(ENUSA);
723364 + options DQSETUPLOC="PATH NOT SET";
724365 +
725366 + /*----------------------------------------------------------------------
726367 + * Routing
727368 + * By default, automatically route new alerts to current investigator.
728369 + * Y - Default, automatically route new alerts to current investigator.
729370 + * N - Do NOT automatically route new alerts to current investigator.
730371 + *----------------------------------------------------------------------*/
731372 + %let autoroute2currentinvestigator = N;
732373 +
733374 + /*------------------------------------------------------------------
734375 + * Enable Formats
735376 + * N - Formats are not enabled - valid during installation.
736377 + * Y - Enable formats after the install.sas successfully completes.
737378 + * When set to Y then AGP and Deploy To FCF button in Scenario
738379 + * Administrator execute fcf_create_formats macro.
739380 + *------------------------------------------------------------------*/
740381 + %let enable_formats=Y;
741382 +
742383 + /*---------------------------------------------------------------------------
743384 + * Enable Base Currency
744 The SAS System
745
746385 + * N - Base Currency is not enabled - valid during installation.
747386 + * Y - Base Currency available after the install.sas successfully completes.
748387 + *---------------------------------------------------------------------------*/
749388 + %let enable_base_currency=N;
750389 +
751390 + /*----------------------------------------------------------------------
752391 + * Set get_scenario_performance_stats to Y so fcf_agp_codegen generates
753392 + * code to gather performance statistics for scenarios.
754393 + *----------------------------------------------------------------------*/
755394 + %let get_scenario_performance_stats = N;
756395 +
757396 + /*------------------------------------------------------------------
758397 + * Valid entries: db2, odbc, oracle, sqlserver or teradata:
759398 + * all lower-case
760399 + *------------------------------------------------------------------*/
761400 + %let dbflavor = oracle;
762401 +
763402 +
764403 +
765404 + /*------------------------------------------------------
766405 + * Note: Schema, User and Password must match database
767406 + * and all settings are case sensitive.
768407 + *------------------------------------------------------*/
769408 +
770409 + /*-------------------------
771410 + * Authentication Domains
772411 + *-------------------------*/
773412 + %let coreAuthDomain=Core;
774413 + %let kcAuthDomain=Knowledge Center;
775414 + %let segkcAuthDomain=Segmented Knowledge Center;
776415 + %let omaAuthDomain=DefaultAuth;
777416 +
778417 + /*-------------------------
779418 + * Common Knowledge Center
780419 + *-------------------------*/
781420 + %let kcSchema = FCFKC;
782421 + %let kcDBUser = FCFKC;
783422 + %let kcDBConnOpts = %str(path=AML);
784 The SAS System
785
786423 + %let kcDBLibOpts = %str(DEFER=YES OR_ENABLE_INTERRUPT=YES DB_LENGTH_SEMANTICS_BYTE=NO DIRECT_EXE=DELETE MULTI_DATASRC_OPT=IN_CLAUSE DBMAX_TEXT=32767 DBCOMMIT=0 READBUFF=1000
787423 !+INSERTBUFF=1000);
788424 +
789425 + /*----------------------------
790426 + * Segmented Knowledge Center
791427 + *----------------------------*/
792428 + %let segKCSchema = FCFBU1;
793429 + %let segKCDBUser = FCFBU1;
794430 + %let segKCDBConnOpts = %str(path=AML);
795431 + %let segKCDBLibOpts = %str(DEFER=YES OR_ENABLE_INTERRUPT=YES DB_LENGTH_SEMANTICS_BYTE=NO DIRECT_EXE=DELETE MULTI_DATASRC_OPT=IN_CLAUSE DBMAX_TEXT=32767 DBCOMMIT=0
796431 !+READBUFF=1000 INSERTBUFF=1000);
797432 +
798433 + /*-------------
799434 + * Common Core
800435 + *-------------*/
801436 + %let coreSchema = FCFCORE;
802437 + %let coreDBUser = FCFCORE;
803438 + %let coreDBConnOpts = %str(path=AML);
804439 + %let coreDBLibOpts = %str(DEFER=YES OR_ENABLE_INTERRUPT=YES DB_LENGTH_SEMANTICS_BYTE=NO DIRECT_EXE=DELETE MULTI_DATASRC_OPT=IN_CLAUSE DBMAX_TEXT=32767 DBCOMMIT=0 READBUFF=1000
805439 !+ INSERTBUFF=1000);
806440 +
807441 + /*-------------
808442 + * ECM options
809443 + *-------------*/
810444 + %let ecm_db_conopts=path=AML;
811445 +
812446 + /*-----------------------------------------------------------------------
813447 + * ECM reservations.
814448 + *
815449 + * These values are set based on the maximum key values of the ECM
816450 + * load_post_install_data.sas program.
817451 + *-----------------------------------------------------------------------*/
818452 +
819453 + %let reserved_case_config=4;
820454 + %let reserved_incident_config=4;
821455 + %let reserved_party_config=3;
822456 + %let reserved_financial_item_config=7;
823457 +
824 The SAS System
825
826458 + /*-----------------------------------------------------------------------
827459 + * !! WARNING: It is recommended that you do NOT edit below this line !!
828460 + *-----------------------------------------------------------------------*/
829461 +
830462 + options
831463 + fmtsearch = (work fmts sashelp.mapfmts library)
832464 + mstored
833465 + mexecsize = 128K
834466 + minoperator
835467 + ;
836468 +
837469 + /*----------------------------------
838470 + * Site-specific custom source code
839471 + *----------------------------------*/
840472 + libname custsrc "/sas/config/Lev1/Applications/SASComplianceSolutions/custom/source";
841473 +
842474 + /*---------
843475 + * Formats
844476 + *---------*/
845477 + libname fmts "/sas/config/Lev1/Applications/SASComplianceSolutions/custom/fmts";
846478 +
847479 + /*-----------
848480 + * Job stats
849481 + *-----------*/
850482 + libname job_stat "/sas/config/Lev1/Applications/SASComplianceSolutions/job_stats";
851483 +
852484 + /*-------------
853485 + * Common Data
854486 + *-------------*/
855487 + libname cmndata "/sas/config/Lev1/Applications/SASComplianceSolutions/data";
856488 +
857489 + /*--------
858490 + * Master
859491 + *--------*/
860492 + libname mst_aler '!FCFDATA/master/alert';
861493 + libname mst_prep '!FCFDATA/master/prep';
862494 + libname mst_rpt '!FCFDATA/master/report';
863495 + libname mst_rc '!FCFDATA/master/rc';
864 The SAS System
865
866496 + libname mst_nbrs '!FCFDATA/master/nn';
867497 + libname mst_ca '!FCFDATA/master/ca'; /*Compliance Analytics*/
868498 +
869499 + /*-------
870500 + * Stage
871501 + *-------*/
872502 + libname stg_aler '!FCFDATA/stage/alert';
873503 + libname stg_bdg '!FCFDATA/stage/bridge';
874504 + libname stg_ctrl '!FCFDATA/stage/control';
875505 + libname stg_dim '!FCFDATA/stage/dim';
876506 + libname stg_fact '!FCFDATA/stage/fact';
877507 + libname stg_wtch '!FCFDATA/stage/watchlist';
878508 + libname stg_err '!FCFDATA/stage/error';
879509 + libname stg_rc '!FCFDATA/stage/rc';
880510 + libname stgrcacc '!FCFDATA/stage/rc/acc';
881511 + libname stgrcppf '!FCFDATA/stage/rc/ppf';
882512 + libname stgrcpty '!FCFDATA/stage/rc/pty';
883513 + libname stg_ca '!FCFDATA/stage/ca'; /*Compliance Analytics*/
884514 + libname stg_xref '!FCFDATA/stage/xref';
885515 +
886516 + /*---------
887517 + * SOLR Search
888518 + *---------*/
889519 + libname solr '!FCFDATA/solr';
890520 +
891521 + /*----------------------------------
892522 + * IEM-specific settings
893523 + *----------------------------------*/
894524 + %let ecm_user_group=Ent Case Mgmt Users;
895525 + %let ecm_user=ecmadmin;
896526 + %let iem_performance_load=yes;
897527 + %let iem_bulk_load=no;
898528 + %let iem_bulk_load_options=;
899529 + %let iem_bridge_load=yes;
900530 + %let iem_sar_type_cd=SAR;
901531 + %let iem_sar_window=540;
902532 +
903533 + libname iem '!FCFDATA/iem';
904 The SAS System
905
906534 +
907535 + /*------------------------------
908536 + * Stored Compiled Macro Source
909537 + *------------------------------*/
910538 + %macro fcf_assign_source_library;
911539 + %let old_source_libs = %sysfunc(kcompress(%sysfunc(getoption(sasmstore)),%str(%(%))));
912540 + %if (%sysfunc(libref(source))) ne 0 %then %do; /*returns 0 if already assigned*/
913541 + libname source (custsrc "&fcf_cmacro_path" &old_source_libs) access=readonly;
914542 + %if &syslibrc eq 0 %then %do;
915543 + options sasmstore=source;
916544 + %end;
917545 + %else %do;
918546 + %put ERROR: FCF: Cannot assign SOURCE library.;
919547 + %end;
920548 + %end;
921549 + %else %do;
922550 + %put NOTE: FCF: SOURCE library already assigned.;
923551 + options sasmstore=source;
924552 + %end;
925553 + %mend fcf_assign_source_library;
926554 + %fcf_assign_source_library
927555 +
928556 + /*-----------------------------------------------
929557 + * Figure out what the former autocall path was.
930558 + *-----------------------------------------------*/
931559 + %let old_autocall_path = %sysfunc(kcompress(%sysfunc(getoption(sasautos)),%str(%(%))));
932560 +
933561 + /*-------------------------------------------
934562 + * Add FCF macros in front of existing path.
935563 + *-------------------------------------------*/
936564 + options sasautos=( "&fcf_custsrc_path" "&fcf_ucmacro_path" &old_autocall_path );
937565 +
938566 + /* SCENARIO ADMINISTRATOR */
939567 + libname parms xml '!FCFDATA/scenario/xml/ruleconf.xml';
940568 +
941569 + /*--------------------------------------------
942570 + * Knowledge Center (KC) Database Connections
943571 + *--------------------------------------------*/
944 The SAS System
945
946572 + libname db_kc
947573 + &dbflavor
948574 + authdomain="&kcAuthDomain."
949575 + &kcDBConnOpts
950576 + &kcDBLibOpts;
951577 +
952578 + %if (%sysfunc(libref(db_kc))) %then %do;
953579 + %put %sysfunc(sysmsg());
954580 + %abort cancel 4;
955581 + %end;
956582 +
957583 + %let db_kc_libname = db_kc;
958584 +
959585 + libname seg_kc
960586 + &dbflavor
961587 + authdomain="&segkcAuthDomain."
962588 + &segKCDBConnOpts
963589 + &segKCDBLibOpts;
964590 +
965591 + %if (%sysfunc(libref(seg_kc))) %then %do;
966592 + %put %sysfunc(sysmsg());
967593 + %abort cancel 4;
968594 + %end;
969595 +
970596 + %let seg_kc_libname = seg_kc;
971597 +
972598 + /*---------------------------
973599 + * Core Database Connections
974600 + *---------------------------*/
975601 + libname db_core
976602 + &dbflavor
977603 + authdomain="&coreAuthDomain."
978604 + &coreDBConnOpts
979605 + &coreDBLibOpts;
980606 +
981607 + %if (%sysfunc(libref(db_core))) %then %do;
982608 + %put %sysfunc(sysmsg());
983609 + %abort cancel 4;
984 The SAS System
985
986610 + %end;
987611 +
988612 + %let db_core_libname = db_core;
989613 +
990614 + /*-----------------------------------------------------------------
991615 + * Alert Reminders
992616 + * Used in fcf_notify_manager and fcf_send_alert_reminder,
993617 + * for example: %include custsrc(send_alert_reminder_messages.sas)
994618 + *-----------------------------------------------------------------*/
995619 + filename custsrc "/sas/config/Lev1/Applications/SASComplianceSolutions/custom/source";
996620 +
997621 + /*----------------------
998622 + * Enable Base Currency
999623 + *----------------------*/
1000624 + %macro fcf_enable_base_currency;
1001625 + %if &enable_base_currency eq Y %then %do;
1002626 + proc sql noprint;
1003627 + select lov_type_code into :currency_code
1004628 + from seg_kc.fsk_lov
1005629 + where upcase(lov_type_name) = 'BASE CURRENCY';
1006630 + quit;
1007631 + %end;
1008632 + %else %do;
1009633 + %put NOTE: FCF: Base currency is not enabled.;
1010634 + %end;
1011635 + %mend fcf_enable_base_currency;
1012636 + %fcf_enable_base_currency
1013637 +
1014638 + /*------------------------------
1015639 + * Watch List Processing Method
1016640 + * INDEX_ARRAY - 32-bit OS.
1017641 + * HASH_ARRAY - 64 bit OS.
1018642 + *------------------------------*/
1019643 + %macro fcf_wlproc;
1020644 + %if &sysmaxlong lt 2147483648 %then %do;
1021645 + %let watch_list_processing_method = INDEX_ARRAY;
1022646 + %end;
1023647 + %else %do;
1024 The SAS System
1025
1026648 + %let watch_list_processing_method = HASH_ARRAY;
1027649 + %end;
1028650 + %put ;
1029651 + %put NOTE: WATCH_LIST_PROCESSING_METHOD = &watch_list_processing_method;
1030652 + %mend fcf_wlproc;
1031653 + %fcf_wlproc
1032654 +
1033655 + /*-----------------------------
1034656 + * Display release information
1035657 + *-----------------------------*/
1036658 + %let _fcfmodule_=%str(SAS Compliance Solutions);
1037659 + %let _fcfmsg_=;
1038660 + %put ;
1039661 + %fcf_put_error;
1040662 + %let _fcfmodule_=;
1041663 +
1042664 + /*--------------------------------
1043665 + * Reference the Application Name
1044666 + *--------------------------------*/
1045667 + %let fcf_application_name=%str(Compliance Solutions Mid 6.3);
1046668 +
1047669 + /*-----------------------------------------------------
1048670 + * Location of XML maps for SNA Web Service processing
1049671 + *-----------------------------------------------------*/
1050672 + %let fcf_xml_map_path=%str(/sas/home/SASFoundation/9.4/misc/antimnycmn/xml/map);
1051673 +
1052674 + /*-----------------------------------------------------
1053675 + * ECM Source System Code
1054676 + *-----------------------------------------------------*/
1055677 + %global fcf_source_system_cd;
1056678 + %let fcf_source_system_cd=%str(FCFBU1);
1057679 + %fcf_get_dav_root()
1058680 +
1059681 + /*-----------------------------------------------------
1060682 + * Set to make sure the FCF autoexec is run only once.
1061683 + *-----------------------------------------------------*/
1062684 + %let fcf_autoexec_run = 1;
1063685 + %end;
1064 The SAS System
1065
1066686 +%mend fcf_run_autoexec;
1067687 +%fcf_run_autoexec
1068NOTE: %INCLUDE (level 3) ending.
1069NOTE: %INCLUDE (level 2) resuming.
1070688 +
1071689 +%macro aml_run_autoexec;
1072690 +
1073691 + %global aml_autoexec_run AMLROOT;
1074692 +
1075693 + /*---------------------------------------
1076694 + * Make sure this code is run only once.
1077695 + *---------------------------------------*/
1078696 + %if &aml_autoexec_run ne 1 %then %do;
1079697 +
1080698 + /*-----------------------------
1081699 + * Display release information
1082700 + *-----------------------------*/
1083701 + %let _fcfmodule_=%str(SAS Anti-Money Laundering);
1084702 + %let _fcfmsg_=;
1085703 + %put ;
1086704 + %fcf_put_error;
1087705 + %let _fcfmodule_=;
1088706 +
1089707 + /*--------------------------
1090708 + * Configuration parameters
1091709 + *--------------------------*/
1092710 + options set=AMLROOT "/sas/config/Lev1/Applications/SASComplianceSolutions";
1093711 + %let AMLROOT=%sysfunc(sysget(AMLROOT));
1094712 +
1095713 + /*-----------------------------------------------------
1096714 + * Set to make sure the AML autoexec is run only once.
1097715 + *-----------------------------------------------------*/
1098716 + %let aml_autoexec_run = 1;
1099717 +
1100718 + %end;
1101719 +%mend aml_run_autoexec;
1102720 +%aml_run_autoexec
1103NOTE: %INCLUDE (level 2) ending.
1104 The SAS System
1105
1106NOTE: %INCLUDE (level 1) resuming.
1107721 +
1108722 +/* debug
1109723 + * options mprint mlogic symbolgen;
1110724 + * %let runasofdate=02142012;
1111725 + * %let samplesize=0;
1112726 + * %let msg_encoding=windows;
1113727 + * %let keys=144635;
1114728 +*/
1115729 +%put Test Scenario Parameters:;
1116Test Scenario Parameters:
1117730 +%put &=runasofdate;
1118RUNASOFDATE=20190701
1119731 +%put &=samplesize;
1120SAMPLESIZE=0
1121732 +%put &=msg_encoding;
1122MSG_ENCODING=windows
1123733 +%put &=keys;
1124KEYS=10170323
1125734 +%put &=use_ods;
1126USE_ODS=Y
1127735 +%put &=display_alerts;
1128DISPLAY_ALERTS=Y
1129736 +%put &=display_transactions;
1130DISPLAY_TRANSACTIONS=Y
1131737 +
1132738 +/* ********************************************************************** */
1133739 +/* */
1134740 +/* !! WARNING: It is recommended that you do NOT edit below this line */
1135741 +/* */
1136742 +/* ********************************************************************** */
1137743 +/* path to the scenarios folder on the SAS WEBDAV server */
1138744 +%let scr_dav_path=Products/SASComplianceSolutions/scenarios/;
1139745 +/* path to the headers folder on the SAS WEBDAV server */
1140746 +%let hdr_dav_path=Products/SASComplianceSolutions/headers/;
1141747 +
1142748 +/* ********************************************************************** */
1143749 +/* read Scenario Admin config values from metadata */
1144 The SAS System
1145
1146750 +/* ********************************************************************** */
1147751 +%fcf_sa_read_config_data(app_name=&fcf_application_name)
1148NOTE: Libref FCF_SYNC was successfully assigned as follows:
1149 Engine: V9
1150 Physical Name: /sas/config/Lev1/Applications/SASComplianceSolutions/fcfsync
1151
1152NOTE: DATA statement used (Total process time):
1153 real time 0.23 seconds
1154 user cpu time 0.10 seconds
1155 system cpu time 0.03 seconds
1156 memory 809.21k
1157 OS Memory 188752.00k
1158 Timestamp 24.07.2019 02:31:11 после полудня
1159 Step Count 1915 Switch Count 265
1160 Page Faults 0
1161 Page Reclaims 93
1162 Page Swaps 0
1163 Voluntary Context Switches 1577
1164 Involuntary Context Switches 83
1165 Block Input Operations 0
1166 Block Output Operations 0
1167
1168
1169
1170NOTE: DATA statement used (Total process time):
1171 real time 0.17 seconds
1172 user cpu time 0.07 seconds
1173 system cpu time 0.03 seconds
1174 memory 801.46k
1175 OS Memory 188752.00k
1176 Timestamp 24.07.2019 02:31:11 после полудня
1177 Step Count 1916 Switch Count 253
1178 Page Faults 0
1179 Page Reclaims 90
1180 Page Swaps 0
1181 Voluntary Context Switches 1727
1182 Involuntary Context Switches 912
1183 Block Input Operations 0
1184 The SAS System
1185
1186 Block Output Operations 0
1187
1188
1189
1190NOTE: DATA statement used (Total process time):
1191 real time 0.16 seconds
1192 user cpu time 0.07 seconds
1193 system cpu time 0.02 seconds
1194 memory 800.90k
1195 OS Memory 188752.00k
1196 Timestamp 24.07.2019 02:31:11 после полудня
1197 Step Count 1917 Switch Count 241
1198 Page Faults 0
1199 Page Reclaims 76
1200 Page Swaps 0
1201 Voluntary Context Switches 1536
1202 Involuntary Context Switches 989
1203 Block Input Operations 0
1204 Block Output Operations 0
1205
1206
1207
1208NOTE: DATA statement used (Total process time):
1209 real time 0.12 seconds
1210 user cpu time 0.04 seconds
1211 system cpu time 0.02 seconds
1212 memory 805.03k
1213 OS Memory 188752.00k
1214 Timestamp 24.07.2019 02:31:11 после полудня
1215 Step Count 1918 Switch Count 247
1216 Page Faults 0
1217 Page Reclaims 75
1218 Page Swaps 0
1219 Voluntary Context Switches 1473
1220 Involuntary Context Switches 935
1221 Block Input Operations 0
1222 Block Output Operations 0
1223
1224 The SAS System
1225
1226
1227
1228NOTE: DATA statement used (Total process time):
1229 real time 0.14 seconds
1230 user cpu time 0.06 seconds
1231 system cpu time 0.02 seconds
1232 memory 828.62k
1233 OS Memory 188752.00k
1234 Timestamp 24.07.2019 02:31:11 после полудня
1235 Step Count 1919 Switch Count 283
1236 Page Faults 0
1237 Page Reclaims 76
1238 Page Swaps 0
1239 Voluntary Context Switches 1680
1240 Involuntary Context Switches 671
1241 Block Input Operations 0
1242 Block Output Operations 0
1243
1244
1245
1246NOTE: DATA statement used (Total process time):
1247 real time 0.14 seconds
1248 user cpu time 0.06 seconds
1249 system cpu time 0.02 seconds
1250 memory 800.96k
1251 OS Memory 188752.00k
1252 Timestamp 24.07.2019 02:31:11 после полудня
1253 Step Count 1920 Switch Count 259
1254 Page Faults 0
1255 Page Reclaims 76
1256 Page Swaps 0
1257 Voluntary Context Switches 1578
1258 Involuntary Context Switches 886
1259 Block Input Operations 0
1260 Block Output Operations 0
1261
1262
1263
1264 The SAS System
1265
1266NOTE: DATA statement used (Total process time):
1267 real time 0.21 seconds
1268 user cpu time 0.08 seconds
1269 system cpu time 0.02 seconds
1270 memory 840.03k
1271 OS Memory 188752.00k
1272 Timestamp 24.07.2019 02:31:12 после полудня
1273 Step Count 1921 Switch Count 293
1274 Page Faults 0
1275 Page Reclaims 75
1276 Page Swaps 0
1277 Voluntary Context Switches 1735
1278 Involuntary Context Switches 1053
1279 Block Input Operations 0
1280 Block Output Operations 0
1281
1282
1283NOTE: Codegen location : !AMLROOT/scenario/codegen/
1284NOTE: Header source code path : !AMLROOT/scenario/header_code_active/
1285NOTE: Scenario source code path : !AMLROOT/scenario/scenario_code_active/
1286NOTE: Logs path : !AMLROOT/logs/
1287NOTE: Backups path : !CMNROOT/backups/
1288NOTE: Number of backup generations: 99
1289NOTE: Prep data sets library name : MST_PREP
1290752 +
1291753 +%let trans_rc = 0;
1292754 +%let sqlrc = 0;
1293755 +%let sqlxrc = 0;
1294756 +%let sysrc = 0;
1295757 +%let fcf_sa_test_scenarios_sp_running=0;
1296758 +
1297759 +%let fcf_test_error_msg=;
1298760 +
1299761 +%macro fcf_sa_generate_error_msg (msg=);
1300762 + %let fcf_test_error_msg=&msg;
1301763 + %fcf_put_error
1302764 +%mend fcf_sa_generate_error_msg;
1303765 +
1304 The SAS System
1305
1306766 +%macro fcf_sa_abort(msg=, p1=, p2=, p3=, p4=);
1307767 + %let parm_list=;
1308768 + %if "&p1" ne "" %then %do; %let parm_list =, &p1; %end;
1309769 + %if "&p2" ne "" %then %do; %let parm_list =&parm_list , &p2; %end;
1310770 + %if "&p3" ne "" %then %do; %let parm_list =&parm_list , &p3; %end;
1311771 + %if "&p4" ne "" %then %do; %let parm_list =&parm_list , &p4; %end;
1312772 +
1313773 + %let _fcfmsg_=ERROR: %sysfunc(sasmsg(sashelp.fcfmsg, &msg, N &parm_list));
1314774 + %let trans_rc = 99;
1315775 + %fcf_clear_sync_lock(fcf_sync_job_ds=&fcf_sync_job_ds)
1316776 + %fcf_sa_generate_error_msg(msg=&_fcfmsg_);
1317777 + %if &use_hp eq Y %then %do;
1318778 + PROC LASR STOP;
1319779 + RUN;
1320780 + %end;
1321781 + data _null_;
1322782 + ABORT CANCEL;
1323783 + run;
1324784 +%mend fcf_sa_abort;
1325785 +
1326786 +%macro fcf_sa_abort_on_error(msg=, p1=, p2=, p3=, p4=);
1327787 + %fcf_chkrc
1328788 + %if &bat_abort=Y %then %do;
1329789 + %let sys_err_msg = &bat_errmsg;
1330790 + %let parm_list=;
1331791 + %if "&p1" ne "" %then %do; %let parm_list =, &p1; %end;
1332792 + %if "&p2" ne "" %then %do; %let parm_list =&parm_list , &p2; %end;
1333793 + %if "&p3" ne "" %then %do; %let parm_list =&parm_list , &p3; %end;
1334794 + %if "&p4" ne "" %then %do; %let parm_list =&parm_list , &p4; %end;
1335795 +
1336796 + %let _fcfmsg_=ERROR: %sysfunc(sasmsg(sashelp.fcfmsg, &msg, N &parm_list));
1337797 + %let trans_rc = 99;
1338798 + %fcf_clear_sync_lock(fcf_sync_job_ds=&fcf_sync_job_ds)
1339799 + %fcf_sa_generate_error_msg(msg=&_fcfmsg_);
1340800 + %if &use_hp eq Y %then %do;
1341801 + PROC LASR STOP;
1342802 + RUN;
1343803 + %end;
1344 The SAS System
1345
1346804 + data _null_;
1347805 + ABORT CANCEL;
1348806 + run;
1349807 + %end;
1350808 +%mend fcf_sa_abort_on_error;
1351809 +
1352810 +%macro fcf_sa_create_datasets;
1353811 + data work.fsk_header ;
1354812 + set seg_kc.fsk_header;
1355813 + stop;
1356814 + run;
1357815 + %fcf_sa_abort_on_error(msg=sa_cannot_create_ds, p1=fsk_header, p2=work)
1358816 + data work.fsk_header_element ;
1359817 + set seg_kc.fsk_header_element;
1360818 + stop;
1361819 + run;
1362820 + %fcf_sa_abort_on_error(msg=sa_cannot_create_ds, p1=fsk_header_element, p2=work)
1363821 + data work.fsk_scenario ;
1364822 + set seg_kc.fsk_scenario;
1365823 + stop;
1366824 + run;
1367825 + %fcf_sa_abort_on_error(msg=sa_cannot_create_ds, p1=fsk_scenario, p2=work)
1368826 + data work.fsk_scenario_parameter ;
1369827 + set seg_kc.fsk_scenario_parameter;
1370828 + stop;
1371829 + run;
1372830 + %fcf_sa_abort_on_error(msg=sa_cannot_create_ds, p1=fsk_scenario_alert_column, p2=work)
1373831 + data work.fsk_scenario_alert_column;
1374832 + set seg_kc.fsk_scenario_alert_column;
1375833 + stop;
1376834 + run;
1377835 + %fcf_sa_abort_on_error(msg=sa_cannot_create_ds, p1=fsk_scenario_parameter, p2=work)
1378836 + data work.fsk_routing_group ;
1379837 + set seg_kc.fsk_routing_group;
1380838 + stop;
1381839 + run;
1382840 + %fcf_sa_abort_on_error(msg=sa_cannot_create_ds, p1=fsk_routing_group, p2=work)
1383841 + data work.fsk_routing_rule ;
1384 The SAS System
1385
1386842 + set seg_kc.fsk_routing_rule;
1387843 + stop;
1388844 + run;
1389845 + %fcf_sa_abort_on_error(msg=sa_cannot_create_ds, p1=fsk_routing_rule, p2=work)
1390846 + data work.fsk_routing_constraint ;
1391847 + set seg_kc.fsk_routing_constraint;
1392848 + stop;
1393849 + run;
1394850 + %fcf_sa_abort_on_error(msg=sa_cannot_create_ds, p1=fsk_routing_constraint, p2=work)
1395851 +
1396852 + data work.FSK_SCENARIO_FILTER;
1397853 + set seg_kc.FSK_SCENARIO_FILTER;
1398854 + stop;
1399855 + run;
1400856 + %fcf_sa_abort_on_error(msg=sa_cannot_create_ds, p1=FSK_SCENARIO_FILTER, p2=work)
1401857 +
1402858 + data work.FSK_SCENARIO_FILTER_VARIABLE ;
1403859 + set seg_kc.FSK_SCENARIO_FILTER_VARIABLE;
1404860 + stop;
1405861 + run;
1406862 + %fcf_sa_abort_on_error(msg=sa_cannot_create_ds, p1=FSK_SCENARIO_FILTER_VARIABLE, p2=work)
1407863 + data work.FSK_SCENARIO_FILTER_CONSTRAINT ;
1408864 + set seg_kc.FSK_SCENARIO_FILTER_CONSTRAINT;
1409865 + stop;
1410866 + run;
1411867 + %fcf_sa_abort_on_error(msg=sa_cannot_create_ds, p1=FSK_SCENARIO_FILTER_CONSTRAINT, p2=work)
1412868 + data work.FSK_SCENARIO_MESSAGE_PARAMETER ;
1413869 + set seg_kc.FSK_SCENARIO_MESSAGE_PARAMETER;
1414870 + stop;
1415871 + run;
1416872 + %fcf_sa_abort_on_error(msg=sa_cannot_create_ds, p1=FSK_SCENARIO_MESSAGE_PARAMETER, p2=work)
1417873 + data work.FSK_SCENARIO_ALERT_CONSTRAINT ;
1418874 + set seg_kc.FSK_SCENARIO_ALERT_CONSTRAINT;
1419875 + stop;
1420876 + run;
1421877 + %fcf_sa_abort_on_error(msg=sa_cannot_create_ds, p1=FSK_SCENARIO_ALERT_CONSTRAINT, p2=work)
1422878 + data work.FSK_SCENARIO_MESSAGE;
1423879 + set seg_kc.FSK_SCENARIO_MESSAGE;
1424 The SAS System
1425
1426880 + /* TODO: copy full ds now, but it should be extracted from ECM, so add stop when fixed */;
1427881 + run;
1428882 + %fcf_sa_abort_on_error(msg=sa_cannot_create_ds, p1=FSK_SCENARIO_MESSAGE, p2=WORK)
1429883 + data work.FSK_SCENARIO_LOCALIZED_MSG;
1430884 + set seg_kc.FSK_SCENARIO_LOCALIZED_MSG;
1431885 + stop;
1432886 + run;
1433887 + %fcf_sa_abort_on_error(msg=sa_cannot_create_ds, p1=FSK_SCENARIO_LOCALIZED_MSG, p2=WORK)
1434888 +%mend fcf_sa_create_datasets;
1435889 +
1436890 +%ecm_db_connect
1437NOTE: Libref ECM_DB was successfully assigned as follows:
1438 Engine: ORACLE
1439 Physical Name: AML
1440NOTE: Libref ECM_TMP was successfully assigned as follows:
1441 Engine: ORACLE
1442 Physical Name: AML
1443891 +
1444892 +/* lock on the dataset to make sure that only one critical job is running */
1445893 +%macro fcf_sa_sync_lock();
1446894 + %fcf_sync_lock(fcf_sync_job_ds=&fcf_sync_job_ds)
1447895 + %if &fcf_sync_lock_failed eq Y %then %do;
1448896 + %fcf_sa_abort(msg=fcf_critical_update_in_process, p1=&fcf_sync_job_ds)
1449897 + %end;
1450898 +%mend fcf_sa_sync_lock;
1451899 +
1452900 +%fcf_sa_sync_lock();
1453NOTE: FCF_SYNC.FCF_SA_SYNC_MUTEX.DATA is now locked for exclusive access by you.
1454901 +
1455902 +%let sysrc = 0;
1456903 +%fcf_sa_create_datasets
1457
1458NOTE: There were 1 observations read from the data set SEG_KC.FSK_HEADER.
1459NOTE: The data set WORK.FSK_HEADER has 0 observations and 15 variables.
1460NOTE: DATA statement used (Total process time):
1461 real time 0.01 seconds
1462 user cpu time 0.01 seconds
1463 system cpu time 0.00 seconds
1464 The SAS System
1465
1466 memory 5868.81k
1467 OS Memory 193824.00k
1468 Timestamp 24.07.2019 02:31:12 после полудня
1469 Step Count 1922 Switch Count 25
1470 Page Faults 0
1471 Page Reclaims 557
1472 Page Swaps 0
1473 Voluntary Context Switches 32
1474 Involuntary Context Switches 20
1475 Block Input Operations 0
1476 Block Output Operations 0
1477
1478
1479NOTE: {START: fcf_chkrc}
1480NOTE: {END: fcf_chkrc}
1481
1482NOTE: There were 1 observations read from the data set SEG_KC.FSK_HEADER_ELEMENT.
1483NOTE: The data set WORK.FSK_HEADER_ELEMENT has 0 observations and 7 variables.
1484NOTE: DATA statement used (Total process time):
1485 real time 0.01 seconds
1486 user cpu time 0.01 seconds
1487 system cpu time 0.00 seconds
1488 memory 1744.34k
1489 OS Memory 189896.00k
1490 Timestamp 24.07.2019 02:31:12 после полудня
1491 Step Count 1923 Switch Count 21
1492 Page Faults 0
1493 Page Reclaims 216
1494 Page Swaps 0
1495 Voluntary Context Switches 35
1496 Involuntary Context Switches 19
1497 Block Input Operations 0
1498 Block Output Operations 0
1499
1500
1501NOTE: {START: fcf_chkrc}
1502NOTE: {END: fcf_chkrc}
1503NOTE: There were 1 observations read from the data set SEG_KC.FSK_SCENARIO.
1504 The SAS System
1505
1506NOTE: The data set WORK.FSK_SCENARIO has 0 observations and 35 variables.
1507NOTE: DATA statement used (Total process time):
1508 real time 0.01 seconds
1509 user cpu time 0.01 seconds
1510 system cpu time 0.01 seconds
1511 memory 8562.75k
1512 OS Memory 196480.00k
1513 Timestamp 24.07.2019 02:31:12 после полудня
1514 Step Count 1924 Switch Count 23
1515 Page Faults 0
1516 Page Reclaims 683
1517 Page Swaps 0
1518 Voluntary Context Switches 42
1519 Involuntary Context Switches 30
1520 Block Input Operations 0
1521 Block Output Operations 0
1522
1523
1524NOTE: {START: fcf_chkrc}
1525NOTE: {END: fcf_chkrc}
1526NOTE: There were 1 observations read from the data set SEG_KC.FSK_SCENARIO_PARAMETER.
1527NOTE: The data set WORK.FSK_SCENARIO_PARAMETER has 0 observations and 5 variables.
1528NOTE: DATA statement used (Total process time):
1529 real time 0.01 seconds
1530 user cpu time 0.01 seconds
1531 system cpu time 0.00 seconds
1532 memory 7448.43k
1533 OS Memory 195616.00k
1534 Timestamp 24.07.2019 02:31:12 после полудня
1535 Step Count 1925 Switch Count 20
1536 Page Faults 0
1537 Page Reclaims 645
1538 Page Swaps 0
1539 Voluntary Context Switches 42
1540 Involuntary Context Switches 10
1541 Block Input Operations 0
1542 Block Output Operations 0
1543
1544 The SAS System
1545
1546
1547NOTE: {START: fcf_chkrc}
1548NOTE: {END: fcf_chkrc}
1549
1550NOTE: There were 0 observations read from the data set SEG_KC.FSK_SCENARIO_ALERT_COLUMN.
1551NOTE: The data set WORK.FSK_SCENARIO_ALERT_COLUMN has 0 observations and 3 variables.
1552NOTE: DATA statement used (Total process time):
1553 real time 0.00 seconds
1554 user cpu time 0.01 seconds
1555 system cpu time 0.00 seconds
1556 memory 930.25k
1557 OS Memory 188752.00k
1558 Timestamp 24.07.2019 02:31:12 после полудня
1559 Step Count 1926 Switch Count 21
1560 Page Faults 0
1561 Page Reclaims 96
1562 Page Swaps 0
1563 Voluntary Context Switches 40
1564 Involuntary Context Switches 13
1565 Block Input Operations 0
1566 Block Output Operations 0
1567
1568
1569NOTE: {START: fcf_chkrc}
1570NOTE: {END: fcf_chkrc}
1571
1572NOTE: There were 0 observations read from the data set SEG_KC.FSK_ROUTING_GROUP.
1573NOTE: The data set WORK.FSK_ROUTING_GROUP has 0 observations and 3 variables.
1574NOTE: DATA statement used (Total process time):
1575 real time 0.00 seconds
1576 user cpu time 0.00 seconds
1577 system cpu time 0.00 seconds
1578 memory 1021.25k
1579 OS Memory 188780.00k
1580 Timestamp 24.07.2019 02:31:12 после полудня
1581 Step Count 1927 Switch Count 21
1582 Page Faults 0
1583 Page Reclaims 106
1584 The SAS System
1585
1586 Page Swaps 0
1587 Voluntary Context Switches 35
1588 Involuntary Context Switches 6
1589 Block Input Operations 0
1590 Block Output Operations 0
1591
1592
1593NOTE: {START: fcf_chkrc}
1594NOTE: {END: fcf_chkrc}
1595NOTE: There were 0 observations read from the data set SEG_KC.FSK_ROUTING_RULE.
1596NOTE: The data set WORK.FSK_ROUTING_RULE has 0 observations and 7 variables.
1597NOTE: DATA statement used (Total process time):
1598 real time 0.00 seconds
1599 user cpu time 0.01 seconds
1600 system cpu time 0.00 seconds
1601 memory 1836.12k
1602 OS Memory 189988.00k
1603 Timestamp 24.07.2019 02:31:12 после полудня
1604 Step Count 1928 Switch Count 19
1605 Page Faults 0
1606 Page Reclaims 204
1607 Page Swaps 0
1608 Voluntary Context Switches 27
1609 Involuntary Context Switches 2
1610 Block Input Operations 0
1611 Block Output Operations 0
1612
1613
1614NOTE: {START: fcf_chkrc}
1615NOTE: {END: fcf_chkrc}
1616NOTE: There were 0 observations read from the data set SEG_KC.FSK_ROUTING_CONSTRAINT.
1617NOTE: The data set WORK.FSK_ROUTING_CONSTRAINT has 0 observations and 7 variables.
1618NOTE: DATA statement used (Total process time):
1619 real time 0.00 seconds
1620 user cpu time 0.01 seconds
1621 system cpu time 0.00 seconds
1622 memory 6323.65k
1623 OS Memory 194408.00k
1624 The SAS System
1625
1626 Timestamp 24.07.2019 02:31:12 после полудня
1627 Step Count 1929 Switch Count 23
1628 Page Faults 0
1629 Page Reclaims 654
1630 Page Swaps 0
1631 Voluntary Context Switches 23
1632 Involuntary Context Switches 3
1633 Block Input Operations 0
1634 Block Output Operations 0
1635
1636
1637NOTE: {START: fcf_chkrc}
1638NOTE: {END: fcf_chkrc}
1639
1640NOTE: There were 0 observations read from the data set SEG_KC.FSK_SCENARIO_FILTER.
1641NOTE: The data set WORK.FSK_SCENARIO_FILTER has 0 observations and 6 variables.
1642NOTE: DATA statement used (Total process time):
1643 real time 0.00 seconds
1644 user cpu time 0.01 seconds
1645 system cpu time 0.00 seconds
1646 memory 1212.65k
1647 OS Memory 189068.00k
1648 Timestamp 24.07.2019 02:31:12 после полудня
1649 Step Count 1930 Switch Count 21
1650 Page Faults 0
1651 Page Reclaims 117
1652 Page Swaps 0
1653 Voluntary Context Switches 33
1654 Involuntary Context Switches 9
1655 Block Input Operations 0
1656 Block Output Operations 0
1657
1658
1659NOTE: {START: fcf_chkrc}
1660NOTE: {END: fcf_chkrc}
1661
1662NOTE: There were 0 observations read from the data set SEG_KC.FSK_SCENARIO_FILTER_VARIABLE.
1663NOTE: The data set WORK.FSK_SCENARIO_FILTER_VARIABLE has 0 observations and 4 variables.
1664 The SAS System
1665
1666NOTE: DATA statement used (Total process time):
1667 real time 0.00 seconds
1668 user cpu time 0.01 seconds
1669 system cpu time 0.00 seconds
1670 memory 1126.25k
1671 OS Memory 189068.00k
1672 Timestamp 24.07.2019 02:31:12 после полудня
1673 Step Count 1931 Switch Count 25
1674 Page Faults 0
1675 Page Reclaims 125
1676 Page Swaps 0
1677 Voluntary Context Switches 40
1678 Involuntary Context Switches 12
1679 Block Input Operations 0
1680 Block Output Operations 0
1681
1682
1683NOTE: {START: fcf_chkrc}
1684NOTE: {END: fcf_chkrc}
1685
1686NOTE: There were 0 observations read from the data set SEG_KC.FSK_SCENARIO_FILTER_CONSTRAINT.
1687NOTE: The data set WORK.FSK_SCENARIO_FILTER_CONSTRAINT has 0 observations and 8 variables.
1688NOTE: DATA statement used (Total process time):
1689 real time 0.01 seconds
1690 user cpu time 0.02 seconds
1691 system cpu time 0.00 seconds
1692 memory 2681.00k
1693 OS Memory 190660.00k
1694 Timestamp 24.07.2019 02:31:12 после полудня
1695 Step Count 1932 Switch Count 21
1696 Page Faults 0
1697 Page Reclaims 280
1698 Page Swaps 0
1699 Voluntary Context Switches 38
1700 Involuntary Context Switches 6
1701 Block Input Operations 0
1702 Block Output Operations 0
1703
1704 The SAS System
1705
1706
1707NOTE: {START: fcf_chkrc}
1708NOTE: {END: fcf_chkrc}
1709NOTE: There were 0 observations read from the data set SEG_KC.FSK_SCENARIO_MESSAGE_PARAMETER.
1710NOTE: The data set WORK.FSK_SCENARIO_MESSAGE_PARAMETER has 0 observations and 5 variables.
1711NOTE: DATA statement used (Total process time):
1712 real time 0.00 seconds
1713 user cpu time 0.00 seconds
1714 system cpu time 0.00 seconds
1715 memory 1206.84k
1716 OS Memory 189100.00k
1717 Timestamp 24.07.2019 02:31:12 после полудня
1718 Step Count 1933 Switch Count 19
1719 Page Faults 0
1720 Page Reclaims 122
1721 Page Swaps 0
1722 Voluntary Context Switches 23
1723 Involuntary Context Switches 6
1724 Block Input Operations 0
1725 Block Output Operations 0
1726
1727
1728NOTE: {START: fcf_chkrc}
1729NOTE: {END: fcf_chkrc}
1730NOTE: There were 0 observations read from the data set SEG_KC.FSK_SCENARIO_ALERT_CONSTRAINT.
1731NOTE: The data set WORK.FSK_SCENARIO_ALERT_CONSTRAINT has 0 observations and 8 variables.
1732NOTE: DATA statement used (Total process time):
1733 real time 0.01 seconds
1734 user cpu time 0.01 seconds
1735 system cpu time 0.00 seconds
1736 memory 2681.00k
1737 OS Memory 190660.00k
1738 Timestamp 24.07.2019 02:31:12 после полудня
1739 Step Count 1934 Switch Count 19
1740 Page Faults 0
1741 Page Reclaims 280
1742 Page Swaps 0
1743 Voluntary Context Switches 25
1744 The SAS System
1745
1746 Involuntary Context Switches 4
1747 Block Input Operations 0
1748 Block Output Operations 0
1749
1750
1751NOTE: {START: fcf_chkrc}
1752NOTE: {END: fcf_chkrc}
1753NOTE: There were 67 observations read from the data set SEG_KC.FSK_SCENARIO_MESSAGE.
1754NOTE: The data set WORK.FSK_SCENARIO_MESSAGE has 67 observations and 3 variables.
1755NOTE: Compressing data set WORK.FSK_SCENARIO_MESSAGE increased size by 100.00 percent.
1756 Compressed is 2 pages; un-compressed would require 1 pages.
1757NOTE: DATA statement used (Total process time):
1758 real time 0.01 seconds
1759 user cpu time 0.01 seconds
1760 system cpu time 0.01 seconds
1761 memory 3986.18k
1762 OS Memory 191784.00k
1763 Timestamp 24.07.2019 02:31:12 после полудня
1764 Step Count 1935 Switch Count 23
1765 Page Faults 0
1766 Page Reclaims 421
1767 Page Swaps 0
1768 Voluntary Context Switches 40
1769 Involuntary Context Switches 4
1770 Block Input Operations 0
1771 Block Output Operations 0
1772
1773
1774NOTE: {START: fcf_chkrc}
1775NOTE: {END: fcf_chkrc}
1776
1777NOTE: There were 0 observations read from the data set SEG_KC.FSK_SCENARIO_LOCALIZED_MSG.
1778NOTE: The data set WORK.FSK_SCENARIO_LOCALIZED_MSG has 0 observations and 3 variables.
1779NOTE: DATA statement used (Total process time):
1780 real time 0.00 seconds
1781 user cpu time 0.01 seconds
1782 system cpu time 0.00 seconds
1783 memory 1996.71k
1784 The SAS System
1785
1786 OS Memory 189828.00k
1787 Timestamp 24.07.2019 02:31:12 после полудня
1788 Step Count 1936 Switch Count 25
1789 Page Faults 0
1790 Page Reclaims 217
1791 Page Swaps 0
1792 Voluntary Context Switches 31
1793 Involuntary Context Switches 7
1794 Block Input Operations 0
1795 Block Output Operations 0
1796
1797
1798NOTE: {START: fcf_chkrc}
1799NOTE: {END: fcf_chkrc}
1800904 +
1801905 +%macro fcf_sa_ods_output();
1802906 + %STPBEGIN;
1803907 + %fcf_sa_ods_test_output(seg_kc_lib=work, runasofdate=&runasofdate, samplesize=&samplesize, msg_encoding=&msg_encoding,
1804908 + display_alerts=&display_alerts, fcf_sa_all_alerts_ds=&fcf_sa_all_alerts_ds,
1805909 + display_transactions=&display_transactions, fcf_sa_all_trans_keys=&fcf_sa_all_trans_keys );
1806910 + %STPEND;
1807911 +%mend fcf_sa_ods_output;
1808912 +
1809913 +/****************************************************************************
1810914 + ** Return the result: error messages or success message
1811915 + ****************************************************************************/
1812916 +%macro fcf_sa_update_rc();
1813917 + %fcf_clear_sync_lock(fcf_sync_job_ds=&fcf_sync_job_ds)
1814918 + %if &fcf_test_error_msg ne %then %do;
1815919 + /* tests has not been run, report an error */
1816920 + %let fcssa_msg1=%sysfunc(sasmsg(sashelp.fcfmsg, sa_test_sp_scenario_errors_msg, N));
1817921 + %let fcssa_msg2=%sysfunc(sasmsg(sashelp.fcfmsg, sa_test_sp_parm_msg, N, &runasofdate, &samplesize, &msg_encoding ));
1818922 + data err_msg;
1819923 + length msg $256;
1820924 + msg = "&fcssa_msg1";
1821925 + output;
1822926 + msg = "&fcssa_msg2";
1823927 + output;
1824 The SAS System
1825
1826928 + msg = "&fcf_test_error_msg";
1827929 + output;
1828930 + run;
1829931 +
1830932 + proc print data=err_msg NOOBS LABEL;
1831933 + Var msg;
1832934 + Label msg='00'x;
1833935 + Title;
1834936 + run;
1835937 + %end;
1836938 + %else %do;
1837939 + %fcf_sa_ods_output;
1838940 + %end;
1839941 + %if &use_hp eq Y and &trans_rc eq 0 %then %do;
1840942 + PROC LASR STOP;
1841943 + RUN;
1842944 + %end;
1843945 +%mend fcf_sa_update_rc;
1844946 +
1845947 +
1846948 +%macro get_data_and_execute();
1847949 + /*--------------------------------------------- */
1848950 + /* -------------- get scenarios --------------- */
1849951 + /* get SCR_ALL dataset to build FSK_SCENARIO */
1850952 + %fcf_get_ecm_entities_as_table(tabName=, partyCat=SCENARIO, tabPrefix=scr, udfTabName=PARTY, charData=1, numData=1, dateData=1, party_keys=%superq(keys), party_keys_table=,
1851952 !+filter_deleted=);
1852953 + %fcf_sa_abort_on_error(msg=sa_processing_error, p1=FSK_SCENARIO)
1853954 + %if &scr_charRec eq 0 or &scr_numRec eq 0 or &scr_dateRec eq 0 %then %do;
1854955 + %let _fcfmsg_=ERROR: %sysfunc(sasmsg(sashelp.fcfmsg, sa_invalid_scenario_data, N));
1855956 + %fcf_sa_generate_error_msg(msg=&_fcfmsg_);
1856957 + %goto FCF_TEST_EXIT;
1857958 + %end;
1858959 +
1859960 + /* keys cannot be empty so there will be at least one scenario in SCR_ALL */
1860961 + /* get PARTY_LIVE fields for selected scenarios */
1861962 + proc sql;
1862963 + create table scr_fix1
1863964 + as select
1864 The SAS System
1865
1866965 + p.valid_from_dttm as LSTUPDATE_DATE_CURRENT,
1867966 + p.CREATE_USER_ID,
1868967 + s.*
1869968 + from scr_all s
1870969 + left join ecm_db.party_live p
1871970 + on s.party_rk = p.party_rk
1872971 + ;
1873972 + quit;
1874973 +
1875974 + %fcf_sa_abort_on_error(msg=sa_processing_error, p1=scr_fix1)
1876975 + /* fix the datatypes to match AML tables*/
1877976 + data scr_fix;
1878977 + length SCENARIO_CODE_LOCATION_DESC $255; /* need this in case all scenarios do not have source */
1879978 + set scr_fix1 (rename=(
1880979 + SCENARIO_ID = X_SCENARIO_ID
1881980 + LSTUPDATE_DATE = LSTUPDATE_DATE_OLD
1882981 + LSTUPDATE_DATE_CURRENT = LSTUPDATE_DATE
1883982 + ));
1884983 + drop _LABEL_ ROW_NO _NAME_ x_header_id X_SCENARIO_ID HEADER_ID ROUTING_GROUP_ID X_CREATE_USER_ID LSTUPDATE_DATE_OLD;
1885984 +
1886985 + length DAV_FILE_NAME $255;
1887986 + length scenario_id 8.;
1888987 + retain scenario_id;
1889988 + SCENARIO_ID =input(X_SCENARIO_ID, BEST32. );
1890989 + /* create_date cannot be NULL in AML */
1891990 + if scenario_id > 0
1892991 + AND LOGICAL_DELETE_IND ne "Y"
1893992 + AND CURRENT_IND ne "N"
1894993 + and (scenario_type_code eq "CUS" or scenario_type_code eq "HPS")
1895994 + then do;
1896995 + DAV_FILE_NAME = SCENARIO_CODE_LOCATION_DESC;
1897996 + if SCENARIO_CODE_LOCATION_DESC ne " " then SCENARIO_CODE_LOCATION_DESC ="&fcf_sa_scr_path" || left(trim(SCENARIO_NAME)) || ".sas";
1898997 + end;
1899998 + else do;
1900999 + DAV_FILE_NAME = " ";
19011000 + SCENARIO_CODE_LOCATION_DESC = " ";
19021001 + end;
19031002 + if CREATE_DATE = . then CREATE_DATE = DATETIME();
1904 The SAS System
1905
19061003 + if "&display_transactions" ne "Y" then SAVE_TRIG_TRANS_IND = 'N';
19071004 + run;
19081005 + %fcf_sa_abort_on_error(msg=sa_processing_error, p1=scr_fix)
19091006 +
19101007 + /*--------------------------------------------- */
19111008 + /* -------------- get headers ----------------- */
19121009 + /* ECM creates relationship between header and scenario, add header_id based on the relationship */
19131010 + proc sql;
19141011 + create table hdrXscr as
19151012 + select * from ecm_db.party_x_party
19161013 + where member_type_cd = "hdr_X_scr"
19171014 + and member_party_rk in (&keys)
19181015 + ;
19191016 + quit;
19201017 + %fcf_sa_abort_on_error(msg=sa_processing_error, p1=hdrXscr)
19211018 +
19221019 + %let hdr_keys = 0;
19231020 + proc sql noprint;
19241021 + select distinct party_rk into :hdr_keys separated by ','
19251022 + from hdrXscr
19261023 + ;
19271024 + quit;
19281025 + %put &hdr_keys;
19291026 + /* get records for FSK_HEADER */
19301027 + %fcf_get_ecm_entities_as_table(tabName=, partyCat=HEADER, tabPrefix=hdr, udfTabName=PARTY, charData=1, numData=1, dateData=1, party_keys=%superq(hdr_keys), party_keys_table=,
19311027 !+filter_deleted=);
19321028 + %fcf_sa_abort_on_error(msg=sa_processing_error, p1=FSK_HEADER)
19331029 + %if &hdr_allRec eq 0 or (&hdr_numRec eq 0 and &hdr_charRec eq 0 and &hdr_dateRec eq 0) %then %do;
19341030 + %let _fcfmsg_=ERROR: %sysfunc(sasmsg(sashelp.fcfmsg, sa_no_scenarios_to_test_err, N));
19351031 + %fcf_sa_generate_error_msg(msg=&_fcfmsg_);
19361032 + %goto FCF_TEST_EXIT;
19371033 + %end;
19381034 + /* add columns from PARTY table, hdrall is used later for scenario to create relationships in AML tables */
19391035 + proc sql;
19401036 + create table hdr_fix1 as
19411037 + select h.*,
19421038 + p.valid_from_dttm as LSTUPDATE_DATE,
19431039 + p.update_user_id as LSTUPDATE_USER_ID,
1944 The SAS System
1945
19461040 + p.CREATE_USER_ID
19471041 + from hdr_all h
19481042 + inner join ecm_db.party_live p
19491043 + on h.party_rk = p.party_rk
19501044 + where h.logical_delete_ind ne "Y"
19511045 + ;
19521046 + quit;
19531047 + %fcf_sa_abort_on_error(msg=sa_processing_error, p1=hdr_fix1)
19541048 +
19551049 + proc sql;
19561050 + create table orphan_scr as
19571051 + select s.*, hxs.member_party_rk from scr_fix s
19581052 + left join hdrXscr hxs
19591053 + on s.party_rk = hxs.member_party_rk
19601054 + where member_party_rk IS NULL /*scenario does not have a parent */
19611055 + or not exists ( select party_rk from hdr_fix1 h where hxs.party_rk = h.party_rk) /* or header is deleted */
19621056 + ;
19631057 + quit;
19641058 + %if &SQLOBS ne 0 %then %do;
19651059 + %let _fcfmsg_=ERROR: %sysfunc(sasmsg(sashelp.fcfmsg, sa_orphan_scenarios_to_test_err, N));
19661060 + %let msg1 = ERROR: %sysfunc(sasmsg(sashelp.fcfmsg, sa_scenario_has_no_header_err, N));
19671061 + %fcf_sa_generate_error_msg(msg=&_fcfmsg_);
19681062 + data _null_;
19691063 + set orphan_scr;
19701064 + put "&msg1" SCENARIO_NAME SCENARIO_SHORT_DESCRIPTION;
19711065 + run;
19721066 + %goto FCF_TEST_EXIT;
19731067 + %end;
19741068 +
19751069 + /* fix the datatypes to match AML tables*/
19761070 + data hdr_fix;
19771071 + length HEADER_LOCATION_DESC $255; /* need this in case all headers do not have source */
19781072 + set hdr_fix1 (rename=(header_id=x_header_id
19791073 + )
19801074 + );
19811075 + drop _LABEL_ ROW_NO _NAME_ x_header_id X_CREATE_USER_ID LSTUPDATE_DATE_OLD;
19821076 + length header_id 8.;
19831077 + length DAV_FILE_NAME $255;
1984 The SAS System
1985
19861078 + header_id = input(x_header_id, BEST32. );
19871079 + if CREATE_DATE = . then CREATE_DATE = DATETIME();
19881080 +
19891081 + /* double checking, name should be empty anyway, uidef sets it to empty using the same condition */
19901082 + if (SOURCE_TYPE_DESC eq 'SAS Datastep' or SOURCE_TYPE_DESC ne 'HP Datastep') and HEADER_AUTOGEN_IND ne 'Y' or SOURCE_TYPE_DESC ne 'Custom'
19911083 + then do;
19921084 + DAV_FILE_NAME = HEADER_LOCATION_DESC;
19931085 + HEADER_LOCATION_DESC = "&fcf_sa_hdr_path" || left(trim(HEADER_NAME)) || ".sas";
19941086 + end;
19951087 + else do;
19961088 + DAV_FILE_NAME = " ";
19971089 + HEADER_LOCATION_DESC = ' ';
19981090 + end;
19991091 + run;
20001092 + %fcf_sa_abort_on_error(msg=sa_processing_error, p1=hdr_fix)
20011093 + proc append base=work.FSK_HEADER data=hdr_fix FORCE;
20021094 + run;
20031095 +
20041096 + /*--------------------------------------------- */
20051097 + /* ---------- get routing groups -------------- */
20061098 + /* ECM creates relationship between scenario and routing group, add routing_group_id based on the relationship */
20071099 + proc sql;
20081100 + create table scrXrg as
20091101 + select * from ecm_db.party_x_party
20101102 + where member_type_cd = "scr_X_rg"
20111103 + and party_rk in (&keys)
20121104 + ;
20131105 + quit;
20141106 + %fcf_sa_abort_on_error(msg=sa_processing_error, p1=scrXrg)
20151107 + %let rg_keys = 0;
20161108 + proc sql noprint;
20171109 + select member_party_rk into :rg_keys separated by ','
20181110 + from scrXrg
20191111 + ;
20201112 + quit;
20211113 + %put &rg_keys;
20221114 + /* get records for FSK_ROUTING_GROUP */
20231115 + %fcf_get_ecm_entities_as_table(tabName=, partyCat=ROUTINGGRP, tabPrefix=rg, udfTabName=PARTY, charData=1, numData=0, dateData=0, party_keys=%superq(rg_keys), party_keys_table=,
2024 The SAS System
2025
20261115 !+filter_deleted=);
20271116 + %fcf_sa_abort_on_error(msg=sa_processing_error, p1=FSK_ROUTING_GROUP)
20281117 + %macro fcf_sa_fix_rg();
20291118 + %if &rg_charRec ne 0 %then %do;
20301119 + data rg_fix;
20311120 + set rg_all (rename=(routing_group_id=x_routing_group_id));
20321121 + drop _LABEL_ ROW_NO _NAME_ x_routing_group_id;
20331122 + length routing_group_id 8.;
20341123 +
20351124 + if x_routing_group_id = ' ' then delete; /* todo: report corrupt data */
20361125 + routing_group_id = input(x_routing_group_id, BEST32. );
20371126 + run;
20381127 + %fcf_sa_abort_on_error(msg=sa_processing_error, p1=rg_fix)
20391128 + proc append base=work.FSK_ROUTING_GROUP data=rg_fix FORCE;
20401129 + run;
20411130 + %end;
20421131 + %else %do;
20431132 + /* create empty rg_fix because it is used later to fix keys in the scenario table */
20441133 + data rg_fix;
20451134 + ROUTING_GROUP_ID = 0;
20461135 + ROUTING_GROUP_NAME = 'dummy';
20471136 + PARTY_RK = 0;
20481137 + LOGICAL_DELETE_IND = 'N';
20491138 + stop;
20501139 + run;
20511140 + %end;
20521141 + %mend fcf_sa_fix_rg;
20531142 + %fcf_sa_fix_rg
20541143 +
20551144 + /*--------------------------------------------- */
20561145 + /* ---------- fix relations ------------------ */
20571146 +
20581147 + proc sql;
20591148 + create table scr_full as
20601149 + select s.*, r.routing_group_id, h.header_id
20611150 + from scr_fix s
20621151 + left join scrXrg xg
20631152 + on s.party_rk = xg.party_rk
2064 The SAS System
2065
20661153 + left join hdrXscr xh
20671154 + on s.party_rk = xh.member_party_rk
20681155 + left join rg_fix r
20691156 + on r.party_rk = xg.member_party_rk
20701157 + left join hdr_fix h
20711158 + on h.party_rk = xh.party_rk
20721159 + ;
20731160 + quit;
20741161 + %if &SQLOBS eq 0 %then %do;
20751162 + %let _fcfmsg_=ERROR: %sysfunc(sasmsg(sashelp.fcfmsg, sa_no_scenarios_to_test_err, N));
20761163 + %fcf_sa_generate_error_msg(msg=&_fcfmsg_);
20771164 + %goto FCF_TEST_EXIT;
20781165 + %end;
20791166 + %fcf_sa_abort_on_error(msg=sa_processing_error, p1=scr_full)
20801167 +
20811168 + proc append base=work.FSK_SCENARIO data=scr_full FORCE;
20821169 + run;
20831170 +
20841171 + /*--------------------------------------------- */
20851172 + /* ---------- get prep dataset info ----------- */
20861173 + /* get records for FSK_HEADER_ELEMENT */
20871174 + %fcf_get_ecm_entities_as_table(tabName=, partyCat=HEADER, tabPrefix=col, udfTabName=X_DS_COL, charData=1, numData=0, dateData=0, party_keys=%superq(hdr_keys), party_keys_table=,
20881174 !+filter_deleted=);
20891175 + %fcf_sa_abort_on_error(msg=sa_processing_error, p1=FSK_HEADER_ELEMENT)
20901176 + /* ECM does not store full fsk_header_element */
20911177 + /* need to add ELEMENT_TYPE_CODE ELEMENT_LENGTH_COUNT ELEMENT_FORMAT_CODE ELEMENT_LABEL_DESC */
20921178 + /* create full element info */
20931179 +
20941180 + %macro fcf_sa_fix_col();
20951181 + %if &col_charRec ne 0 %then %do;
20961182 + proc sql noprint;
20971183 + create table dataset_list as
20981184 + select UPCASE(memname) as DATASET_NAME
20991185 + from dictionary.tables
21001186 + where libname="&fcf_sa_prep_lib"
21011187 + order by DATASET_NAME
21021188 + ;
21031189 + quit;
2104 The SAS System
2105
21061190 +
21071191 + data elements;
21081192 + set dataset_list;
21091193 + length ELEMENT_TYPE_CODE $6
21101194 + ELEMENT_LENGTH_COUNT 8
21111195 + ELEMENT_FORMAT_CODE $8
21121196 + ELEMENT_LABEL_DESC $35
21131197 + ELEMENT_NAME $35 ;
21141198 + keep dataset_name ELEMENT_TYPE_CODE ELEMENT_LENGTH_COUNT ELEMENT_FORMAT_CODE ELEMENT_LABEL_DESC ELEMENT_NAME;
21151199 + dsid=open("&fcf_sa_prep_lib.." || DATASET_NAME, "i");
21161200 + num=attrn(dsid,"nvars");
21171201 + do i=1 to num;
21181202 + element_name=upcase(varname(dsid,i));
21191203 + ELEMENT_TYPE_CODE=vartype(dsid,i);
21201204 + ELEMENT_FORMAT_CODE=varfmt(dsid,i);
21211205 + ELEMENT_LABEL_DESC=varlabel(dsid,i);
21221206 + ELEMENT_LENGTH_COUNT=varlen(dsid,i);
21231207 + if ELEMENT_LABEL_DESC = ' ' then ELEMENT_LABEL_DESC = element_name;
21241208 + output;
21251209 + end;
21261210 + rc=close(dsid);
21271211 + run;
21281212 +
21291213 + /* join all UDF columns in one table, exclude elements for deleted headers and exclude not found data sets */
21301214 + proc sql;
21311215 + create table col_fix
21321216 + as select c.*, e.ELEMENT_TYPE_CODE, e.ELEMENT_LENGTH_COUNT, e.ELEMENT_FORMAT_CODE, e.ELEMENT_LABEL_DESC
21331217 + from col_all c
21341218 + inner join hdr_all h /* use hdr_all so that header_id is the same type as in col_all */
21351219 + on h.header_id = c.header_id
21361220 + inner join elements e
21371221 + on h.denorm_table_name = e.dataset_name and e.element_name = c.element_name
21381222 + ;
21391223 + quit;
21401224 + %fcf_sa_abort_on_error(msg=sa_processing_error, p1=col_fix)
21411225 +
21421226 + /* Ignore missing datasets - codegen will report an error */
21431227 +
2144 The SAS System
2145
21461228 + /* fix the datatypes to match AML tables*/
21471229 + data col_full;
21481230 + set col_fix (rename=(header_id=x_header_id));
21491231 + drop _LABEL_ ROW_NO _NAME_ PARTY_RK x_header_id;
21501232 + length header_id 8.;
21511233 + header_id = input(x_header_id, BEST32. );
21521234 + run;
21531235 + %fcf_sa_abort_on_error(msg=sa_processing_error, p1=col_full)
21541236 +
21551237 + proc append base=work.FSK_HEADER_ELEMENT data=col_full FORCE;
21561238 + run;
21571239 + %end;
21581240 + %mend fcf_sa_fix_col;
21591241 + %fcf_sa_fix_col();
21601242 +
21611243 + /*--------------------------------------------- */
21621244 + /*--------- get routing group rules ----------- */
21631245 + %macro fcf_sa_get_rr();
21641246 + %if &rg_charRec ne 0 %then %do;
21651247 + /* get records for FSK_ROUTING_RULE */
21661248 + %fcf_get_ecm_entities_as_table(tabName=, partyCat=ROUTINGGRP, tabPrefix=rr, udfTabName=X_RR, charData=1, numData=1, dateData=0, party_keys=%superq(rg_keys),
21671248 !+party_keys_table=, filter_deleted=);
21681249 + %fcf_sa_abort_on_error(msg=sa_processing_error, p1=FSK_ROUTING_RULE)
21691250 + %if &rr_charRec ne 0 %then %do;
21701251 + data rr_full;
21711252 + set rr_all (rename=(ROUTE_ORDER_NUMBER=x_ROUTE_ORDER_NUMBER routing_group_id=x_routing_group_id routing_rule_id=x_routing_rule_id));
21721253 + drop _LABEL_ ROW_NO _NAME_ PARTY_RK x_ROUTE_ORDER_NUMBER x_routing_group_id x_routing_rule_id;
21731254 + length ROUTE_ORDER_NUMBER 8.;
21741255 + ROUTE_ORDER_NUMBER = input(x_ROUTE_ORDER_NUMBER, BEST32. );
21751256 + length routing_group_id 8.;
21761257 + length routing_rule_id 8.;
21771258 +
21781259 + if x_routing_group_id = ' ' then delete; /* todo: report corrupt data */
21791260 + if x_routing_rule_id = ' ' then delete; /* todo: report corrupt data */
21801261 + routing_group_id = input(x_routing_group_id, BEST32. );
21811262 + routing_rule_id = input(x_routing_rule_id, BEST32. );
21821263 + run;
21831264 + %fcf_sa_abort_on_error(msg=sa_processing_error, p1=rr_full);
2184 The SAS System
2185
21861265 + proc append base=work.FSK_ROUTING_RULE data=rr_full FORCE;
21871266 + run;
21881267 + %end;
21891268 + %end;
21901269 + %mend fcf_sa_get_rr;
21911270 + %fcf_sa_get_rr;
21921271 +
21931272 + /*--------------------------------------------- */
21941273 + /*--------- get routing constrains ------------ */
21951274 + %macro fcf_sa_get_rc();
21961275 + %if &rg_charRec ne 0 %then %do;
21971276 + %if &rr_charRec ne 0 %then %do;
21981277 + /* get records for FSK_ROUTING_CONSTRAINT */
21991278 + %fcf_get_ecm_entities_as_table(tabName=, partyCat=ROUTINGGRP, tabPrefix=rc, udfTabName=X_RC, charData=1, numData=1, dateData=0, party_keys=%superq(rg_keys),
22001278 !+party_keys_table=, filter_deleted=);
22011279 + %fcf_sa_abort_on_error(msg=sa_processing_error, p1=FSK_ROUTING_CONSTRAINT)
22021280 + %if &rc_charRec ne 0 %then %do;
22031281 + data rc_fix;
22041282 + set rc_all (rename=(CONSTRAINT_ORDER_NUMBER=x_CONSTRAINT_ORDER_NUMBER routing_group_id=x_routing_group_id routing_rule_id=x_routing_rule_id));
22051283 + drop _LABEL_ ROW_NO _NAME_ PARTY_RK x_CONSTRAINT_ORDER_NUMBER x_routing_group_id x_routing_rule_id;
22061284 + length CONSTRAINT_ORDER_NUMBER 8.;
22071285 + CONSTRAINT_ORDER_NUMBER = input(x_CONSTRAINT_ORDER_NUMBER, BEST32. );
22081286 + length routing_group_id 8.;
22091287 + length routing_rule_id 8.;
22101288 +
22111289 + if x_routing_group_id = ' ' then delete; /* todo: report corrupt data */
22121290 + if x_routing_rule_id = ' ' then delete; /* todo: report corrupt data */
22131291 + routing_group_id = input(x_routing_group_id, BEST32. );
22141292 + routing_rule_id = input(x_routing_rule_id, BEST32. );
22151293 + run;
22161294 + %fcf_sa_abort_on_error(msg=sa_processing_error, p1=rc_fix)
22171295 +
22181296 + /* filter routing constrains using routing_group_id - workaround for ECM design flaw */
22191297 + proc sql;
22201298 + create table rc_full as
22211299 + select * from rc_fix
22221300 + where routing_rule_id in (select routing_rule_id from rr_full)
22231301 + ;
2224 The SAS System
2225
22261302 + quit;
22271303 + %fcf_sa_abort_on_error(msg=sa_processing_error, p1=rc_full)
22281304 + proc append base=work.FSK_ROUTING_CONSTRAINT data=rc_full FORCE;
22291305 + run;
22301306 + %end;
22311307 + %end;
22321308 + %end;
22331309 + %mend fcf_sa_get_rc;
22341310 + %fcf_sa_get_rc;
22351311 +
22361312 + /*--------------------------------------------- */
22371313 + /*--------- get scenario parameters ------------ */
22381314 + %macro fcf_sa_get_scr_p();
22391315 + /* get records for FSK_SCENARIO_PARAMETER */
22401316 + %fcf_get_ecm_entities_as_table(tabName=, partyCat=SCENARIO, tabPrefix=sp, udfTabName=X_SCR_P, charData=1, numData=0, dateData=0, party_keys=%superq(keys), party_keys_table=,
22411316 !+filter_deleted=);
22421317 + %fcf_sa_abort_on_error(msg=sa_processing_error, p1=FSK_SCENARIO_PARAMETER)
22431318 + %if &sp_charRec ne 0 %then %do;
22441319 + data sp_full;
22451320 + set sp_all (rename=(scenario_id=x_scenario_id));
22461321 + drop _LABEL_ ROW_NO _NAME_ PARTY_RK x_scenario_id;
22471322 + length scenario_id 8.;
22481323 + scenario_id = input(x_scenario_id, BEST32. );
22491324 + run;
22501325 + %fcf_sa_abort_on_error(msg=sa_processing_error, p1=sp_full)
22511326 + proc append base=work.FSK_SCENARIO_PARAMETER data=sp_full FORCE;
22521327 + run;
22531328 + %end;
22541329 + %mend fcf_sa_get_scr_p;
22551330 + %fcf_sa_get_scr_p;
22561331 +
22571332 + /*--------------------------------------------- */
22581333 + /*--------- get scenario alert columns ------------ */
22591334 + %macro fcf_sa_get_ac();
22601335 + /* get records for FSK_SCENARIO_ALERT_COLUMN */
22611336 + %fcf_get_ecm_entities_as_table(tabName=, partyCat=SCENARIO, tabPrefix=ac, udfTabName=X_AC, charData=1, numData=0, dateData=0, party_keys=%superq(keys), party_keys_table=,
22621336 !+filter_deleted=);
22631337 + %fcf_sa_abort_on_error(msg=sa_processing_error, p1=FSK_SCENARIO_ALERT_COLUMN)
2264 The SAS System
2265
22661338 + %if &ac_charRec ne 0 %then %do;
22671339 + data ac_full;
22681340 + set ac_all (rename=(
22691341 + SCENARIO_ID =X_SCENARIO_ID
22701342 + ));
22711343 + drop _LABEL_ ROW_NO _NAME_ PARTY_RK x_FILTER_ID X_SCENARIO_ID;
22721344 + length SCENARIO_ID 8.;
22731345 +
22741346 + if x_scenario_id = ' ' then delete; /* skip corrupted data - all records must have scenario_id, todo: report an error */
22751347 + filter_id =input(x_filter_id, BEST32. );
22761348 + SCENARIO_ID =input(X_SCENARIO_ID, BEST32. );
22771349 + run;
22781350 + %fcf_sa_abort_on_error(msg=sa_processing_error, p1=ac_full)
22791351 +
22801352 + proc append base=work.FSK_SCENARIO_ALERT_COLUMN data=ac_full FORCE;
22811353 + run;
22821354 + %end;
22831355 + %mend fcf_sa_get_ac;
22841356 + %fcf_sa_get_ac;
22851357 +
22861358 +
22871359 +
22881360 + /****************************************************************************
22891361 + ****************************************************************************
22901362 + ** Download scenario code
22911363 + ****************************************************************************
22921364 + ****************************************************************************/
22931365 + %fcf_sa_download_scenarios(dav_server_root=&fcf_dav_root, dav_server_path=&scr_dav_path, filenames_ds=scr_full)
22941366 +
22951367 + /****************************************************************************
22961368 + ****************************************************************************
22971369 + ** Download header code
22981370 + ****************************************************************************
22991371 + ****************************************************************************/
23001372 + %fcf_sa_download_headers(dav_server_root=&fcf_dav_root, dav_server_path=&hdr_dav_path, filenames_ds=hdr_fix)
23011373 +
23021374 + /*---------------------------------------------------------- */
23031375 + /*----------------- execute codegen ----------------------- */
2304 The SAS System
2305
23061376 + %macro fcf_sa_run_codegen();
23071377 + %if %sysevalf(&samplesize eq 0.0 or &samplesize eq . or &samplesize eq 0) %then %do; /*FIXME: fix uidef not to send 0.0 */
23081378 + %let samplesize_p=0;
23091379 + %end;
23101380 + %else %do;
23111381 + %let samplesize_p=&samplesize;
23121382 + %end;
23131383 + %put samplesize_p= &samplesize_p;
23141384 +
23151385 + %fcf_agp_codegen( outLib=STG_ALER,
23161386 + outDS=generated_headers,
23171387 + scenario_message_encoding=&msg_encoding,
23181388 + calculate_array_dim=Y,
23191389 + seg_kc_lib=work,
23201390 + test_button=Y,
23211391 + test_runasofdate=&runasofdate,
23221392 + sample_size=&samplesize_p,
23231393 + outSampleLib=
23241394 + );
23251395 + %if &trans_rc eq 3 or &trans_rc ge 5 %then %do;
23261396 + %fcf_sa_abort(msg=sa_test_sp_agp_codegen_error_msg);
23271397 + %end;
23281398 + %fcf_sa_abort_on_error(msg=sa_test_sp_agp_codegen_error_msg)
23291399 + %mend fcf_sa_run_codegen;
23301400 + %fcf_sa_run_codegen
23311401 +
23321402 + %let fcf_sa_all_alerts_ds = _tempalerts_sa;
23331403 + %let fcf_sa_all_trans_keys = _tempalerts_trans_keys_sa;
23341404 +
23351405 +
23361406 + %macro fcf_sa_append_header_results(header=);
23371407 + %if %sysfunc(exist(work._tempalerts)) %then %do;
23381408 + /* need to check if the data set is empty, when empty it should not be used, it may create data set without columns */
23391409 + %let DSID=%sysfunc(OPEN(work._tempalerts,IN));
23401410 + %let NOBS=%sysfunc(ATTRN(&DSID,NLOBS));
23411411 + %let RC=%sysfunc(CLOSE(&DSID));
23421412 + %if &NOBS > 0 %then %do;
23431413 + proc append base=work.&fcf_sa_all_alerts_ds data=work._tempalerts FORCE;
2344 The SAS System
2345
23461414 + run;
23471415 + %end;
23481416 + %end;
23491417 + %if %sysfunc(exist(work._tempalerts_trans_keys)) %then %do;
23501418 + /* need to check if the data set is empty, when empty it has incorrect column name _transaction_key_ so it should not be used */
23511419 + %let DSID=%sysfunc(OPEN(work._tempalerts_trans_keys,IN));
23521420 + %let NOBS=%sysfunc(ATTRN(&DSID,NLOBS));
23531421 + %let RC=%sysfunc(CLOSE(&DSID));
23541422 + %if &NOBS > 0 %then %do;
23551423 + proc append base=work.&fcf_sa_all_trans_keys data=work._tempalerts_trans_keys FORCE;
23561424 + run;
23571425 + %end;
23581426 + %end;
23591427 + %mend fcf_sa_append_header_results;
23601428 +
23611429 + /*----------------------------------------------------------- */
23621430 + /*----------------- execute scenarios ----------------------- */
23631431 + filename hdr_lst TEMP;
23641432 + %macro fcf_sa_exec_headers();
23651433 + data _null_;
23661434 + set work.fsk_header;
23671435 + length stmt $256;
23681436 + file hdr_lst;
23691437 + /* empty_header is not executed, name hard coded the same was as in fcf_agp.sas */
23701438 + if kupcase(kstrip(HEADER_NAME)) ne "EMPTY_HEADER" then do;
23711439 + stmt = "%inc '&fcf_sa_codegen_path" || kstrip(HEADER_NAME) || ".sas';";
23721440 + put stmt;
23731441 + stmt = '%fcf_sa_append_header_results(header='|| kstrip(HEADER_NAME) ||');';
23741442 + put stmt;
23751443 + end;
23761444 + run;
23771445 + %mend fcf_sa_exec_headers;
23781446 + %fcf_sa_exec_headers
23791447 +
23801448 + /* clean up */
23811449 + proc datasets lib=work noprint;
23821450 + delete hdr_all hdr_all_cn hdr_c hdr_cc hdr_ct hdr_d hdr_dc hdr_dt hdr_n hdr_nc hdr_nt hdr_fix hdr_fix1;
23831451 + delete rg_all rg_all_cn rg_c rg_cc rg_ct rg_fix;
2384 The SAS System
2385
23861452 + delete scr_all scr_all_cn scr_c scr_cc scr_ct scr_d scr_dc scr_dt scr_fix scr_n scr_nc scr_nt scr_fix1 scr_fix scr_full;
23871453 + delete col_all col_all_cn col_c col_cc col_ct col_fix col_full dataset_list elements;
23881454 + delete sp_all sp_all_cn sp_c sp_cc sp_ct sp_full;
23891455 + delete rr_all rr_all_cn rr_c rr_cc rr_ct rr_n rr_nc rr_nt rr_full;
23901456 + delete rc_all rc_all_cn rc_c rc_cc rc_ct rc_n rc_nc rc_nt rc_fix rc_full;
23911457 + delete ac_all ac_all_cn ac_c ac_cc ac_ct ac_n ac_nc ac_nt ac_full;
23921458 + delete sf_all sf_all_cn sf_c sf_cc sf_ct sf_n sf_nc sf_nt sf_full;
23931459 + delete fv_all fv_all_cn fv_c fv_cc fv_ct fv_full fv_fix;
23941460 + delete fc_all fc_all_cn fc_c fc_cc fc_ct fc_n fc_nc fc_nt fc_full fc_fix;
23951461 + delete arc_all arc_all_cn arc_c arc_cc arc_ct arc_n arc_nc arc_nt arc_full arc_fix;
23961462 + delete lm_all lm_all_cn lm_c lm_cc lm_ct lm_n lm_nc lm_nt lm_full;
23971463 + delete lmp_all lmp_all_cn lmp_c lmp_cc lmp_ct lmp_n lmp_nc lmp_nt lmp_full;
23981464 + delete hdrxscr scrxrg;
23991465 + run;
24001466 +
24011467 + /* options mprint mlogic symbolgen; */
24021468 + /* GBC Injection start: rebuild prep */
24031469 + %put GBC Injection start: rebuild prep;
24041470 +
24051471 + data _NULL_;
24061472 + set work.fsk_scenario_parameter;
24071473 + call symput(Parm_Name,Parm_Value);
24081474 + run;
24091475 +
24101476 + proc sql noprint;
24111477 + select distinct '%include "!FCFROOT/custom/source/prep_files/'||strip(lowcase(hdr.header_name))||'.sas";'
24121478 + into :mvRunPrepStatement separated by ' '
24131479 + from fsk_scenario scn
24141480 + join fsk_header hdr on (scn.header_id = hdr.header_id)
24151481 + ;
24161482 + quit;
24171483 +
24181484 + &mvRunPrepStatement.;
24191485 +
24201486 + %put GBC Injection end;
24211487 + /* GBC Injection end */
24221488 +
24231489 + %inc hdr_lst;
2424 The SAS System
2425
24261490 + %fcf_sa_abort_on_error(msg=sa_test_sp_agp_scenarios_error_msg, p1=hdr_lst)
24271491 +
24281492 +
24291493 + %FCF_TEST_EXIT: %fcf_sa_update_rc();
24301494 +
24311495 +%mend get_data_and_execute;
24321496 +
24331497 +%get_data_and_execute();
2434NOTE: Compressing data set WORK.SCR_CC increased size by 100.00 percent.
2435 Compressed is 2 pages; un-compressed would require 1 pages.
2436NOTE: Table WORK.SCR_CC created, with 17 rows and 4 columns.
2437
2438NOTE: PROCEDURE SQL used (Total process time):
2439 real time 0.01 seconds
2440 user cpu time 0.00 seconds
2441 system cpu time 0.00 seconds
2442 memory 20492.03k
2443 OS Memory 208268.00k
2444 Timestamp 24.07.2019 02:31:12 после полудня
2445 Step Count 1937 Switch Count 23
2446 Page Faults 0
2447 Page Reclaims 930
2448 Page Swaps 0
2449 Voluntary Context Switches 47
2450 Involuntary Context Switches 8
2451 Block Input Operations 0
2452 Block Output Operations 0
2453
2454
2455NOTE: {START: fcf_chkrc}
2456NOTE: {END: fcf_chkrc}
2457
2458NOTE: There were 17 observations read from the data set WORK.SCR_CC.
2459NOTE: The data set WORK.SCR_C has 1 observations and 19 variables.
2460NOTE: Compressing data set WORK.SCR_C increased size by 100.00 percent.
2461 Compressed is 2 pages; un-compressed would require 1 pages.
2462NOTE: PROCEDURE TRANSPOSE used (Total process time):
2463 real time 0.00 seconds
2464 The SAS System
2465
2466 user cpu time 0.00 seconds
2467 system cpu time 0.00 seconds
2468 memory 2637.84k
2469 OS Memory 190548.00k
2470 Timestamp 24.07.2019 02:31:12 после полудня
2471 Step Count 1938 Switch Count 28
2472 Page Faults 0
2473 Page Reclaims 40
2474 Page Swaps 0
2475 Voluntary Context Switches 44
2476 Involuntary Context Switches 7
2477 Block Input Operations 0
2478 Block Output Operations 0
2479
2480
2481
2482NOTE: There were 1 observations read from the data set WORK.SCR_C.
2483NOTE: The data set WORK.SCR_C has 1 observations and 19 variables.
2484NOTE: Compressing data set WORK.SCR_C increased size by 100.00 percent.
2485 Compressed is 2 pages; un-compressed would require 1 pages.
2486NOTE: DATA statement used (Total process time):
2487 real time 0.00 seconds
2488 user cpu time 0.00 seconds
2489 system cpu time 0.01 seconds
2490 memory 1264.90k
2491 OS Memory 188760.00k
2492 Timestamp 24.07.2019 02:31:12 после полудня
2493 Step Count 1939 Switch Count 24
2494 Page Faults 0
2495 Page Reclaims 140
2496 Page Swaps 0
2497 Voluntary Context Switches 50
2498 Involuntary Context Switches 0
2499 Block Input Operations 0
2500 Block Output Operations 0
2501
2502
2503NOTE: Compressing data set WORK.SCR_NC increased size by 100.00 percent.
2504 The SAS System
2505
2506 Compressed is 2 pages; un-compressed would require 1 pages.
2507NOTE: Table WORK.SCR_NC created, with 7 rows and 4 columns.
2508
2509NOTE: PROCEDURE SQL used (Total process time):
2510 real time 0.01 seconds
2511 user cpu time 0.00 seconds
2512 system cpu time 0.00 seconds
2513 memory 5437.34k
2514 OS Memory 193620.00k
2515 Timestamp 24.07.2019 02:31:12 после полудня
2516 Step Count 1940 Switch Count 27
2517 Page Faults 0
2518 Page Reclaims 142
2519 Page Swaps 0
2520 Voluntary Context Switches 57
2521 Involuntary Context Switches 3
2522 Block Input Operations 0
2523 Block Output Operations 0
2524
2525
2526NOTE: {START: fcf_chkrc}
2527NOTE: {END: fcf_chkrc}
2528
2529NOTE: There were 7 observations read from the data set WORK.SCR_NC.
2530NOTE: The data set WORK.SCR_N has 1 observations and 9 variables.
2531NOTE: Compressing data set WORK.SCR_N increased size by 100.00 percent.
2532 Compressed is 2 pages; un-compressed would require 1 pages.
2533NOTE: PROCEDURE TRANSPOSE used (Total process time):
2534 real time 0.00 seconds
2535 user cpu time 0.00 seconds
2536 system cpu time 0.00 seconds
2537 memory 2579.25k
2538 OS Memory 190292.00k
2539 Timestamp 24.07.2019 02:31:12 после полудня
2540 Step Count 1941 Switch Count 24
2541 Page Faults 0
2542 Page Reclaims 5
2543 Page Swaps 0
2544 The SAS System
2545
2546 Voluntary Context Switches 40
2547 Involuntary Context Switches 0
2548 Block Input Operations 0
2549 Block Output Operations 0
2550
2551
2552
2553NOTE: There were 1 observations read from the data set WORK.SCR_N.
2554NOTE: The data set WORK.SCR_N has 1 observations and 9 variables.
2555NOTE: Compressing data set WORK.SCR_N increased size by 100.00 percent.
2556 Compressed is 2 pages; un-compressed would require 1 pages.
2557NOTE: DATA statement used (Total process time):
2558 real time 0.00 seconds
2559 user cpu time 0.00 seconds
2560 system cpu time 0.00 seconds
2561 memory 922.21k
2562 OS Memory 188240.00k
2563 Timestamp 24.07.2019 02:31:12 после полудня
2564 Step Count 1942 Switch Count 24
2565 Page Faults 0
2566 Page Reclaims 71
2567 Page Swaps 0
2568 Voluntary Context Switches 50
2569 Involuntary Context Switches 30
2570 Block Input Operations 0
2571 Block Output Operations 0
2572
2573
2574WARNING: Variable PARTY_RK already exists on file WORK.SCR_ALL_CN.
2575WARNING: Variable ROW_NO already exists on file WORK.SCR_ALL_CN.
2576NOTE: Compressing data set WORK.SCR_ALL_CN increased size by 100.00 percent.
2577 Compressed is 2 pages; un-compressed would require 1 pages.
2578NOTE: Table WORK.SCR_ALL_CN created, with 1 rows and 26 columns.
2579
2580NOTE: PROCEDURE SQL used (Total process time):
2581 real time 0.00 seconds
2582 user cpu time 0.00 seconds
2583 system cpu time 0.00 seconds
2584 The SAS System
2585
2586 memory 5877.12k
2587 OS Memory 193368.00k
2588 Timestamp 24.07.2019 02:31:12 после полудня
2589 Step Count 1943 Switch Count 30
2590 Page Faults 0
2591 Page Reclaims 87
2592 Page Swaps 0
2593 Voluntary Context Switches 60
2594 Involuntary Context Switches 36
2595 Block Input Operations 0
2596 Block Output Operations 0
2597
2598
2599NOTE: Compressing data set WORK.SCR_DC increased size by 100.00 percent.
2600 Compressed is 2 pages; un-compressed would require 1 pages.
2601NOTE: Table WORK.SCR_DC created, with 3 rows and 4 columns.
2602
2603NOTE: PROCEDURE SQL used (Total process time):
2604 real time 0.01 seconds
2605 user cpu time 0.01 seconds
2606 system cpu time 0.00 seconds
2607 memory 5438.46k
2608 OS Memory 193364.00k
2609 Timestamp 24.07.2019 02:31:12 после полудня
2610 Step Count 1944 Switch Count 22
2611 Page Faults 0
2612 Page Reclaims 114
2613 Page Swaps 0
2614 Voluntary Context Switches 42
2615 Involuntary Context Switches 1
2616 Block Input Operations 0
2617 Block Output Operations 0
2618
2619
2620NOTE: {START: fcf_chkrc}
2621NOTE: {END: fcf_chkrc}
2622
2623NOTE: There were 3 observations read from the data set WORK.SCR_DC.
2624 The SAS System
2625
2626NOTE: The data set WORK.SCR_D has 1 observations and 5 variables.
2627NOTE: Compressing data set WORK.SCR_D increased size by 100.00 percent.
2628 Compressed is 2 pages; un-compressed would require 1 pages.
2629NOTE: PROCEDURE TRANSPOSE used (Total process time):
2630 real time 0.00 seconds
2631 user cpu time 0.00 seconds
2632 system cpu time 0.00 seconds
2633 memory 2577.75k
2634 OS Memory 190036.00k
2635 Timestamp 24.07.2019 02:31:12 после полудня
2636 Step Count 1945 Switch Count 28
2637 Page Faults 0
2638 Page Reclaims 40
2639 Page Swaps 0
2640 Voluntary Context Switches 71
2641 Involuntary Context Switches 42
2642 Block Input Operations 0
2643 Block Output Operations 0
2644
2645
2646
2647NOTE: There were 1 observations read from the data set WORK.SCR_D.
2648NOTE: The data set WORK.SCR_D has 1 observations and 5 variables.
2649NOTE: Compressing data set WORK.SCR_D increased size by 100.00 percent.
2650 Compressed is 2 pages; un-compressed would require 1 pages.
2651NOTE: DATA statement used (Total process time):
2652 real time 0.00 seconds
2653 user cpu time 0.00 seconds
2654 system cpu time 0.00 seconds
2655 memory 937.84k
2656 OS Memory 188240.00k
2657 Timestamp 24.07.2019 02:31:12 после полудня
2658 Step Count 1946 Switch Count 24
2659 Page Faults 0
2660 Page Reclaims 70
2661 Page Swaps 0
2662 Voluntary Context Switches 50
2663 Involuntary Context Switches 30
2664 The SAS System
2665
2666 Block Input Operations 0
2667 Block Output Operations 0
2668
2669
2670WARNING: Variable PARTY_RK already exists on file WORK.SCR_ALL.
2671WARNING: Variable ROW_NO already exists on file WORK.SCR_ALL.
2672NOTE: Compressing data set WORK.SCR_ALL increased size by 100.00 percent.
2673 Compressed is 2 pages; un-compressed would require 1 pages.
2674NOTE: Table WORK.SCR_ALL created, with 1 rows and 29 columns.
2675
2676NOTE: PROCEDURE SQL used (Total process time):
2677 real time 0.00 seconds
2678 user cpu time 0.00 seconds
2679 system cpu time 0.01 seconds
2680 memory 5876.34k
2681 OS Memory 193368.00k
2682 Timestamp 24.07.2019 02:31:12 после полудня
2683 Step Count 1947 Switch Count 26
2684 Page Faults 0
2685 Page Reclaims 84
2686 Page Swaps 0
2687 Voluntary Context Switches 60
2688 Involuntary Context Switches 37
2689 Block Input Operations 0
2690 Block Output Operations 0
2691
2692
2693NOTE: {START: fcf_chkrc}
2694NOTE: {END: fcf_chkrc}
2695NOTE: SAS threaded sort was used.
2696NOTE: Compressing data set WORK.SCR_FIX1 increased size by 100.00 percent.
2697 Compressed is 2 pages; un-compressed would require 1 pages.
2698NOTE: Table WORK.SCR_FIX1 created, with 1 rows and 31 columns.
2699
2700NOTE: PROCEDURE SQL used (Total process time):
2701 real time 28.04 seconds
2702 user cpu time 16.43 seconds
2703 system cpu time 2.64 seconds
2704 The SAS System
2705
2706 memory 957045.26k
2707 OS Memory 1142476.00k
2708 Timestamp 24.07.2019 02:31:40 после полудня
2709 Step Count 1948 Switch Count 29
2710 Page Faults 0
2711 Page Reclaims 78675
2712 Page Swaps 0
2713 Voluntary Context Switches 89815
2714 Involuntary Context Switches 59804
2715 Block Input Operations 0
2716 Block Output Operations 0
2717
2718
2719NOTE: {START: fcf_chkrc}
2720NOTE: {END: fcf_chkrc}
2721
2722WARNING: Multiple lengths were specified for the variable SCENARIO_CODE_LOCATION_DESC by input data set(s). This can cause truncation of data.
2723WARNING: The variable _LABEL_ in the DROP, KEEP, or RENAME list has never been referenced.
2724WARNING: The variable _NAME_ in the DROP, KEEP, or RENAME list has never been referenced.
2725WARNING: The variable x_header_id in the DROP, KEEP, or RENAME list has never been referenced.
2726WARNING: The variable HEADER_ID in the DROP, KEEP, or RENAME list has never been referenced.
2727WARNING: The variable ROUTING_GROUP_ID in the DROP, KEEP, or RENAME list has never been referenced.
2728WARNING: The variable X_CREATE_USER_ID in the DROP, KEEP, or RENAME list has never been referenced.
2729NOTE: There were 1 observations read from the data set WORK.SCR_FIX1.
2730NOTE: The data set WORK.SCR_FIX has 1 observations and 31 variables.
2731NOTE: Compressing data set WORK.SCR_FIX increased size by 100.00 percent.
2732 Compressed is 2 pages; un-compressed would require 1 pages.
2733NOTE: DATA statement used (Total process time):
2734 real time 0.01 seconds
2735 user cpu time 0.01 seconds
2736 system cpu time 0.00 seconds
2737 memory 1304.62k
2738 OS Memory 189016.00k
2739 Timestamp 24.07.2019 02:31:40 после полудня
2740 Step Count 1949 Switch Count 38
2741 Page Faults 0
2742 Page Reclaims 178
2743 Page Swaps 0
2744 The SAS System
2745
2746 Voluntary Context Switches 97
2747 Involuntary Context Switches 95
2748 Block Input Operations 0
2749 Block Output Operations 0
2750
2751
2752NOTE: {START: fcf_chkrc}
2753NOTE: {END: fcf_chkrc}
2754NOTE: Compressing data set WORK.HDRXSCR increased size by 100.00 percent.
2755 Compressed is 2 pages; un-compressed would require 1 pages.
2756NOTE: Table WORK.HDRXSCR created, with 1 rows and 4 columns.
2757
2758NOTE: PROCEDURE SQL used (Total process time):
2759 real time 0.00 seconds
2760 user cpu time 0.00 seconds
2761 system cpu time 0.00 seconds
2762 memory 5278.18k
2763 OS Memory 193620.00k
2764 Timestamp 24.07.2019 02:31:40 после полудня
2765 Step Count 1950 Switch Count 23
2766 Page Faults 0
2767 Page Reclaims 108
2768 Page Swaps 0
2769 Voluntary Context Switches 42
2770 Involuntary Context Switches 35
2771 Block Input Operations 0
2772 Block Output Operations 0
2773
2774
2775NOTE: {START: fcf_chkrc}
2776NOTE: {END: fcf_chkrc}
2777NOTE: PROCEDURE SQL used (Total process time):
2778 real time 0.00 seconds
2779 user cpu time 0.00 seconds
2780 system cpu time 0.00 seconds
2781 memory 5305.09k
2782 OS Memory 193620.00k
2783 Timestamp 24.07.2019 02:31:40 после полудня
2784 The SAS System
2785
2786 Step Count 1951 Switch Count 14
2787 Page Faults 0
2788 Page Reclaims 23
2789 Page Swaps 0
2790 Voluntary Context Switches 0
2791 Involuntary Context Switches 0
2792 Block Input Operations 0
2793 Block Output Operations 0
2794
2795
279610170321
2797NOTE: Compressing data set WORK.HDR_CC increased size by 100.00 percent.
2798 Compressed is 2 pages; un-compressed would require 1 pages.
2799NOTE: Table WORK.HDR_CC created, with 10 rows and 4 columns.
2800
2801NOTE: PROCEDURE SQL used (Total process time):
2802 real time 0.02 seconds
2803 user cpu time 0.01 seconds
2804 system cpu time 0.01 seconds
2805 memory 20476.59k
2806 OS Memory 208268.00k
2807 Timestamp 24.07.2019 02:31:40 после полудня
2808 Step Count 1952 Switch Count 23
2809 Page Faults 0
2810 Page Reclaims 925
2811 Page Swaps 0
2812 Voluntary Context Switches 47
2813 Involuntary Context Switches 11
2814 Block Input Operations 0
2815 Block Output Operations 0
2816
2817
2818NOTE: {START: fcf_chkrc}
2819NOTE: {END: fcf_chkrc}
2820
2821NOTE: There were 10 observations read from the data set WORK.HDR_CC.
2822NOTE: The data set WORK.HDR_C has 1 observations and 12 variables.
2823NOTE: Compressing data set WORK.HDR_C increased size by 100.00 percent.
2824 The SAS System
2825
2826 Compressed is 2 pages; un-compressed would require 1 pages.
2827NOTE: PROCEDURE TRANSPOSE used (Total process time):
2828 real time 0.00 seconds
2829 user cpu time 0.00 seconds
2830 system cpu time 0.01 seconds
2831 memory 2616.62k
2832 OS Memory 190548.00k
2833 Timestamp 24.07.2019 02:31:40 после полудня
2834 Step Count 1953 Switch Count 28
2835 Page Faults 0
2836 Page Reclaims 74
2837 Page Swaps 0
2838 Voluntary Context Switches 56
2839 Involuntary Context Switches 56
2840 Block Input Operations 0
2841 Block Output Operations 0
2842
2843
2844
2845NOTE: There were 1 observations read from the data set WORK.HDR_C.
2846NOTE: The data set WORK.HDR_C has 1 observations and 12 variables.
2847NOTE: Compressing data set WORK.HDR_C increased size by 100.00 percent.
2848 Compressed is 2 pages; un-compressed would require 1 pages.
2849NOTE: DATA statement used (Total process time):
2850 real time 0.00 seconds
2851 user cpu time 0.01 seconds
2852 system cpu time 0.00 seconds
2853 memory 1231.43k
2854 OS Memory 189016.00k
2855 Timestamp 24.07.2019 02:31:40 после полудня
2856 Step Count 1954 Switch Count 24
2857 Page Faults 0
2858 Page Reclaims 146
2859 Page Swaps 0
2860 Voluntary Context Switches 40
2861 Involuntary Context Switches 40
2862 Block Input Operations 0
2863 Block Output Operations 0
2864 The SAS System
2865
2866
2867
2868NOTE: Table WORK.HDR_NC created, with 0 rows and 4 columns.
2869
2870NOTE: PROCEDURE SQL used (Total process time):
2871 real time 0.01 seconds
2872 user cpu time 0.01 seconds
2873 system cpu time 0.00 seconds
2874 memory 5436.40k
2875 OS Memory 193876.00k
2876 Timestamp 24.07.2019 02:31:40 после полудня
2877 Step Count 1955 Switch Count 19
2878 Page Faults 0
2879 Page Reclaims 137
2880 Page Swaps 0
2881 Voluntary Context Switches 27
2882 Involuntary Context Switches 6
2883 Block Input Operations 0
2884 Block Output Operations 0
2885
2886
2887NOTE: {START: fcf_chkrc}
2888NOTE: {END: fcf_chkrc}
2889
2890NOTE: Compression was disabled for data set WORK.HDR_N because compression overhead would increase the size of the data set.
2891NOTE: There were 0 observations read from the data set WORK.HDR_NC.
2892NOTE: The data set WORK.HDR_N has 1 observations and 2 variables.
2893NOTE: PROCEDURE TRANSPOSE used (Total process time):
2894 real time 0.00 seconds
2895 user cpu time 0.00 seconds
2896 system cpu time 0.00 seconds
2897 memory 2575.75k
2898 OS Memory 190548.00k
2899 Timestamp 24.07.2019 02:31:40 после полудня
2900 Step Count 1956 Switch Count 22
2901 Page Faults 0
2902 Page Reclaims 5
2903 Page Swaps 0
2904 The SAS System
2905
2906 Voluntary Context Switches 32
2907 Involuntary Context Switches 32
2908 Block Input Operations 0
2909 Block Output Operations 0
2910
2911
2912
2913NOTE: Compression was disabled for data set WORK.HDR_N because compression overhead would increase the size of the data set.
2914NOTE: There were 1 observations read from the data set WORK.HDR_N.
2915NOTE: The data set WORK.HDR_N has 0 observations and 2 variables.
2916NOTE: DATA statement used (Total process time):
2917 real time 0.00 seconds
2918 user cpu time 0.00 seconds
2919 system cpu time 0.00 seconds
2920 memory 920.65k
2921 OS Memory 188752.00k
2922 Timestamp 24.07.2019 02:31:40 после полудня
2923 Step Count 1957 Switch Count 22
2924 Page Faults 0
2925 Page Reclaims 70
2926 Page Swaps 0
2927 Voluntary Context Switches 32
2928 Involuntary Context Switches 33
2929 Block Input Operations 0
2930 Block Output Operations 0
2931
2932
2933WARNING: Variable PARTY_RK already exists on file WORK.HDR_ALL_CN.
2934WARNING: Variable ROW_NO already exists on file WORK.HDR_ALL_CN.
2935NOTE: SAS threaded sort was used.
2936NOTE: Compressing data set WORK.HDR_ALL_CN increased size by 100.00 percent.
2937 Compressed is 2 pages; un-compressed would require 1 pages.
2938NOTE: Table WORK.HDR_ALL_CN created, with 1 rows and 12 columns.
2939
2940NOTE: PROCEDURE SQL used (Total process time):
2941 real time 0.00 seconds
2942 user cpu time 0.01 seconds
2943 system cpu time 0.01 seconds
2944 The SAS System
2945
2946 memory 5795.00k
2947 OS Memory 193880.00k
2948 Timestamp 24.07.2019 02:31:40 после полудня
2949 Step Count 1958 Switch Count 32
2950 Page Faults 0
2951 Page Reclaims 346
2952 Page Swaps 0
2953 Voluntary Context Switches 79
2954 Involuntary Context Switches 65
2955 Block Input Operations 0
2956 Block Output Operations 0
2957
2958
2959NOTE: Compressing data set WORK.HDR_DC increased size by 100.00 percent.
2960 Compressed is 2 pages; un-compressed would require 1 pages.
2961NOTE: Table WORK.HDR_DC created, with 2 rows and 4 columns.
2962
2963NOTE: PROCEDURE SQL used (Total process time):
2964 real time 0.01 seconds
2965 user cpu time 0.01 seconds
2966 system cpu time 0.00 seconds
2967 memory 5436.40k
2968 OS Memory 193876.00k
2969 Timestamp 24.07.2019 02:31:40 после полудня
2970 Step Count 1959 Switch Count 22
2971 Page Faults 0
2972 Page Reclaims 114
2973 Page Swaps 0
2974 Voluntary Context Switches 41
2975 Involuntary Context Switches 6
2976 Block Input Operations 0
2977 Block Output Operations 0
2978
2979
2980NOTE: {START: fcf_chkrc}
2981NOTE: {END: fcf_chkrc}
2982
2983NOTE: There were 2 observations read from the data set WORK.HDR_DC.
2984 The SAS System
2985
2986NOTE: The data set WORK.HDR_D has 1 observations and 4 variables.
2987NOTE: Compressing data set WORK.HDR_D increased size by 100.00 percent.
2988 Compressed is 2 pages; un-compressed would require 1 pages.
2989NOTE: PROCEDURE TRANSPOSE used (Total process time):
2990 real time 0.00 seconds
2991 user cpu time 0.00 seconds
2992 system cpu time 0.00 seconds
2993 memory 2575.81k
2994 OS Memory 190548.00k
2995 Timestamp 24.07.2019 02:31:40 после полудня
2996 Step Count 1960 Switch Count 28
2997 Page Faults 0
2998 Page Reclaims 40
2999 Page Swaps 0
3000 Voluntary Context Switches 56
3001 Involuntary Context Switches 56
3002 Block Input Operations 0
3003 Block Output Operations 0
3004
3005
3006
3007NOTE: There were 1 observations read from the data set WORK.HDR_D.
3008NOTE: The data set WORK.HDR_D has 1 observations and 4 variables.
3009NOTE: Compressing data set WORK.HDR_D increased size by 100.00 percent.
3010 Compressed is 2 pages; un-compressed would require 1 pages.
3011NOTE: DATA statement used (Total process time):
3012 real time 0.00 seconds
3013 user cpu time 0.01 seconds
3014 system cpu time 0.01 seconds
3015 memory 919.84k
3016 OS Memory 188496.00k
3017 Timestamp 24.07.2019 02:31:40 после полудня
3018 Step Count 1961 Switch Count 24
3019 Page Faults 0
3020 Page Reclaims 72
3021 Page Swaps 0
3022 Voluntary Context Switches 40
3023 Involuntary Context Switches 40
3024 The SAS System
3025
3026 Block Input Operations 0
3027 Block Output Operations 0
3028
3029
3030WARNING: Variable PARTY_RK already exists on file WORK.HDR_ALL.
3031WARNING: Variable ROW_NO already exists on file WORK.HDR_ALL.
3032NOTE: Compressing data set WORK.HDR_ALL increased size by 100.00 percent.
3033 Compressed is 2 pages; un-compressed would require 1 pages.
3034NOTE: Table WORK.HDR_ALL created, with 1 rows and 14 columns.
3035
3036NOTE: PROCEDURE SQL used (Total process time):
3037 real time 0.00 seconds
3038 user cpu time 0.00 seconds
3039 system cpu time 0.00 seconds
3040 memory 5796.09k
3041 OS Memory 193624.00k
3042 Timestamp 24.07.2019 02:31:40 после полудня
3043 Step Count 1962 Switch Count 26
3044 Page Faults 0
3045 Page Reclaims 84
3046 Page Swaps 0
3047 Voluntary Context Switches 48
3048 Involuntary Context Switches 48
3049 Block Input Operations 0
3050 Block Output Operations 0
3051
3052
3053NOTE: {START: fcf_chkrc}
3054NOTE: {END: fcf_chkrc}
3055WARNING: Variable LSTUPDATE_DATE already exists on file WORK.HDR_FIX1.
3056NOTE: Compressing data set WORK.HDR_FIX1 increased size by 100.00 percent.
3057 Compressed is 2 pages; un-compressed would require 1 pages.
3058NOTE: Table WORK.HDR_FIX1 created, with 1 rows and 16 columns.
3059
3060NOTE: PROCEDURE SQL used (Total process time):
3061 real time 21.48 seconds
3062 user cpu time 12.74 seconds
3063 system cpu time 0.81 seconds
3064 The SAS System
3065
3066 memory 5779.06k
3067 OS Memory 193624.00k
3068 Timestamp 24.07.2019 02:32:02 после полудня
3069 Step Count 1963 Switch Count 29
3070 Page Faults 0
3071 Page Reclaims 229
3072 Page Swaps 0
3073 Voluntary Context Switches 10758
3074 Involuntary Context Switches 2230
3075 Block Input Operations 0
3076 Block Output Operations 0
3077
3078
3079NOTE: {START: fcf_chkrc}
3080NOTE: {END: fcf_chkrc}
3081NOTE: Table WORK.ORPHAN_SCR created, with 0 rows and 32 columns.
3082
3083NOTE: PROCEDURE SQL used (Total process time):
3084 real time 0.00 seconds
3085 user cpu time 0.01 seconds
3086 system cpu time 0.01 seconds
3087 memory 6326.68k
3088 OS Memory 193884.00k
3089 Timestamp 24.07.2019 02:32:02 после полудня
3090 Step Count 1964 Switch Count 18
3091 Page Faults 0
3092 Page Reclaims 128
3093 Page Swaps 0
3094 Voluntary Context Switches 16
3095 Involuntary Context Switches 16
3096 Block Input Operations 0
3097 Block Output Operations 0
3098
3099
3100
3101WARNING: The variable _LABEL_ in the DROP, KEEP, or RENAME list has never been referenced.
3102WARNING: The variable _NAME_ in the DROP, KEEP, or RENAME list has never been referenced.
3103WARNING: The variable X_CREATE_USER_ID in the DROP, KEEP, or RENAME list has never been referenced.
3104 The SAS System
3105
3106WARNING: The variable LSTUPDATE_DATE_OLD in the DROP, KEEP, or RENAME list has never been referenced.
3107NOTE: There were 1 observations read from the data set WORK.HDR_FIX1.
3108NOTE: The data set WORK.HDR_FIX has 1 observations and 17 variables.
3109NOTE: Compressing data set WORK.HDR_FIX increased size by 100.00 percent.
3110 Compressed is 2 pages; un-compressed would require 1 pages.
3111NOTE: DATA statement used (Total process time):
3112 real time 0.01 seconds
3113 user cpu time 0.01 seconds
3114 system cpu time 0.00 seconds
3115 memory 1270.18k
3116 OS Memory 188760.00k
3117 Timestamp 24.07.2019 02:32:02 после полудня
3118 Step Count 1965 Switch Count 36
3119 Page Faults 0
3120 Page Reclaims 142
3121 Page Swaps 0
3122 Voluntary Context Switches 88
3123 Involuntary Context Switches 89
3124 Block Input Operations 0
3125 Block Output Operations 0
3126
3127
3128NOTE: {START: fcf_chkrc}
3129NOTE: {END: fcf_chkrc}
3130
3131NOTE: Appending WORK.HDR_FIX to WORK.FSK_HEADER.
3132WARNING: Variable PARTY_RK was not found on BASE file. The variable will not be added to the BASE file.
3133WARNING: Variable LSTUPDATE_DATE has format DATETIME20. on the BASE data set and format DATETIME27. on the DATA data set. DATETIME20. used.
3134WARNING: Variable CREATE_DATE has format DATETIME20. on the BASE data set and format DATETIME27. on the DATA data set. DATETIME20. used.
3135WARNING: Variable DAV_FILE_NAME was not found on BASE file. The variable will not be added to the BASE file.
3136WARNING: Variable HEADER_NAME has different lengths on BASE and DATA files (BASE 32 DATA 1024).
3137WARNING: Variable HEADER_DESCRIPTION has different lengths on BASE and DATA files (BASE 255 DATA 1024).
3138WARNING: Variable ENTITY_LEVEL_CODE has different lengths on BASE and DATA files (BASE 3 DATA 1024).
3139WARNING: Variable DENORM_TABLE_NAME has different lengths on BASE and DATA files (BASE 32 DATA 1024).
3140WARNING: Variable ALERT_TABLE_NAME has different lengths on BASE and DATA files (BASE 24 DATA 1024).
3141WARNING: Variable HEADER_AUTOGEN_IND has different lengths on BASE and DATA files (BASE 1 DATA 1024).
3142WARNING: Variable SOURCE_TYPE_DESC has different lengths on BASE and DATA files (BASE 32 DATA 1024).
3143WARNING: Variable HEADER_HOST_DESC has different lengths on BASE and DATA files (BASE 50 DATA 1024).
3144 The SAS System
3145
3146WARNING: Variable LOGICAL_DELETE_IND has different lengths on BASE and DATA files (BASE 1 DATA 1024).
3147NOTE: FORCE is specified, so dropping/truncating will occur.
3148
3149INFO: Engine's fast-append process in use.
3150INFO: 14:32:02 Reading DATA file, updating BASE file
3151INFO: Starting data set size is 2 pages
3152INFO: Ending data set size is 2 pages, 0 added.
3153INFO: 00:00:00 Elapsed time
3154INFO: 14:32:02 Finished updating BASE file
3155
3156NOTE: There were 1 observations read from the data set WORK.HDR_FIX.
3157NOTE: 1 observations added.
3158NOTE: The data set WORK.FSK_HEADER has 1 observations and 15 variables.
3159NOTE: PROCEDURE APPEND used (Total process time):
3160 real time 0.02 seconds
3161 user cpu time 0.02 seconds
3162 system cpu time 0.00 seconds
3163 memory 2615.25k
3164 OS Memory 188500.00k
3165 Timestamp 24.07.2019 02:32:02 после полудня
3166 Step Count 1966 Switch Count 73
3167 Page Faults 0
3168 Page Reclaims 113
3169 Page Swaps 0
3170 Voluntary Context Switches 235
3171 Involuntary Context Switches 233
3172 Block Input Operations 0
3173 Block Output Operations 0
3174
3175
3176NOTE: Table WORK.SCRXRG created, with 0 rows and 4 columns.
3177
3178NOTE: PROCEDURE SQL used (Total process time):
3179 real time 0.00 seconds
3180 user cpu time 0.01 seconds
3181 system cpu time 0.00 seconds
3182 memory 5279.18k
3183 OS Memory 193364.00k
3184 The SAS System
3185
3186 Timestamp 24.07.2019 02:32:02 после полудня
3187 Step Count 1967 Switch Count 23
3188 Page Faults 0
3189 Page Reclaims 107
3190 Page Swaps 0
3191 Voluntary Context Switches 28
3192 Involuntary Context Switches 3
3193 Block Input Operations 0
3194 Block Output Operations 0
3195
3196
3197NOTE: {START: fcf_chkrc}
3198NOTE: {END: fcf_chkrc}
3199NOTE: No rows were selected.
3200NOTE: PROCEDURE SQL used (Total process time):
3201 real time 0.00 seconds
3202 user cpu time 0.00 seconds
3203 system cpu time 0.00 seconds
3204 memory 5305.40k
3205 OS Memory 193364.00k
3206 Timestamp 24.07.2019 02:32:02 после полудня
3207 Step Count 1968 Switch Count 16
3208 Page Faults 0
3209 Page Reclaims 8
3210 Page Swaps 0
3211 Voluntary Context Switches 9
3212 Involuntary Context Switches 0
3213 Block Input Operations 0
3214 Block Output Operations 0
3215
3216
32170
3218NOTE: Table WORK.RG_CC created, with 0 rows and 4 columns.
3219
3220NOTE: PROCEDURE SQL used (Total process time):
3221 real time 0.01 seconds
3222 user cpu time 0.01 seconds
3223 system cpu time 0.00 seconds
3224 The SAS System
3225
3226 memory 20467.15k
3227 OS Memory 208268.00k
3228 Timestamp 24.07.2019 02:32:02 после полудня
3229 Step Count 1969 Switch Count 23
3230 Page Faults 0
3231 Page Reclaims 937
3232 Page Swaps 0
3233 Voluntary Context Switches 28
3234 Involuntary Context Switches 4
3235 Block Input Operations 0
3236 Block Output Operations 0
3237
3238
3239NOTE: {START: fcf_chkrc}
3240NOTE: {END: fcf_chkrc}
3241
3242NOTE: Compression was disabled for data set WORK.RG_C because compression overhead would increase the size of the data set.
3243NOTE: There were 0 observations read from the data set WORK.RG_CC.
3244NOTE: The data set WORK.RG_C has 1 observations and 2 variables.
3245NOTE: PROCEDURE TRANSPOSE used (Total process time):
3246 real time 0.00 seconds
3247 user cpu time 0.01 seconds
3248 system cpu time 0.00 seconds
3249 memory 2573.12k
3250 OS Memory 190292.00k
3251 Timestamp 24.07.2019 02:32:02 после полудня
3252 Step Count 1970 Switch Count 22
3253 Page Faults 0
3254 Page Reclaims 43
3255 Page Swaps 0
3256 Voluntary Context Switches 33
3257 Involuntary Context Switches 5
3258 Block Input Operations 0
3259 Block Output Operations 0
3260
3261
3262
3263NOTE: Compression was disabled for data set WORK.RG_C because compression overhead would increase the size of the data set.
3264 The SAS System
3265
3266NOTE: There were 1 observations read from the data set WORK.RG_C.
3267NOTE: The data set WORK.RG_C has 0 observations and 2 variables.
3268NOTE: DATA statement used (Total process time):
3269 real time 0.01 seconds
3270 user cpu time 0.01 seconds
3271 system cpu time 0.01 seconds
3272 memory 923.06k
3273 OS Memory 188496.00k
3274 Timestamp 24.07.2019 02:32:02 после полудня
3275 Step Count 1971 Switch Count 26
3276 Page Faults 0
3277 Page Reclaims 96
3278 Page Swaps 0
3279 Voluntary Context Switches 49
3280 Involuntary Context Switches 1
3281 Block Input Operations 0
3282 Block Output Operations 0
3283
3284
3285NOTE: Compression was disabled for data set WORK.RG_ALL_CN because compression overhead would increase the size of the data set.
3286NOTE: Table WORK.RG_ALL_CN created, with 0 rows and 2 columns.
3287
3288NOTE: PROCEDURE SQL used (Total process time):
3289 real time 0.00 seconds
3290 user cpu time 0.01 seconds
3291 system cpu time 0.00 seconds
3292 memory 5315.65k
3293 OS Memory 193364.00k
3294 Timestamp 24.07.2019 02:32:02 после полудня
3295 Step Count 1972 Switch Count 20
3296 Page Faults 0
3297 Page Reclaims 7
3298 Page Swaps 0
3299 Voluntary Context Switches 27
3300 Involuntary Context Switches 0
3301 Block Input Operations 0
3302 Block Output Operations 0
3303
3304 The SAS System
3305
3306
3307NOTE: Compression was disabled for data set WORK.RG_ALL because compression overhead would increase the size of the data set.
3308NOTE: Table WORK.RG_ALL created, with 0 rows and 2 columns.
3309
3310NOTE: PROCEDURE SQL used (Total process time):
3311 real time 0.00 seconds
3312 user cpu time 0.01 seconds
3313 system cpu time 0.00 seconds
3314 memory 5315.84k
3315 OS Memory 193364.00k
3316 Timestamp 24.07.2019 02:32:02 после полудня
3317 Step Count 1973 Switch Count 20
3318 Page Faults 0
3319 Page Reclaims 7
3320 Page Swaps 0
3321 Voluntary Context Switches 25
3322 Involuntary Context Switches 0
3323 Block Input Operations 0
3324 Block Output Operations 0
3325
3326
3327NOTE: {START: fcf_chkrc}
3328NOTE: {END: fcf_chkrc}
3329
3330NOTE: Compression was disabled for data set WORK.RG_FIX because compression overhead would increase the size of the data set.
3331NOTE: The data set WORK.RG_FIX has 0 observations and 4 variables.
3332NOTE: DATA statement used (Total process time):
3333 real time 0.00 seconds
3334 user cpu time 0.01 seconds
3335 system cpu time 0.00 seconds
3336 memory 774.21k
3337 OS Memory 188496.00k
3338 Timestamp 24.07.2019 02:32:02 после полудня
3339 Step Count 1974 Switch Count 20
3340 Page Faults 0
3341 Page Reclaims 75
3342 Page Swaps 0
3343 Voluntary Context Switches 25
3344 The SAS System
3345
3346 Involuntary Context Switches 0
3347 Block Input Operations 0
3348 Block Output Operations 0
3349
3350
3351NOTE: SAS threaded sort was used.
3352NOTE: Compressing data set WORK.SCR_FULL increased size by 100.00 percent.
3353 Compressed is 2 pages; un-compressed would require 1 pages.
3354NOTE: Table WORK.SCR_FULL created, with 1 rows and 33 columns.
3355
3356NOTE: PROCEDURE SQL used (Total process time):
3357 real time 0.03 seconds
3358 user cpu time 0.02 seconds
3359 system cpu time 0.01 seconds
3360 memory 44559.56k
3361 OS Memory 230256.00k
3362 Timestamp 24.07.2019 02:32:02 после полудня
3363 Step Count 1975 Switch Count 24
3364 Page Faults 0
3365 Page Reclaims 853
3366 Page Swaps 0
3367 Voluntary Context Switches 118
3368 Involuntary Context Switches 9
3369 Block Input Operations 0
3370 Block Output Operations 0
3371
3372
3373NOTE: {START: fcf_chkrc}
3374NOTE: {END: fcf_chkrc}
3375
3376NOTE: Appending WORK.SCR_FULL to WORK.FSK_SCENARIO.
3377WARNING: Variable SCENARIO_CODE_LOCATION_DESC has format $255. on the BASE data set and format $4000. on the DATA data set. $255. used.
3378WARNING: Variable LSTUPDATE_DATE has format DATETIME20. on the BASE data set and format DATETIME27. on the DATA data set. DATETIME20. used.
3379WARNING: Variable PARTY_RK was not found on BASE file. The variable will not be added to the BASE file.
3380WARNING: Variable CREATE_DATE has format DATETIME20. on the BASE data set and format DATETIME27. on the DATA data set. DATETIME20. used.
3381WARNING: Variable END_DATE has format DATETIME20. on the BASE data set and format DATETIME27. on the DATA data set. DATETIME20. used.
3382WARNING: Variable DAV_FILE_NAME was not found on BASE file. The variable will not be added to the BASE file.
3383WARNING: Variable SCENARIO_NAME has different lengths on BASE and DATA files (BASE 32 DATA 1024).
3384 The SAS System
3385
3386WARNING: Variable SCENARIO_SHORT_DESCRIPTION has different lengths on BASE and DATA files (BASE 100 DATA 1024).
3387WARNING: Variable SCENARIO_DESCRIPTION has different lengths on BASE and DATA files (BASE 255 DATA 1024).
3388WARNING: Variable SCENARIO_CATEGORY_CODE has different lengths on BASE and DATA files (BASE 3 DATA 1024).
3389WARNING: Variable PRODUCT_TYPE_CODE has different lengths on BASE and DATA files (BASE 3 DATA 1024).
3390WARNING: Variable SCENARIO_STATUS_CODE has different lengths on BASE and DATA files (BASE 3 DATA 1024).
3391WARNING: Variable CURRENT_IND has different lengths on BASE and DATA files (BASE 1 DATA 1024).
3392WARNING: Variable RISK_FACTOR_IND has different lengths on BASE and DATA files (BASE 1 DATA 1024).
3393WARNING: Variable END_USER_ID was not found on DATA file.
3394WARNING: Variable LOGICAL_DELETE_IND has different lengths on BASE and DATA files (BASE 1 DATA 1024).
3395WARNING: Variable ALERT_TYPE_CD has different lengths on BASE and DATA files (BASE 32 DATA 1024).
3396WARNING: Variable ALERT_CATEGORY_CD has different lengths on BASE and DATA files (BASE 32 DATA 1024).
3397WARNING: Variable ALERT_SUBCATEGORY_CD has different lengths on BASE and DATA files (BASE 32 DATA 1024).
3398WARNING: Variable ROUTING_USER_LONG_ID was not found on DATA file.
3399WARNING: Variable SCENARIO_TYPE_CODE has different lengths on BASE and DATA files (BASE 3 DATA 1024).
3400WARNING: Variable SCENARIO_RUN_FREQUENCY_CODE has different lengths on BASE and DATA files (BASE 3 DATA 1024).
3401WARNING: Variable SKIP_IF_NO_TRANS_CURR_DAY_IND was not found on DATA file.
3402WARNING: Variable ENTITY_LEVEL_CODE has different lengths on BASE and DATA files (BASE 3 DATA 1024).
3403WARNING: Variable PRIMARY_ENTITY_NUMBER_VAR_NAME was not found on DATA file.
3404NOTE: FORCE is specified, so dropping/truncating will occur.
3405
3406INFO: Engine's fast-append process in use.
3407INFO: 14:32:02 Reading DATA file, updating BASE file
3408INFO: Starting data set size is 2 pages
3409INFO: Ending data set size is 2 pages, 0 added.
3410INFO: 00:00:00 Elapsed time
3411INFO: 14:32:02 Finished updating BASE file
3412
3413NOTE: There were 1 observations read from the data set WORK.SCR_FULL.
3414NOTE: 1 observations added.
3415NOTE: The data set WORK.FSK_SCENARIO has 1 observations and 35 variables.
3416NOTE: PROCEDURE APPEND used (Total process time):
3417 real time 0.00 seconds
3418 user cpu time 0.01 seconds
3419 system cpu time 0.01 seconds
3420 memory 987.56k
3421 OS Memory 189524.00k
3422 Timestamp 24.07.2019 02:32:02 после полудня
3423 Step Count 1976 Switch Count 96
3424 The SAS System
3425
3426 Page Faults 0
3427 Page Reclaims 37
3428 Page Swaps 0
3429 Voluntary Context Switches 343
3430 Involuntary Context Switches 206
3431 Block Input Operations 0
3432 Block Output Operations 0
3433
3434
3435NOTE: Compressing data set WORK.COL_CC increased size by 100.00 percent.
3436 Compressed is 2 pages; un-compressed would require 1 pages.
3437NOTE: Table WORK.COL_CC created, with 48 rows and 4 columns.
3438
3439NOTE: PROCEDURE SQL used (Total process time):
3440 real time 0.02 seconds
3441 user cpu time 0.01 seconds
3442 system cpu time 0.01 seconds
3443 memory 20457.15k
3444 OS Memory 209292.00k
3445 Timestamp 24.07.2019 02:32:02 после полудня
3446 Step Count 1977 Switch Count 23
3447 Page Faults 0
3448 Page Reclaims 940
3449 Page Swaps 0
3450 Voluntary Context Switches 48
3451 Involuntary Context Switches 9
3452 Block Input Operations 0
3453 Block Output Operations 0
3454
3455
3456NOTE: {START: fcf_chkrc}
3457NOTE: {END: fcf_chkrc}
3458
3459NOTE: There were 48 observations read from the data set WORK.COL_CC.
3460NOTE: The data set WORK.COL_C has 16 observations and 5 variables.
3461NOTE: Compressing data set WORK.COL_C increased size by 100.00 percent.
3462 Compressed is 2 pages; un-compressed would require 1 pages.
3463NOTE: PROCEDURE TRANSPOSE used (Total process time):
3464 The SAS System
3465
3466 real time 0.00 seconds
3467 user cpu time 0.00 seconds
3468 system cpu time 0.00 seconds
3469 memory 2588.06k
3470 OS Memory 191316.00k
3471 Timestamp 24.07.2019 02:32:02 после полудня
3472 Step Count 1978 Switch Count 28
3473 Page Faults 0
3474 Page Reclaims 75
3475 Page Swaps 0
3476 Voluntary Context Switches 40
3477 Involuntary Context Switches 44
3478 Block Input Operations 0
3479 Block Output Operations 0
3480
3481
3482
3483NOTE: There were 16 observations read from the data set WORK.COL_C.
3484NOTE: The data set WORK.COL_C has 16 observations and 5 variables.
3485NOTE: Compressing data set WORK.COL_C increased size by 100.00 percent.
3486 Compressed is 2 pages; un-compressed would require 1 pages.
3487NOTE: DATA statement used (Total process time):
3488 real time 0.00 seconds
3489 user cpu time 0.01 seconds
3490 system cpu time 0.00 seconds
3491 memory 1196.40k
3492 OS Memory 189784.00k
3493 Timestamp 24.07.2019 02:32:02 после полудня
3494 Step Count 1979 Switch Count 24
3495 Page Faults 0
3496 Page Reclaims 140
3497 Page Swaps 0
3498 Voluntary Context Switches 40
3499 Involuntary Context Switches 40
3500 Block Input Operations 0
3501 Block Output Operations 0
3502
3503
3504 The SAS System
3505
3506NOTE: Compressing data set WORK.COL_ALL_CN increased size by 100.00 percent.
3507 Compressed is 2 pages; un-compressed would require 1 pages.
3508NOTE: Table WORK.COL_ALL_CN created, with 16 rows and 5 columns.
3509
3510NOTE: PROCEDURE SQL used (Total process time):
3511 real time 0.00 seconds
3512 user cpu time 0.00 seconds
3513 system cpu time 0.01 seconds
3514 memory 5587.62k
3515 OS Memory 194648.00k
3516 Timestamp 24.07.2019 02:32:02 после полудня
3517 Step Count 1980 Switch Count 26
3518 Page Faults 0
3519 Page Reclaims 75
3520 Page Swaps 0
3521 Voluntary Context Switches 48
3522 Involuntary Context Switches 48
3523 Block Input Operations 0
3524 Block Output Operations 0
3525
3526
3527NOTE: Compressing data set WORK.COL_ALL increased size by 100.00 percent.
3528 Compressed is 2 pages; un-compressed would require 1 pages.
3529NOTE: Table WORK.COL_ALL created, with 16 rows and 5 columns.
3530
3531NOTE: PROCEDURE SQL used (Total process time):
3532 real time 0.00 seconds
3533 user cpu time 0.00 seconds
3534 system cpu time 0.00 seconds
3535 memory 5587.62k
3536 OS Memory 194648.00k
3537 Timestamp 24.07.2019 02:32:02 после полудня
3538 Step Count 1981 Switch Count 22
3539 Page Faults 0
3540 Page Reclaims 75
3541 Page Swaps 0
3542 Voluntary Context Switches 32
3543 Involuntary Context Switches 32
3544 The SAS System
3545
3546 Block Input Operations 0
3547 Block Output Operations 0
3548
3549
3550NOTE: {START: fcf_chkrc}
3551NOTE: {END: fcf_chkrc}
3552NOTE: SAS threaded sort was used.
3553NOTE: Compressing data set WORK.DATASET_LIST increased size by 100.00 percent.
3554 Compressed is 2 pages; un-compressed would require 1 pages.
3555NOTE: Table WORK.DATASET_LIST created, with 44 rows and 1 columns.
3556
3557NOTE: PROCEDURE SQL used (Total process time):
3558 real time 0.01 seconds
3559 user cpu time 0.01 seconds
3560 system cpu time 0.01 seconds
3561 memory 5159.96k
3562 OS Memory 194388.00k
3563 Timestamp 24.07.2019 02:32:02 после полудня
3564 Step Count 1982 Switch Count 24
3565 Page Faults 0
3566 Page Reclaims 137
3567 Page Swaps 0
3568 Voluntary Context Switches 66
3569 Involuntary Context Switches 41
3570 Block Input Operations 0
3571 Block Output Operations 0
3572
3573
3574
3575NOTE: There were 44 observations read from the data set WORK.DATASET_LIST.
3576NOTE: The data set WORK.ELEMENTS has 574 observations and 6 variables.
3577NOTE: Compressing data set WORK.ELEMENTS decreased size by 0.00 percent.
3578 Compressed is 2 pages; un-compressed would require 2 pages.
3579NOTE: DATA statement used (Total process time):
3580 real time 0.02 seconds
3581 user cpu time 0.02 seconds
3582 system cpu time 0.01 seconds
3583 memory 1130.56k
3584 The SAS System
3585
3586 OS Memory 189524.00k
3587 Timestamp 24.07.2019 02:32:02 после полудня
3588 Step Count 1983 Switch Count 28
3589 Page Faults 0
3590 Page Reclaims 158
3591 Page Swaps 0
3592 Voluntary Context Switches 40
3593 Involuntary Context Switches 41
3594 Block Input Operations 0
3595 Block Output Operations 0
3596
3597
3598NOTE: Compressing data set WORK.COL_FIX increased size by 100.00 percent.
3599 Compressed is 2 pages; un-compressed would require 1 pages.
3600NOTE: Table WORK.COL_FIX created, with 16 rows and 9 columns.
3601
3602NOTE: PROCEDURE SQL used (Total process time):
3603 real time 0.01 seconds
3604 user cpu time 0.01 seconds
3605 system cpu time 0.01 seconds
3606 memory 6485.34k
3607 OS Memory 194908.00k
3608 Timestamp 24.07.2019 02:32:02 после полудня
3609 Step Count 1984 Switch Count 22
3610 Page Faults 0
3611 Page Reclaims 650
3612 Page Swaps 0
3613 Voluntary Context Switches 32
3614 Involuntary Context Switches 32
3615 Block Input Operations 0
3616 Block Output Operations 0
3617
3618
3619NOTE: {START: fcf_chkrc}
3620NOTE: {END: fcf_chkrc}
3621
3622WARNING: The variable _LABEL_ in the DROP, KEEP, or RENAME list has never been referenced.
3623WARNING: The variable _NAME_ in the DROP, KEEP, or RENAME list has never been referenced.
3624 The SAS System
3625
3626NOTE: There were 16 observations read from the data set WORK.COL_FIX.
3627NOTE: The data set WORK.COL_FULL has 16 observations and 7 variables.
3628NOTE: Compressing data set WORK.COL_FULL increased size by 100.00 percent.
3629 Compressed is 2 pages; un-compressed would require 1 pages.
3630NOTE: DATA statement used (Total process time):
3631 real time 0.01 seconds
3632 user cpu time 0.01 seconds
3633 system cpu time 0.01 seconds
3634 memory 1207.43k
3635 OS Memory 189780.00k
3636 Timestamp 24.07.2019 02:32:02 после полудня
3637 Step Count 1985 Switch Count 32
3638 Page Faults 0
3639 Page Reclaims 108
3640 Page Swaps 0
3641 Voluntary Context Switches 72
3642 Involuntary Context Switches 73
3643 Block Input Operations 0
3644 Block Output Operations 0
3645
3646
3647NOTE: {START: fcf_chkrc}
3648NOTE: {END: fcf_chkrc}
3649
3650NOTE: Appending WORK.COL_FULL to WORK.FSK_HEADER_ELEMENT.
3651WARNING: Variable ELEMENT_NAME has different lengths on BASE and DATA files (BASE 35 DATA 1024).
3652WARNING: Variable ELEMENT_FORMAT_CODE has different lengths on BASE and DATA files (BASE 12 DATA 8).
3653WARNING: Variable ELEMENT_USAGE_DESC has different lengths on BASE and DATA files (BASE 35 DATA 1024).
3654NOTE: FORCE is specified, so dropping/truncating will occur.
3655
3656INFO: Engine's fast-append process in use.
3657INFO: 14:32:02 Reading DATA file, updating BASE file
3658INFO: Starting data set size is 2 pages
3659INFO: Ending data set size is 2 pages, 0 added.
3660INFO: 00:00:00 Elapsed time
3661INFO: 14:32:02 Finished updating BASE file
3662
3663NOTE: There were 16 observations read from the data set WORK.COL_FULL.
3664 The SAS System
3665
3666NOTE: 16 observations added.
3667NOTE: The data set WORK.FSK_HEADER_ELEMENT has 16 observations and 7 variables.
3668NOTE: PROCEDURE APPEND used (Total process time):
3669 real time 0.00 seconds
3670 user cpu time 0.01 seconds
3671 system cpu time 0.00 seconds
3672 memory 671.34k
3673 OS Memory 189264.00k
3674 Timestamp 24.07.2019 02:32:02 после полудня
3675 Step Count 1986 Switch Count 52
3676 Page Faults 0
3677 Page Reclaims 3
3678 Page Swaps 0
3679 Voluntary Context Switches 152
3680 Involuntary Context Switches 152
3681 Block Input Operations 0
3682 Block Output Operations 0
3683
3684
3685NOTE: Table WORK.SP_CC created, with 0 rows and 4 columns.
3686
3687NOTE: PROCEDURE SQL used (Total process time):
3688 real time 0.02 seconds
3689 user cpu time 0.01 seconds
3690 system cpu time 0.02 seconds
3691 memory 20476.65k
3692 OS Memory 209036.00k
3693 Timestamp 24.07.2019 02:32:02 после полудня
3694 Step Count 1987 Switch Count 19
3695 Page Faults 0
3696 Page Reclaims 928
3697 Page Swaps 0
3698 Voluntary Context Switches 24
3699 Involuntary Context Switches 10
3700 Block Input Operations 0
3701 Block Output Operations 0
3702
3703
3704 The SAS System
3705
3706NOTE: {START: fcf_chkrc}
3707NOTE: {END: fcf_chkrc}
3708
3709NOTE: Compression was disabled for data set WORK.SP_C because compression overhead would increase the size of the data set.
3710NOTE: There were 0 observations read from the data set WORK.SP_CC.
3711NOTE: The data set WORK.SP_C has 1 observations and 2 variables.
3712NOTE: PROCEDURE TRANSPOSE used (Total process time):
3713 real time 0.00 seconds
3714 user cpu time 0.01 seconds
3715 system cpu time 0.01 seconds
3716 memory 2572.00k
3717 OS Memory 191316.00k
3718 Timestamp 24.07.2019 02:32:02 после полудня
3719 Step Count 1988 Switch Count 22
3720 Page Faults 0
3721 Page Reclaims 40
3722 Page Swaps 0
3723 Voluntary Context Switches 40
3724 Involuntary Context Switches 21
3725 Block Input Operations 0
3726 Block Output Operations 0
3727
3728
3729
3730NOTE: Compression was disabled for data set WORK.SP_C because compression overhead would increase the size of the data set.
3731NOTE: There were 1 observations read from the data set WORK.SP_C.
3732NOTE: The data set WORK.SP_C has 0 observations and 2 variables.
3733NOTE: DATA statement used (Total process time):
3734 real time 0.00 seconds
3735 user cpu time 0.01 seconds
3736 system cpu time 0.00 seconds
3737 memory 923.18k
3738 OS Memory 189520.00k
3739 Timestamp 24.07.2019 02:32:02 после полудня
3740 Step Count 1989 Switch Count 22
3741 Page Faults 0
3742 Page Reclaims 71
3743 Page Swaps 0
3744 The SAS System
3745
3746 Voluntary Context Switches 40
3747 Involuntary Context Switches 25
3748 Block Input Operations 0
3749 Block Output Operations 0
3750
3751
3752NOTE: Compression was disabled for data set WORK.SP_ALL_CN because compression overhead would increase the size of the data set.
3753NOTE: Table WORK.SP_ALL_CN created, with 0 rows and 2 columns.
3754
3755NOTE: PROCEDURE SQL used (Total process time):
3756 real time 0.00 seconds
3757 user cpu time 0.01 seconds
3758 system cpu time 0.00 seconds
3759 memory 5315.65k
3760 OS Memory 194388.00k
3761 Timestamp 24.07.2019 02:32:02 после полудня
3762 Step Count 1990 Switch Count 20
3763 Page Faults 0
3764 Page Reclaims 7
3765 Page Swaps 0
3766 Voluntary Context Switches 30
3767 Involuntary Context Switches 18
3768 Block Input Operations 0
3769 Block Output Operations 0
3770
3771
3772NOTE: Compression was disabled for data set WORK.SP_ALL because compression overhead would increase the size of the data set.
3773NOTE: Table WORK.SP_ALL created, with 0 rows and 2 columns.
3774
3775NOTE: PROCEDURE SQL used (Total process time):
3776 real time 0.00 seconds
3777 user cpu time 0.00 seconds
3778 system cpu time 0.00 seconds
3779 memory 5314.65k
3780 OS Memory 194388.00k
3781 Timestamp 24.07.2019 02:32:02 после полудня
3782 Step Count 1991 Switch Count 20
3783 Page Faults 0
3784 The SAS System
3785
3786 Page Reclaims 7
3787 Page Swaps 0
3788 Voluntary Context Switches 30
3789 Involuntary Context Switches 19
3790 Block Input Operations 0
3791 Block Output Operations 0
3792
3793
3794NOTE: {START: fcf_chkrc}
3795NOTE: {END: fcf_chkrc}
3796NOTE: Table WORK.AC_CC created, with 0 rows and 4 columns.
3797
3798NOTE: PROCEDURE SQL used (Total process time):
3799 real time 0.03 seconds
3800 user cpu time 0.02 seconds
3801 system cpu time 0.02 seconds
3802 memory 20481.59k
3803 OS Memory 209036.00k
3804 Timestamp 24.07.2019 02:32:02 после полудня
3805 Step Count 1992 Switch Count 19
3806 Page Faults 0
3807 Page Reclaims 928
3808 Page Swaps 0
3809 Voluntary Context Switches 26
3810 Involuntary Context Switches 11
3811 Block Input Operations 0
3812 Block Output Operations 0
3813
3814
3815NOTE: {START: fcf_chkrc}
3816NOTE: {END: fcf_chkrc}
3817
3818NOTE: Compression was disabled for data set WORK.AC_C because compression overhead would increase the size of the data set.
3819NOTE: There were 0 observations read from the data set WORK.AC_CC.
3820NOTE: The data set WORK.AC_C has 1 observations and 2 variables.
3821NOTE: PROCEDURE TRANSPOSE used (Total process time):
3822 real time 0.00 seconds
3823 user cpu time 0.01 seconds
3824 The SAS System
3825
3826 system cpu time 0.00 seconds
3827 memory 2573.03k
3828 OS Memory 191316.00k
3829 Timestamp 24.07.2019 02:32:02 после полудня
3830 Step Count 1993 Switch Count 26
3831 Page Faults 0
3832 Page Reclaims 43
3833 Page Swaps 0
3834 Voluntary Context Switches 35
3835 Involuntary Context Switches 3
3836 Block Input Operations 0
3837 Block Output Operations 0
3838
3839
3840
3841NOTE: Compression was disabled for data set WORK.AC_C because compression overhead would increase the size of the data set.
3842NOTE: There were 1 observations read from the data set WORK.AC_C.
3843NOTE: The data set WORK.AC_C has 0 observations and 2 variables.
3844NOTE: DATA statement used (Total process time):
3845 real time 0.00 seconds
3846 user cpu time 0.01 seconds
3847 system cpu time 0.01 seconds
3848 memory 923.18k
3849 OS Memory 189264.00k
3850 Timestamp 24.07.2019 02:32:02 после полудня
3851 Step Count 1994 Switch Count 22
3852 Page Faults 0
3853 Page Reclaims 76
3854 Page Swaps 0
3855 Voluntary Context Switches 39
3856 Involuntary Context Switches 0
3857 Block Input Operations 0
3858 Block Output Operations 0
3859
3860
3861NOTE: Compression was disabled for data set WORK.AC_ALL_CN because compression overhead would increase the size of the data set.
3862NOTE: Table WORK.AC_ALL_CN created, with 0 rows and 2 columns.
3863
3864 The SAS System
3865
3866NOTE: PROCEDURE SQL used (Total process time):
3867 real time 0.00 seconds
3868 user cpu time 0.01 seconds
3869 system cpu time 0.00 seconds
3870 memory 5315.65k
3871 OS Memory 194132.00k
3872 Timestamp 24.07.2019 02:32:02 после полудня
3873 Step Count 1995 Switch Count 24
3874 Page Faults 0
3875 Page Reclaims 9
3876 Page Swaps 0
3877 Voluntary Context Switches 29
3878 Involuntary Context Switches 2
3879 Block Input Operations 0
3880 Block Output Operations 0
3881
3882
3883NOTE: Compression was disabled for data set WORK.AC_ALL because compression overhead would increase the size of the data set.
3884NOTE: Table WORK.AC_ALL created, with 0 rows and 2 columns.
3885
3886NOTE: PROCEDURE SQL used (Total process time):
3887 real time 0.00 seconds
3888 user cpu time 0.00 seconds
3889 system cpu time 0.01 seconds
3890 memory 5314.65k
3891 OS Memory 194132.00k
3892 Timestamp 24.07.2019 02:32:02 после полудня
3893 Step Count 1996 Switch Count 20
3894 Page Faults 0
3895 Page Reclaims 7
3896 Page Swaps 0
3897 Voluntary Context Switches 30
3898 Involuntary Context Switches 0
3899 Block Input Operations 0
3900 Block Output Operations 0
3901
3902
3903NOTE: {START: fcf_chkrc}
3904 The SAS System
3905
3906NOTE: {END: fcf_chkrc}
3907
3908NOTE: There were 1 observations read from the data set WORK.SCR_FULL.
3909 WHERE (scenario_id>0) and (LOGICAL_DELETE_IND not = 'Y') and (CURRENT_IND not = 'N') and scenario_type_code in ('CUS', 'HPS');
3910NOTE: DATA statement used (Total process time):
3911 real time 0.00 seconds
3912 user cpu time 0.01 seconds
3913 system cpu time 0.00 seconds
3914 memory 1290.75k
3915 OS Memory 189524.00k
3916 Timestamp 24.07.2019 02:32:02 после полудня
3917 Step Count 1997 Switch Count 20
3918 Page Faults 0
3919 Page Reclaims 106
3920 Page Swaps 0
3921 Voluntary Context Switches 27
3922 Involuntary Context Switches 2
3923 Block Input Operations 0
3924 Block Output Operations 0
3925
3926
3927
3928NOTE: The infile SCRSRV is:
3929 Filename=http://vm-sasaml01t.tcsbank.ru:7980/SASContentServer/repository/default/sasdav/Products/SASComplianceSolutions/scenarios/scr10170323.sas
3930
3931NOTE: The file "!AMLROOT/scenario/scenario_code_active/TCS_DJ_PARTY_CHG.sas" is:
3932 Filename=/sas/config/Lev1/Applications/SASComplianceSolutions/scenario/scenario_code_active/TCS_DJ_PARTY_CHG.sas,
3933 Owner Name=sassrv,Group Name=sas,
3934 Access Permission=-rw-rw-r--,
3935 Last Modified=24 июля 2019 г. 14:32:03
3936
3937NOTE: 45 records were read from the infile SCRSRV.
3938 The minimum record length was 0.
3939 The maximum record length was 110.
3940NOTE: 45 records were written to the file "!AMLROOT/scenario/scenario_code_active/TCS_DJ_PARTY_CHG.sas".
3941 The minimum record length was 0.
3942 The maximum record length was 110.
3943NOTE: DATA statement used (Total process time):
3944 The SAS System
3945
3946 real time 0.06 seconds
3947 user cpu time 0.02 seconds
3948 system cpu time 0.00 seconds
3949 memory 759.40k
3950 OS Memory 189264.00k
3951 Timestamp 24.07.2019 02:32:03 после полудня
3952 Step Count 1998 Switch Count 50
3953 Page Faults 0
3954 Page Reclaims 95
3955 Page Swaps 0
3956 Voluntary Context Switches 164
3957 Involuntary Context Switches 95
3958 Block Input Operations 0
3959 Block Output Operations 16
3960
3961
3962NOTE: Fileref SCRSRV has been deassigned.
3963
3964NOTE: There were 0 observations read from the data set WORK.HDR_FIX.
3965 WHERE (header_id>0) and (LOGICAL_DELETE_IND not = 'Y') and (HEADER_LOCATION_DESC not = ' ') and (HEADER_AUTOGEN_IND not = 'Y') and SOURCE_TYPE_DESC in ('Custom', 'HP Datastep', 'SAS
3966 Datastep');
3967NOTE: DATA statement used (Total process time):
3968 real time 0.00 seconds
3969 user cpu time 0.01 seconds
3970 system cpu time 0.00 seconds
3971 memory 1280.00k
3972 OS Memory 189524.00k
3973 Timestamp 24.07.2019 02:32:03 после полудня
3974 Step Count 1999 Switch Count 22
3975 Page Faults 0
3976 Page Reclaims 105
3977 Page Swaps 0
3978 Voluntary Context Switches 32
3979 Involuntary Context Switches 28
3980 Block Input Operations 0
3981 Block Output Operations 0
3982
3983
3984 The SAS System
3985
3986samplesize_p= 0
3987NOTE: FCF: FCF_AGP_CODEGEN: Gather scenario performance statistics? N
3988
3989##############################################################################
3990# STARTING SECTION : FCF_CREATE_SCENARIO_MESSAGES #
3991# STARTING DATETIME: 24JUL19:14:32:03 #
3992##############################################################################
3993NOTE: PROCEDURE SQL used (Total process time):
3994 real time 0.00 seconds
3995 user cpu time 0.01 seconds
3996 system cpu time 0.00 seconds
3997 memory 5279.59k
3998 OS Memory 194132.00k
3999 Timestamp 24.07.2019 02:32:03 после полудня
4000 Step Count 2002 Switch Count 15
4001 Page Faults 0
4002 Page Reclaims 93
4003 Page Swaps 0
4004 Voluntary Context Switches 9
4005 Involuntary Context Switches 3
4006 Block Input Operations 0
4007 Block Output Operations 0
4008
4009
4010NOTE: FCF: The data set SEG_KC.FSK_SCENARIO_MESSAGE has 67 observations.
4011NOTE: There were 1 observations read from the data set PARMS.PARMS.
4012 WHERE UPCASE(name)='SCENARIO_MESSAGES';
4013NOTE: DATA statement used (Total process time):
4014 real time 0.01 seconds
4015 user cpu time 0.01 seconds
4016 system cpu time 0.00 seconds
4017 memory 876.03k
4018 OS Memory 189264.00k
4019 Timestamp 24.07.2019 02:32:03 после полудня
4020 Step Count 2003 Switch Count 25
4021 The SAS System
4022
4023 Page Faults 0
4024 Page Reclaims 76
4025 Page Swaps 0
4026 Voluntary Context Switches 33
4027 Involuntary Context Switches 13
4028 Block Input Operations 0
4029 Block Output Operations 0
4030
4031
4032
4033NOTE: DATA statement used (Total process time):
4034 real time 0.00 seconds
4035 user cpu time 0.00 seconds
4036 system cpu time 0.00 seconds
4037 memory 776.31k
4038 OS Memory 189264.00k
4039 Timestamp 24.07.2019 02:32:03 после полудня
4040 Step Count 2004 Switch Count 16
4041 Page Faults 0
4042 Page Reclaims 71
4043 Page Swaps 0
4044 Voluntary Context Switches 10
4045 Involuntary Context Switches 6
4046 Block Input Operations 0
4047 Block Output Operations 0
4048
4049
4050
4051NOTE: Sorting was performed by the data source.
4052NOTE: There were 67 observations read from the data set SEG_KC.FSK_SCENARIO_MESSAGE.
4053NOTE: The data set WORK.SCENARIO_MESSAGES has 67 observations and 2 variables.
4054NOTE: Compressing data set WORK.SCENARIO_MESSAGES increased size by 100.00 percent.
4055 Compressed is 2 pages; un-compressed would require 1 pages.
4056NOTE: PROCEDURE SORT used (Total process time):
4057 real time 0.01 seconds
4058 user cpu time 0.01 seconds
4059 system cpu time 0.01 seconds
4060 memory 3186.31k
4061 The SAS System
4062
4063 OS Memory 191668.00k
4064 Timestamp 24.07.2019 02:32:03 после полудня
4065 Step Count 2005 Switch Count 31
4066 Page Faults 0
4067 Page Reclaims 288
4068 Page Swaps 0
4069 Voluntary Context Switches 65
4070 Involuntary Context Switches 4
4071 Block Input Operations 0
4072 Block Output Operations 0
4073
4074
4075
4076NOTE: The file OUT is:
4077 Filename=/sas/config/Lev1/Applications/SASComplianceSolutions/scenario/codegen/scenario_messages.sas,
4078 Owner Name=sas,Group Name=sas,
4079 Access Permission=-rw-rw-r--,
4080 Last Modified=24 июля 2019 г. 14:32:03
4081
4082NOTE: 147 records were written to the file OUT.
4083 The minimum record length was 0.
4084 The maximum record length was 289.
4085NOTE: There were 67 observations read from the data set WORK.SCENARIO_MESSAGES.
4086NOTE: DATA statement used (Total process time):
4087 real time 0.01 seconds
4088 user cpu time 0.01 seconds
4089 system cpu time 0.00 seconds
4090 memory 952.43k
4091 OS Memory 189264.00k
4092 Timestamp 24.07.2019 02:32:03 после полудня
4093 Step Count 2006 Switch Count 36
4094 Page Faults 0
4095 Page Reclaims 78
4096 Page Swaps 0
4097 Voluntary Context Switches 103
4098 Involuntary Context Switches 0
4099 Block Input Operations 0
4100 Block Output Operations 32
4101 The SAS System
4102
4103
4104
4105
4106##############################################################################
4107# ENDING SECTION : FCF_CREATE_SCENARIO_MESSAGES #
4108# ENDING DATETIME: 24JUL19:14:32:03 #
4109# SECTION DURATION: 0:00:00 #
4110##############################################################################
4111
4112NOTE: There were 6 observations read from the data set PARMS.PARMS.
4113 WHERE UPCASE(name) in ('ALERT_STAGING_LIBNAME', 'ARRAY_SIZE', 'CODEGEN_LOCATION', 'MAX_ENTITY_LENGTH', 'PREP_DATASETS', 'SCENARIO_MESSAGES');
4114NOTE: DATA statement used (Total process time):
4115 real time 0.01 seconds
4116 user cpu time 0.01 seconds
4117 system cpu time 0.00 seconds
4118 memory 876.18k
4119 OS Memory 189264.00k
4120 Timestamp 24.07.2019 02:32:03 после полудня
4121 Step Count 2009 Switch Count 27
4122 Page Faults 0
4123 Page Reclaims 79
4124 Page Swaps 0
4125 Voluntary Context Switches 40
4126 Involuntary Context Switches 0
4127 Block Input Operations 0
4128 Block Output Operations 0
4129
4130
4131
4132NOTE: DATA statement used (Total process time):
4133 real time 0.00 seconds
4134 user cpu time 0.00 seconds
4135 system cpu time 0.00 seconds
4136 memory 780.43k
4137 OS Memory 189264.00k
4138 The SAS System
4139
4140 Timestamp 24.07.2019 02:32:03 после полудня
4141 Step Count 2010 Switch Count 20
4142 Page Faults 0
4143 Page Reclaims 72
4144 Page Swaps 0
4145 Voluntary Context Switches 9
4146 Involuntary Context Switches 1
4147 Block Input Operations 0
4148 Block Output Operations 0
4149
4150
4151NOTE: FCF: FCF_AGP_CODEGEN: Using library WORK for fsk_header
4152NOTE: FCF: FCF_AGP_CODEGEN: Using library WORK for fsk_header_element
4153NOTE: FCF: FCF_AGP_CODEGEN: Using library WORK for fsk_scenario
4154NOTE: FCF: FCF_AGP_CODEGEN: Using library WORK for fsk_scenario_parameter
4155NOTE: FCF: FCF_AGP_CODEGEN: Using library WORK for fsk_scenario_alert_column
4156NOTE: FCF: FCF_AGP_CODEGEN: Using library WORK for fsk_scenario_filter
4157NOTE: FCF: FCF_AGP_CODEGEN: Using library WORK for fsk_scenario_filter_constraint
4158NOTE: FCF: FCF_AGP_CODEGEN: Using library WORK for fsk_scenario_filter_variable
4159NOTE: FCF: FCF_AGP_CODEGEN: Using library WORK for fsk_scenario_alert_constraint
4160NOTE: FCF: FCF_AGP_CODEGEN: Using library WORK for fsk_scenario_message_parameter
4161NOTE: FCF: FCF_AGP_CODEGEN: Using library WORK for fsk_scenario_localized_msg
4162NOTE: Compression was disabled for data set WORK.HEADER_ID because compression overhead would increase the size of the data set.
4163NOTE: Table WORK.HEADER_ID created, with 1 rows and 1 columns.
4164
4165NOTE: PROCEDURE SQL used (Total process time):
4166 real time 0.00 seconds
4167 user cpu time 0.00 seconds
4168 system cpu time 0.00 seconds
4169 memory 5330.25k
4170 OS Memory 194132.00k
4171 Timestamp 24.07.2019 02:32:03 после полудня
4172 Step Count 2011 Switch Count 20
4173 Page Faults 0
4174 Page Reclaims 8
4175 Page Swaps 0
4176 Voluntary Context Switches 24
4177 Involuntary Context Switches 0
4178 The SAS System
4179
4180 Block Input Operations 0
4181 Block Output Operations 0
4182
4183
4184NOTE: PROCEDURE SQL used (Total process time):
4185 real time 0.00 seconds
4186 user cpu time 0.01 seconds
4187 system cpu time 0.00 seconds
4188 memory 5315.93k
4189 OS Memory 194132.00k
4190 Timestamp 24.07.2019 02:32:03 после полудня
4191 Step Count 2012 Switch Count 14
4192 Page Faults 0
4193 Page Reclaims 8
4194 Page Swaps 0
4195 Voluntary Context Switches 0
4196 Involuntary Context Switches 0
4197 Block Input Operations 0
4198 Block Output Operations 0
4199
4200
4201NOTE: PROCEDURE SQL used (Total process time):
4202 real time 0.00 seconds
4203 user cpu time 0.00 seconds
4204 system cpu time 0.00 seconds
4205 memory 5315.56k
4206 OS Memory 194132.00k
4207 Timestamp 24.07.2019 02:32:03 после полудня
4208 Step Count 2013 Switch Count 14
4209 Page Faults 0
4210 Page Reclaims 6
4211 Page Swaps 0
4212 Voluntary Context Switches 0
4213 Involuntary Context Switches 0
4214 Block Input Operations 0
4215 Block Output Operations 0
4216
4217
4218 The SAS System
4219
4220
4221NOTE: Compression was disabled for data set STG_ALER.GENERATED_HEADERS because compression overhead would increase the size of the data set.
4222NOTE: There were 1 observations read from the data set WORK.HEADER_ID.
4223NOTE: The data set STG_ALER.GENERATED_HEADERS has 1 observations and 1 variables.
4224NOTE: DATA statement used (Total process time):
4225 real time 0.00 seconds
4226 user cpu time 0.00 seconds
4227 system cpu time 0.00 seconds
4228 memory 919.90k
4229 OS Memory 189264.00k
4230 Timestamp 24.07.2019 02:32:03 после полудня
4231 Step Count 2014 Switch Count 26
4232 Page Faults 0
4233 Page Reclaims 73
4234 Page Swaps 0
4235 Voluntary Context Switches 49
4236 Involuntary Context Switches 2
4237 Block Input Operations 0
4238 Block Output Operations 144
4239
4240
4241NOTE: PROCEDURE SQL used (Total process time):
4242 real time 0.00 seconds
4243 user cpu time 0.00 seconds
4244 system cpu time 0.00 seconds
4245 memory 5325.00k
4246 OS Memory 194132.00k
4247 Timestamp 24.07.2019 02:32:03 после полудня
4248 Step Count 2015 Switch Count 14
4249 Page Faults 0
4250 Page Reclaims 6
4251 Page Swaps 0
4252 Voluntary Context Switches 0
4253 Involuntary Context Switches 0
4254 Block Input Operations 0
4255 Block Output Operations 0
4256
4257
4258 The SAS System
4259
4260NOTE: PROCEDURE SQL used (Total process time):
4261 real time 0.00 seconds
4262 user cpu time 0.00 seconds
4263 system cpu time 0.00 seconds
4264 memory 5331.65k
4265 OS Memory 194132.00k
4266 Timestamp 24.07.2019 02:32:03 после полудня
4267 Step Count 2016 Switch Count 18
4268 Page Faults 0
4269 Page Reclaims 8
4270 Page Swaps 0
4271 Voluntary Context Switches 0
4272 Involuntary Context Switches 0
4273 Block Input Operations 0
4274 Block Output Operations 0
4275
4276
4277NOTE: The query as specified involves ordering by an item that doesn't appear in its SELECT clause.
4278NOTE: SAS threaded sort was used.
4279NOTE: PROCEDURE SQL used (Total process time):
4280 real time 0.00 seconds
4281 user cpu time 0.00 seconds
4282 system cpu time 0.00 seconds
4283 memory 18895.34k
4284 OS Memory 205660.00k
4285 Timestamp 24.07.2019 02:32:03 после полудня
4286 Step Count 2017 Switch Count 18
4287 Page Faults 0
4288 Page Reclaims 144
4289 Page Swaps 0
4290 Voluntary Context Switches 40
4291 Involuntary Context Switches 3
4292 Block Input Operations 0
4293 Block Output Operations 0
4294
4295
4296NOTE: PROCEDURE SQL used (Total process time):
4297 real time 0.00 seconds
4298 The SAS System
4299
4300 user cpu time 0.00 seconds
4301 system cpu time 0.00 seconds
4302 memory 5331.65k
4303 OS Memory 194132.00k
4304 Timestamp 24.07.2019 02:32:03 после полудня
4305 Step Count 2018 Switch Count 18
4306 Page Faults 0
4307 Page Reclaims 7
4308 Page Swaps 0
4309 Voluntary Context Switches 0
4310 Involuntary Context Switches 0
4311 Block Input Operations 0
4312 Block Output Operations 0
4313
4314
4315NOTE: PROCEDURE SQL used (Total process time):
4316 real time 0.00 seconds
4317 user cpu time 0.00 seconds
4318 system cpu time 0.00 seconds
4319 memory 5321.34k
4320 OS Memory 194132.00k
4321 Timestamp 24.07.2019 02:32:03 после полудня
4322 Step Count 2019 Switch Count 14
4323 Page Faults 0
4324 Page Reclaims 7
4325 Page Swaps 0
4326 Voluntary Context Switches 0
4327 Involuntary Context Switches 1
4328 Block Input Operations 0
4329 Block Output Operations 0
4330
4331
4332NOTE: PROCEDURE SQL used (Total process time):
4333 real time 0.00 seconds
4334 user cpu time 0.00 seconds
4335 system cpu time 0.00 seconds
4336 memory 5318.37k
4337 OS Memory 194132.00k
4338 The SAS System
4339
4340 Timestamp 24.07.2019 02:32:03 после полудня
4341 Step Count 2020 Switch Count 18
4342 Page Faults 0
4343 Page Reclaims 8
4344 Page Swaps 0
4345 Voluntary Context Switches 0
4346 Involuntary Context Switches 0
4347 Block Input Operations 0
4348 Block Output Operations 0
4349
4350
4351NOTE: PROCEDURE SQL used (Total process time):
4352 real time 0.00 seconds
4353 user cpu time 0.00 seconds
4354 system cpu time 0.00 seconds
4355 memory 5321.78k
4356 OS Memory 194132.00k
4357 Timestamp 24.07.2019 02:32:03 после полудня
4358 Step Count 2021 Switch Count 14
4359 Page Faults 0
4360 Page Reclaims 8
4361 Page Swaps 0
4362 Voluntary Context Switches 0
4363 Involuntary Context Switches 0
4364 Block Input Operations 0
4365 Block Output Operations 0
4366
4367
4368NOTE: PROCEDURE SQL used (Total process time):
4369 real time 0.00 seconds
4370 user cpu time 0.00 seconds
4371 system cpu time 0.00 seconds
4372 memory 5320.50k
4373 OS Memory 194132.00k
4374 Timestamp 24.07.2019 02:32:03 после полудня
4375 Step Count 2022 Switch Count 14
4376 Page Faults 0
4377 Page Reclaims 8
4378 The SAS System
4379
4380 Page Swaps 0
4381 Voluntary Context Switches 0
4382 Involuntary Context Switches 0
4383 Block Input Operations 0
4384 Block Output Operations 0
4385
4386
4387
4388NOTE: The file "!AMLROOT/scenario/codegen/TCS_DJ_PARTY_CHG.sas" is:
4389 Filename=/sas/config/Lev1/Applications/SASComplianceSolutions/scenario/codegen/TCS_DJ_PARTY_CHG.sas,
4390 Owner Name=sassrv,Group Name=sas,
4391 Access Permission=-rw-rw-r--,
4392 Last Modified=24 июля 2019 г. 14:32:03
4393
4394NOTE: 18 records were written to the file "!AMLROOT/scenario/codegen/TCS_DJ_PARTY_CHG.sas".
4395 The minimum record length was 0.
4396 The maximum record length was 87.
4397NOTE: DATA statement used (Total process time):
4398 real time 0.00 seconds
4399 user cpu time 0.00 seconds
4400 system cpu time 0.01 seconds
4401 memory 757.96k
4402 OS Memory 189264.00k
4403 Timestamp 24.07.2019 02:32:03 после полудня
4404 Step Count 2023 Switch Count 34
4405 Page Faults 0
4406 Page Reclaims 75
4407 Page Swaps 0
4408 Voluntary Context Switches 82
4409 Involuntary Context Switches 0
4410 Block Input Operations 0
4411 Block Output Operations 16
4412
4413
4414NOTE: PROCEDURE SQL used (Total process time):
4415 real time 0.00 seconds
4416 user cpu time 0.00 seconds
4417 system cpu time 0.00 seconds
4418 The SAS System
4419
4420 memory 5318.56k
4421 OS Memory 194132.00k
4422 Timestamp 24.07.2019 02:32:03 после полудня
4423 Step Count 2024 Switch Count 18
4424 Page Faults 0
4425 Page Reclaims 7
4426 Page Swaps 0
4427 Voluntary Context Switches 0
4428 Involuntary Context Switches 0
4429 Block Input Operations 0
4430 Block Output Operations 0
4431
4432
4433NOTE: PROCEDURE SQL used (Total process time):
4434 real time 0.00 seconds
4435 user cpu time 0.00 seconds
4436 system cpu time 0.00 seconds
4437 memory 5319.09k
4438 OS Memory 194132.00k
4439 Timestamp 24.07.2019 02:32:03 после полудня
4440 Step Count 2025 Switch Count 14
4441 Page Faults 0
4442 Page Reclaims 5
4443 Page Swaps 0
4444 Voluntary Context Switches 0
4445 Involuntary Context Switches 0
4446 Block Input Operations 0
4447 Block Output Operations 0
4448
4449
4450
4451NOTE: The file "!AMLROOT/scenario/codegen/TCS_DJ_PARTY_CHG.sas" is:
4452 Filename=/sas/config/Lev1/Applications/SASComplianceSolutions/scenario/codegen/TCS_DJ_PARTY_CHG.sas,
4453 Owner Name=sassrv,Group Name=sas,
4454 Access Permission=-rw-rw-r--,
4455 Last Modified=24 июля 2019 г. 14:32:03,
4456 File Size (bytes)=408
4457
4458 The SAS System
4459
4460NOTE: 47 records were written to the file "!AMLROOT/scenario/codegen/TCS_DJ_PARTY_CHG.sas".
4461 The minimum record length was 0.
4462 The maximum record length was 86.
4463NOTE: DATA statement used (Total process time):
4464 real time 0.01 seconds
4465 user cpu time 0.01 seconds
4466 system cpu time 0.00 seconds
4467 memory 759.71k
4468 OS Memory 189264.00k
4469 Timestamp 24.07.2019 02:32:03 после полудня
4470 Step Count 2026 Switch Count 40
4471 Page Faults 0
4472 Page Reclaims 75
4473 Page Swaps 0
4474 Voluntary Context Switches 112
4475 Involuntary Context Switches 0
4476 Block Input Operations 0
4477 Block Output Operations 8
4478
4479
4480
4481NOTE: The file "!AMLROOT/scenario/codegen/TCS_DJ_PARTY_CHG.sas" is:
4482 Filename=/sas/config/Lev1/Applications/SASComplianceSolutions/scenario/codegen/TCS_DJ_PARTY_CHG.sas,
4483 Owner Name=sassrv,Group Name=sas,
4484 Access Permission=-rw-rw-r--,
4485 Last Modified=24 июля 2019 г. 14:32:03,
4486 File Size (bytes)=1754
4487
4488NOTE: 0 records were written to the file "!AMLROOT/scenario/codegen/TCS_DJ_PARTY_CHG.sas".
4489NOTE: DATA statement used (Total process time):
4490 real time 0.00 seconds
4491 user cpu time 0.00 seconds
4492 system cpu time 0.01 seconds
4493 memory 753.59k
4494 OS Memory 189264.00k
4495 Timestamp 24.07.2019 02:32:03 после полудня
4496 Step Count 2027 Switch Count 32
4497 Page Faults 0
4498 The SAS System
4499
4500 Page Reclaims 76
4501 Page Swaps 0
4502 Voluntary Context Switches 78
4503 Involuntary Context Switches 0
4504 Block Input Operations 0
4505 Block Output Operations 0
4506
4507
4508NOTE: {START: fcf_chkrc}
4509NOTE: {END: fcf_chkrc}
4510
4511NOTE: The file HDR_LST is:
4512 Filename=/dev/shm/SAS_workE57800002A39_vm-sasaml01t/#LN01725,
4513 Owner Name=sassrv,Group Name=sas,
4514 Access Permission=-rw-rw-r--,
4515 Last Modified=24 июля 2019 г. 14:32:03
4516
4517NOTE: 2 records were written to the file HDR_LST.
4518 The minimum record length was 54.
4519 The maximum record length was 55.
4520NOTE: There were 1 observations read from the data set WORK.FSK_HEADER.
4521NOTE: DATA statement used (Total process time):
4522 real time 0.00 seconds
4523 user cpu time 0.01 seconds
4524 system cpu time 0.00 seconds
4525 memory 959.81k
4526 OS Memory 189264.00k
4527 Timestamp 24.07.2019 02:32:03 после полудня
4528 Step Count 2028 Switch Count 36
4529 Page Faults 0
4530 Page Reclaims 74
4531 Page Swaps 0
4532 Voluntary Context Switches 90
4533 Involuntary Context Switches 0
4534 Block Input Operations 0
4535 Block Output Operations 0
4536
4537
4538 The SAS System
4539
4540
4541NOTE: The file WORK.HDR_CT (memtype=DATA) was not found, but appears on a DELETE statement.
4542NOTE: The file WORK.HDR_DT (memtype=DATA) was not found, but appears on a DELETE statement.
4543NOTE: The file WORK.HDR_NT (memtype=DATA) was not found, but appears on a DELETE statement.
4544NOTE: The file WORK.RG_CT (memtype=DATA) was not found, but appears on a DELETE statement.
4545NOTE: The file WORK.SCR_CT (memtype=DATA) was not found, but appears on a DELETE statement.
4546NOTE: The file WORK.SCR_DT (memtype=DATA) was not found, but appears on a DELETE statement.
4547NOTE: The file WORK.SCR_NT (memtype=DATA) was not found, but appears on a DELETE statement.
4548NOTE: The file WORK.SCR_FIX (memtype=DATA) was not found, but appears on a DELETE statement.
4549NOTE: The file WORK.COL_CT (memtype=DATA) was not found, but appears on a DELETE statement.
4550NOTE: The file WORK.SP_CT (memtype=DATA) was not found, but appears on a DELETE statement.
4551NOTE: The file WORK.SP_FULL (memtype=DATA) was not found, but appears on a DELETE statement.
4552NOTE: The file WORK.RR_ALL (memtype=DATA) was not found, but appears on a DELETE statement.
4553NOTE: The file WORK.RR_ALL_CN (memtype=DATA) was not found, but appears on a DELETE statement.
4554NOTE: The file WORK.RR_C (memtype=DATA) was not found, but appears on a DELETE statement.
4555NOTE: The file WORK.RR_CC (memtype=DATA) was not found, but appears on a DELETE statement.
4556NOTE: The file WORK.RR_CT (memtype=DATA) was not found, but appears on a DELETE statement.
4557NOTE: The file WORK.RR_N (memtype=DATA) was not found, but appears on a DELETE statement.
4558NOTE: The file WORK.RR_NC (memtype=DATA) was not found, but appears on a DELETE statement.
4559NOTE: The file WORK.RR_NT (memtype=DATA) was not found, but appears on a DELETE statement.
4560NOTE: The file WORK.RR_FULL (memtype=DATA) was not found, but appears on a DELETE statement.
4561NOTE: The file WORK.RC_ALL (memtype=DATA) was not found, but appears on a DELETE statement.
4562NOTE: The file WORK.RC_ALL_CN (memtype=DATA) was not found, but appears on a DELETE statement.
4563NOTE: The file WORK.RC_C (memtype=DATA) was not found, but appears on a DELETE statement.
4564NOTE: The file WORK.RC_CC (memtype=DATA) was not found, but appears on a DELETE statement.
4565NOTE: The file WORK.RC_CT (memtype=DATA) was not found, but appears on a DELETE statement.
4566NOTE: The file WORK.RC_N (memtype=DATA) was not found, but appears on a DELETE statement.
4567NOTE: The file WORK.RC_NC (memtype=DATA) was not found, but appears on a DELETE statement.
4568NOTE: The file WORK.RC_NT (memtype=DATA) was not found, but appears on a DELETE statement.
4569NOTE: The file WORK.RC_FIX (memtype=DATA) was not found, but appears on a DELETE statement.
4570NOTE: The file WORK.RC_FULL (memtype=DATA) was not found, but appears on a DELETE statement.
4571NOTE: The file WORK.AC_CT (memtype=DATA) was not found, but appears on a DELETE statement.
4572NOTE: The file WORK.AC_N (memtype=DATA) was not found, but appears on a DELETE statement.
4573NOTE: The file WORK.AC_NC (memtype=DATA) was not found, but appears on a DELETE statement.
4574NOTE: The file WORK.AC_NT (memtype=DATA) was not found, but appears on a DELETE statement.
4575NOTE: The file WORK.AC_FULL (memtype=DATA) was not found, but appears on a DELETE statement.
4576NOTE: The file WORK.SF_ALL (memtype=DATA) was not found, but appears on a DELETE statement.
4577NOTE: The file WORK.SF_ALL_CN (memtype=DATA) was not found, but appears on a DELETE statement.
4578 The SAS System
4579
4580NOTE: The file WORK.SF_C (memtype=DATA) was not found, but appears on a DELETE statement.
4581NOTE: The file WORK.SF_CC (memtype=DATA) was not found, but appears on a DELETE statement.
4582NOTE: The file WORK.SF_CT (memtype=DATA) was not found, but appears on a DELETE statement.
4583NOTE: The file WORK.SF_N (memtype=DATA) was not found, but appears on a DELETE statement.
4584NOTE: The file WORK.SF_NC (memtype=DATA) was not found, but appears on a DELETE statement.
4585NOTE: The file WORK.SF_NT (memtype=DATA) was not found, but appears on a DELETE statement.
4586NOTE: The file WORK.SF_FULL (memtype=DATA) was not found, but appears on a DELETE statement.
4587NOTE: The file WORK.FV_ALL (memtype=DATA) was not found, but appears on a DELETE statement.
4588NOTE: The file WORK.FV_ALL_CN (memtype=DATA) was not found, but appears on a DELETE statement.
4589NOTE: The file WORK.FV_C (memtype=DATA) was not found, but appears on a DELETE statement.
4590NOTE: The file WORK.FV_CC (memtype=DATA) was not found, but appears on a DELETE statement.
4591NOTE: The file WORK.FV_CT (memtype=DATA) was not found, but appears on a DELETE statement.
4592NOTE: The file WORK.FV_FULL (memtype=DATA) was not found, but appears on a DELETE statement.
4593NOTE: The file WORK.FV_FIX (memtype=DATA) was not found, but appears on a DELETE statement.
4594NOTE: The file WORK.FC_ALL (memtype=DATA) was not found, but appears on a DELETE statement.
4595NOTE: The file WORK.FC_ALL_CN (memtype=DATA) was not found, but appears on a DELETE statement.
4596NOTE: The file WORK.FC_C (memtype=DATA) was not found, but appears on a DELETE statement.
4597NOTE: The file WORK.FC_CC (memtype=DATA) was not found, but appears on a DELETE statement.
4598NOTE: The file WORK.FC_CT (memtype=DATA) was not found, but appears on a DELETE statement.
4599NOTE: The file WORK.FC_N (memtype=DATA) was not found, but appears on a DELETE statement.
4600NOTE: The file WORK.FC_NC (memtype=DATA) was not found, but appears on a DELETE statement.
4601NOTE: The file WORK.FC_NT (memtype=DATA) was not found, but appears on a DELETE statement.
4602NOTE: The file WORK.FC_FULL (memtype=DATA) was not found, but appears on a DELETE statement.
4603NOTE: The file WORK.FC_FIX (memtype=DATA) was not found, but appears on a DELETE statement.
4604NOTE: The file WORK.ARC_ALL (memtype=DATA) was not found, but appears on a DELETE statement.
4605NOTE: The file WORK.ARC_ALL_CN (memtype=DATA) was not found, but appears on a DELETE statement.
4606NOTE: The file WORK.ARC_C (memtype=DATA) was not found, but appears on a DELETE statement.
4607NOTE: The file WORK.ARC_CC (memtype=DATA) was not found, but appears on a DELETE statement.
4608NOTE: The file WORK.ARC_CT (memtype=DATA) was not found, but appears on a DELETE statement.
4609NOTE: The file WORK.ARC_N (memtype=DATA) was not found, but appears on a DELETE statement.
4610NOTE: The file WORK.ARC_NC (memtype=DATA) was not found, but appears on a DELETE statement.
4611NOTE: The file WORK.ARC_NT (memtype=DATA) was not found, but appears on a DELETE statement.
4612NOTE: The file WORK.ARC_FULL (memtype=DATA) was not found, but appears on a DELETE statement.
4613NOTE: The file WORK.ARC_FIX (memtype=DATA) was not found, but appears on a DELETE statement.
4614NOTE: The file WORK.LM_ALL (memtype=DATA) was not found, but appears on a DELETE statement.
4615NOTE: The file WORK.LM_ALL_CN (memtype=DATA) was not found, but appears on a DELETE statement.
4616NOTE: The file WORK.LM_C (memtype=DATA) was not found, but appears on a DELETE statement.
4617NOTE: The file WORK.LM_CC (memtype=DATA) was not found, but appears on a DELETE statement.
4618 The SAS System
4619
4620NOTE: The file WORK.LM_CT (memtype=DATA) was not found, but appears on a DELETE statement.
4621NOTE: The file WORK.LM_N (memtype=DATA) was not found, but appears on a DELETE statement.
4622NOTE: The file WORK.LM_NC (memtype=DATA) was not found, but appears on a DELETE statement.
4623NOTE: The file WORK.LM_NT (memtype=DATA) was not found, but appears on a DELETE statement.
4624NOTE: The file WORK.LM_FULL (memtype=DATA) was not found, but appears on a DELETE statement.
4625NOTE: The file WORK.LMP_ALL (memtype=DATA) was not found, but appears on a DELETE statement.
4626NOTE: The file WORK.LMP_ALL_CN (memtype=DATA) was not found, but appears on a DELETE statement.
4627NOTE: The file WORK.LMP_C (memtype=DATA) was not found, but appears on a DELETE statement.
4628NOTE: The file WORK.LMP_CC (memtype=DATA) was not found, but appears on a DELETE statement.
4629NOTE: The file WORK.LMP_CT (memtype=DATA) was not found, but appears on a DELETE statement.
4630NOTE: The file WORK.LMP_N (memtype=DATA) was not found, but appears on a DELETE statement.
4631NOTE: The file WORK.LMP_NC (memtype=DATA) was not found, but appears on a DELETE statement.
4632NOTE: The file WORK.LMP_NT (memtype=DATA) was not found, but appears on a DELETE statement.
4633NOTE: The file WORK.LMP_FULL (memtype=DATA) was not found, but appears on a DELETE statement.
4634NOTE: Deleting WORK.HDR_ALL (memtype=DATA).
4635NOTE: Deleting WORK.HDR_ALL_CN (memtype=DATA).
4636NOTE: Deleting WORK.HDR_C (memtype=DATA).
4637NOTE: Deleting WORK.HDR_CC (memtype=DATA).
4638NOTE: Deleting WORK.HDR_D (memtype=DATA).
4639NOTE: Deleting WORK.HDR_DC (memtype=DATA).
4640NOTE: Deleting WORK.HDR_N (memtype=DATA).
4641NOTE: Deleting WORK.HDR_NC (memtype=DATA).
4642NOTE: Deleting WORK.HDR_FIX (memtype=DATA).
4643NOTE: Deleting WORK.HDR_FIX1 (memtype=DATA).
4644NOTE: Deleting WORK.RG_ALL (memtype=DATA).
4645NOTE: Deleting WORK.RG_ALL_CN (memtype=DATA).
4646NOTE: Deleting WORK.RG_C (memtype=DATA).
4647NOTE: Deleting WORK.RG_CC (memtype=DATA).
4648NOTE: Deleting WORK.RG_FIX (memtype=DATA).
4649NOTE: Deleting WORK.SCR_ALL (memtype=DATA).
4650NOTE: Deleting WORK.SCR_ALL_CN (memtype=DATA).
4651NOTE: Deleting WORK.SCR_C (memtype=DATA).
4652NOTE: Deleting WORK.SCR_CC (memtype=DATA).
4653NOTE: Deleting WORK.SCR_D (memtype=DATA).
4654NOTE: Deleting WORK.SCR_DC (memtype=DATA).
4655NOTE: Deleting WORK.SCR_FIX (memtype=DATA).
4656NOTE: Deleting WORK.SCR_N (memtype=DATA).
4657NOTE: Deleting WORK.SCR_NC (memtype=DATA).
4658 The SAS System
4659
4660NOTE: Deleting WORK.SCR_FIX1 (memtype=DATA).
4661NOTE: Deleting WORK.SCR_FULL (memtype=DATA).
4662NOTE: Deleting WORK.COL_ALL (memtype=DATA).
4663NOTE: Deleting WORK.COL_ALL_CN (memtype=DATA).
4664NOTE: Deleting WORK.COL_C (memtype=DATA).
4665NOTE: Deleting WORK.COL_CC (memtype=DATA).
4666NOTE: Deleting WORK.COL_FIX (memtype=DATA).
4667NOTE: Deleting WORK.COL_FULL (memtype=DATA).
4668NOTE: Deleting WORK.DATASET_LIST (memtype=DATA).
4669NOTE: Deleting WORK.ELEMENTS (memtype=DATA).
4670NOTE: Deleting WORK.SP_ALL (memtype=DATA).
4671NOTE: Deleting WORK.SP_ALL_CN (memtype=DATA).
4672NOTE: Deleting WORK.SP_C (memtype=DATA).
4673NOTE: Deleting WORK.SP_CC (memtype=DATA).
4674NOTE: Deleting WORK.AC_ALL (memtype=DATA).
4675NOTE: Deleting WORK.AC_ALL_CN (memtype=DATA).
4676NOTE: Deleting WORK.AC_C (memtype=DATA).
4677NOTE: Deleting WORK.AC_CC (memtype=DATA).
4678NOTE: Deleting WORK.HDRXSCR (memtype=DATA).
4679NOTE: Deleting WORK.SCRXRG (memtype=DATA).
4680GBC Injection start: rebuild prep
4681
4682NOTE: PROCEDURE DATASETS used (Total process time):
4683 real time 0.05 seconds
4684 user cpu time 0.03 seconds
4685 system cpu time 0.02 seconds
4686 memory 330.18k
4687 OS Memory 189008.00k
4688 Timestamp 24.07.2019 02:32:03 после полудня
4689 Step Count 2029 Switch Count 302
4690 Page Faults 0
4691 Page Reclaims 3
4692 Page Swaps 0
4693 Voluntary Context Switches 1268
4694 Involuntary Context Switches 4
4695 Block Input Operations 0
4696 Block Output Operations 0
4697
4698 The SAS System
4699
4700
4701
4702NOTE: There were 0 observations read from the data set WORK.FSK_SCENARIO_PARAMETER.
4703NOTE: DATA statement used (Total process time):
4704 real time 0.00 seconds
4705 user cpu time 0.00 seconds
4706 system cpu time 0.01 seconds
4707 memory 917.59k
4708 OS Memory 189264.00k
4709 Timestamp 24.07.2019 02:32:03 после полудня
4710 Step Count 2030 Switch Count 18
4711 Page Faults 0
4712 Page Reclaims 71
4713 Page Swaps 0
4714 Voluntary Context Switches 19
4715 Involuntary Context Switches 1
4716 Block Input Operations 0
4717 Block Output Operations 0
4718
4719
4720NOTE: PROCEDURE SQL used (Total process time):
4721 real time 0.00 seconds
4722 user cpu time 0.00 seconds
4723 system cpu time 0.00 seconds
4724 memory 5512.50k
4725 OS Memory 194132.00k
4726 Timestamp 24.07.2019 02:32:03 после полудня
4727 Step Count 2031 Switch Count 14
4728 Page Faults 0
4729 Page Reclaims 16
4730 Page Swaps 0
4731 Voluntary Context Switches 0
4732 Involuntary Context Switches 0
4733 Block Input Operations 0
4734 Block Output Operations 0
4735
4736
4737NOTE: A byte-order mark in the file "/sas/config/Lev1/Applications/SASComplianceSolutions/custom/source/prep_files/tcs_dj_party_chg.sas" (for fileref "#LN01726") indicates that the data is
4738 The SAS System
4739
4740 encoded in "utf-8". This encoding will be used to process the file.
4741NOTE: %INCLUDE (level 2) file !FCFROOT/custom/source/prep_files/tcs_dj_party_chg.sas is file /sas/config/Lev1/Applications/SASComplianceSolutions/custom/source/prep_files/tcs_dj_party_chg.sas.
47421498 +/*==============================================================================
47431499 +| PREP-файл сценария DJ по клиентам
47441500 +| NAME: tcs_dj_party_chg.sas
47451501 +| PRODUCT: SAS Compliance Solutions
47461502 +| SYSTEM: UNIX/WINDOWS
47471503 +================================================================================
47481504 +
47491505 +Описание препа
47501506 +---------------------
47511507 +Создает файл данных для сценария по выявлению клиентов-санкционников, которые изменили
47521508 +данные о себе
47531509 +
47541510 +
47551511 +Выходные данные
47561512 +----------------------------
47571513 +MST_PREP.TCS_DJ_PARTY_CHG
47581514 +
47591515 +Направление сортировки
47601516 +----------------------------
47611517 +| Data Set Field Sort Order
47621518 +|----------------------------|-------------------------------|--------------
47631519 +|TCS_DJ_PARTY_CHG |PARTY_NUMBER |1
47641520 +
47651521 +================================================================================
47661522 +Используется в сценариях:
47671523 +
47681524 +- TCS_DJ_PARTY_CHG
47691525 +==============================================================================*/
47701526 +
47711527 +/*-------------------------------------------------------------------
47721528 + * Nikita Ryabov, 26.06.2019
47731529 + * SAS Institute Inc.
47741530 + *-------------------------------------------------------------------
47751531 + * Valeriy Aleksashkin, 27.06.2019
47761532 + * GlowByte Consulting
47771533 + *-------------------------------------------------------------------*/
4778 The SAS System
4779
47801534 +
47811535 +/************ DEBUG VARIABLES ****************/
47821536 +/*options mprint mprintnest mlogic mlogicnest symbolgen;*/
47831537 +/*%let runasofdate = 20190531;*/
47841538 +
47851539 +/*********************************************/
47861540 +
47871541 +
47881542 +%macro mPrepSncPartyChgOffline;
47891543 + %macro dummy; %mend dummy;
47901544 + /* Формирование вспомогательных переменных */
47911545 + %local mvOraRunAsOfDate; %let mvOraRunAsOfDate = to_date(%tslit(&runasofdate.), 'YYYYMMDD');
47921546 + %local mvOraFromDate;
47931547 + /* Пропустим предыдущие выходные */
47941548 + %local mvScenarioDepth; %let mvScenarioDepth = 1;
47951549 + /* Зададимся фиктивным значением для третьего параметра mGetFirstBusinessDay в 21 день, чтобы не выкинуть выходные случайно */
47961550 + %local mvProbingDepth; %let mvProbingDepth = 21;
47971551 + /* Найдем глубину просмотра */
47981552 + %let mvOraFromDate = %mGetFirstBusinessDay(&runAsOfDate., &mvScenarioDepth., &mvProbingDepth.);
47991553 + %let mvOraFromDate = to_date(%tslit(&mvOraFromDate.), 'YYYYMMDD');
48001554 +
48011555 + proc sql noprint;
48021556 + connect using FCFCORE as ora;
48031557 +
48041558 + create table mst_prep.tcs_dj_party_chg as
48051559 + select
48061560 + *
48071561 + from connection to ora (
48081562 + SELECT
48091563 + old.PARTY_NUMBER
48101564 + ,old.party_first_name as old_party_first_name
48111565 + ,old.party_last_name as old_party_last_name
48121566 + ,old.party_middle_name as old_party_middle_name
48131567 + ,old.party_name as old_party_name
48141568 + ,old.party_date_of_birth as old_party_date_of_birth
48151569 + ,old.party_tax_id as old_party_tax_id
48161570 + ,old.rus_reg_num as old_rus_reg_num
48171571 + ,new.party_type_desc as party_type_desc
4818 The SAS System
4819
48201572 + ,new.party_first_name as new_party_first_name
48211573 + ,new.party_last_name as new_party_last_name
48221574 + ,new.party_middle_name as new_party_middle_name
48231575 + ,new.party_name as new_party_name
48241576 + ,new.party_date_of_birth as new_party_date_of_birth
48251577 + ,new.party_tax_id as new_party_tax_id
48261578 + ,new.rus_reg_num as new_rus_reg_num
48271579 + /* Берем текущую и предыдущую записи */
48281580 + FROM FCFCORE.FSC_PARTY_DIM old
48291581 + INNER JOIN FCFCORE.FSC_PARTY_DIM new ON (
48301582 + old.PARTY_NUMBER = new.PARTY_NUMBER
48311583 + /* Записи встык */
48321584 + AND old.CHANGE_END_DATE + (1 / (24 * 3600)) = new.CHANGE_BEGIN_DATE
48331585 + AND old.CHANGE_CURRENT_IND = 'N' AND new.CHANGE_CURRENT_IND = 'Y'
48341586 + )
48351587 + /* Из них всех оставлям только санкционников */
48361588 + INNER JOIN CASEMGMT.PARTY_LIVE pl ON (
48371589 + pl.PARTY_ID = 'PTY-' || old.PARTY_NUMBER
48381590 + AND pl.SOURCE_SYSTEM_CD = 'FCFBU1'
48391591 + )
48401592 + INNER JOIN CASEMGMT.PARTY_UDF_CHAR_VALUE sncFlg ON (
48411593 + sncFlg.PARTY_RK = pl.PARTY_RK
48421594 + AND sncFlg.VALID_FROM_DTTM = pl.VALID_FROM_DTTM
48431595 + AND sncFlg.UDF_TABLE_NM = 'PARTY'
48441596 + AND sncFlg.UDF_NM = 'GB_SNC_UNDER_SANCTIONS_FLG'
48451597 + AND sncFlg.ROW_NO = 1
48461598 + )
48471599 + WHERE
48481600 + sncFlg.UDF_VALUE = '1'
48491601 + AND &mvOraFromDate. <= new.CHANGE_BEGIN_DATE
48501602 + AND new.CHANGE_BEGIN_DATE < &mvOraRunAsOfDate.
48511603 + );
48521604 +
48531605 + disconnect from ora;
48541606 + quit;
48551607 +
48561608 + PROC SORT OVERWRITE DATA = mst_prep.tcs_dj_party_chg;
48571609 + BY party_number;
4858 The SAS System
4859
48601610 + RUN;
48611611 +%mend mPrepSncPartyChgOffline;
48621612 +
48631613 +%mPrepSncPartyChgOffline;
4864NOTE: Table MST_PREP.TCS_DJ_PARTY_CHG created, with 0 rows and 16 columns.
4865
4866NOTE: PROCEDURE SQL used (Total process time):
4867 real time 30.23 seconds
4868 user cpu time 0.01 seconds
4869 system cpu time 0.01 seconds
4870 memory 5384.00k
4871 OS Memory 194648.00k
4872 Timestamp 24.07.2019 02:32:33 после полудня
4873 Step Count 2032 Switch Count 19
4874 Page Faults 0
4875 Page Reclaims 273
4876 Page Swaps 0
4877 Voluntary Context Switches 43
4878 Involuntary Context Switches 13
4879 Block Input Operations 0
4880 Block Output Operations 272
4881
4882
4883
4884NOTE: Input data set is empty.
4885NOTE: The data set MST_PREP.TCS_DJ_PARTY_CHG has 0 observations and 16 variables.
4886NOTE: PROCEDURE SORT used (Total process time):
4887 real time 0.00 seconds
4888 user cpu time 0.00 seconds
4889 system cpu time 0.00 seconds
4890 memory 448.40k
4891 OS Memory 189524.00k
4892 Timestamp 24.07.2019 02:32:33 после полудня
4893 Step Count 2033 Switch Count 20
4894 Page Faults 0
4895 Page Reclaims 6
4896 Page Swaps 0
4897 Voluntary Context Switches 29
4898 The SAS System
4899
4900 Involuntary Context Switches 1
4901 Block Input Operations 0
4902 Block Output Operations 272
4903
4904
4905NOTE: %INCLUDE (level 2) ending.
4906NOTE: %INCLUDE (level 1) resuming.
4907GBC Injection end
4908NOTE: %INCLUDE (level 2) file HDR_LST is file /dev/shm/SAS_workE57800002A39_vm-sasaml01t/#LN01725.
49091614 +%inc '!AMLROOT/scenario/codegen/TCS_DJ_PARTY_CHG.sas';
4910NOTE: %INCLUDE (level 3) file !AMLROOT/scenario/codegen/TCS_DJ_PARTY_CHG.sas is file /sas/config/Lev1/Applications/SASComplianceSolutions/scenario/codegen/TCS_DJ_PARTY_CHG.sas.
49111615 +/*------*/
49121616 +/* Test */
49131617 +/*------*/
49141618 +%let runasofdate = 20190701;
49151619 +
49161620 +%let header_id = 10170321;
49171621 +
49181622 +/* Set error code to 0 */
49191623 +%let trans_rc = 0;
49201624 +
49211625 +/* Include Scenario Messages */
49221626 +filename scenMsgs "!AMLROOT/scenario/codegen/scenario_messages.sas" encoding='windows';
49231627 +%include scenMsgs;
4924NOTE: %INCLUDE (level 4) file SCENMSGS is file /sas/config/Lev1/Applications/SASComplianceSolutions/scenario/codegen/scenario_messages.sas.
49251628 +/*==============================================================================
49261629 +| NAME: scenario_messages.sas
49271630 +| PRODUCT: SAS Compliance Solutions
49281631 +| SYSTEM: UNIX/WINDOWS
49291632 +|
49301633 +| PURPOSE: System generated file used to initialize macro variable instances for
49311634 +| all scenario messages. Resolved scenario messages are placed in
49321635 +| FSK_ALERT.actual_values_text.
49331636 +|
49341637 +| CREATED:24 июля 2019 г. 14:32:03
49351638 +===============================================================================*/
49361639 +
49371640 +
4938 The SAS System
4939
49401641 +%let snc_party_offline=%str("Клиент #party_name #criteria указан в списках #wl_list как #entity_name");
49411642 +
49421643 +%let snc_party_offline_bdt=%str("г.р.");
49431644 +
49441645 +%let snc_party_offline_del=%str("Клиент #party_name удален из всех санкционных списков");
49451646 +
49461647 +%let snc_party_offline_doc=%str("док №");
49471648 +
49481649 +%let snc_party_offline_inn=%str("ИНН");
49491650 +
49501651 +%let tcs_fatca=%str("У клиента #party_name выявлены следующие FATCA-признаки:");
49511652 +
49521653 +%let tcs_fatca_r1=%str("(Rule_1) Гражданство США");
49531654 +
49541655 +%let tcs_fatca_r2=%str("(Rule_2) Место рождения США");
49551656 +
49561657 +%let tcs_fatca_r3=%str("(Rule_3) Регистрация США");
49571658 +
49581659 +%let tcs_fatca_r4=%str("(Rule_4) Телефонный номер США");
49591660 +
49601661 +%let tcs_fatca_r5=%str("(Rule_5) Резидент США");
49611662 +
49621663 +%let tcs_fatca_r6=%str("(Rule_6) Адрес местонахождения США");
49631664 +
49641665 +%let tcs_fatca_r7=%str("(Rule_7) Почтовый адрес США");
49651666 +
49661667 +%let tcs_fatca_r8=%str("(Rule_8) Бенефициары США");
49671668 +
49681669 +%let tcs_fatca_r9=%str("(Rule_9) Вид на жительство США");
49691670 +
49701671 +%let tcs_rf_1=%str("Сценарий RF_1: #party_name находится в черном списке ЦБ.");
49711672 +
49721673 +%let tcs_rf_2=%str("Сценарий RF_2: #party_name находится в черном списке Банка.");
49731674 +
49741675 +%let tcs_rf_3=%str("Сценарий RF_3: #party_name находится в списке “Завирусованность”.");
49751676 +
49761677 +%let tcs_rf_4=%str("Сценарий RF_4: #party_name находится в списке 550-П.");
49771678 +
4978 The SAS System
4979
49801679 +%let tcs_rf_5=%str("Сценарий RF_5: #party_name находится в перечне экстремистов и террористов.");
49811680 +
49821681 +%let tcs1001=%str("Сценарий 1001: Снятие юридическим лицом наличных средств; сумма транзакции #currency_amount; клиент #party_name; ИНН #party_tax_id; назначение операции
49831681 !+#transaction_description_desc; код ОКВЭД #industry_text");
49841682 +
49851683 +%let tcs1002=%str("Сценарий 1002: Пополнение юридическим лицом счета наличными средствами; сумма транзакции #currency_amount, клиент #party_name; ИНН #party_tax_id; назначение операции
49861683 !+ #transaction_description; код ОКВЭД #industry_text.");
49871684 +
49881685 +%let tcs1008=%str("Сценарий 1008: Внесение физическим лицом наличных средств в уставный капитал организации; сумма транзакции #currency_amount; клиент ЮЛ #party_name; ИНН
49891685 !+#party_tax_id");
49901686 +
49911687 +%let tcs13=%str("Сценарий №13: Выявлены переводы клиента на счет нерезидента; Клиент #party_name, счет Клиента #account_number");
49921688 +
49931689 +%let tcs15=%str("Сценарий №15: Выявлена оплата клиентом неустойки на счет нерезидента; Клиент #party_name, счет Клиента #account_number");
49941690 +
49951691 +%let tcs18=%str("Сценарий №18: #date_key со счета клиента #account_number осуществлен перевод д.с. контрагенту #party_name на сумму #debit_amount #currency.");
49961692 +
49971693 +%let tcs19=%str("Сценарий №19: #date_key на счет клиента #account_number поступили д.с. от контрагента #party_name на сумму #credit_amount #currency.");
49981694 +
49991695 +%let tcs20=%str("Сценарий №20: #date_key со счета клиента – #remit_partner_name - #account_number осуществлен перевод д.с. на сумму #debit_credit_amount #currency в пользу
50001695 !+#benef_partner_name . В адрес банка нерезидента, в котором открыт счет нерезидента: #bank_swift_number #bank_name");
50011696 +
50021697 +%let tcs21=%str("Сценарий №21: #date_key со счета клиента – #party_name #account_number осуществлен перевод д.с. на сумму #debit_amount #currency. в пользу #partner_name с назначением
50031697 !+платежа: #transaction_description.");
50041698 +
50051699 +%let tcs22=%str("Сценарий №22: #date_key со счета клиента – #party_name #account_number осуществлен перевод д.с. на сумму #debit_amount руб. в пользу #partner_name с назначением
50061699 !+платежа: #transaction_description.");
50071700 +
50081701 +%let tcs23=%str("Сценарий №23: #date_key со счета клиента – #party_name #account_number осуществлены переводы д.с. с назначением платежа: #transaction_description.");
50091702 +
50101703 +%let tcs24=%str("Сценарий №24: #date_key со счета #remit_partner_name осуществлен перевод д.с. на сумму #debit_credit_amount #currency в пользу #benef_partner_name. Счет клиента –
50111703 !+#account_number");
50121704 +
50131705 +%let tcs25=%str("Сценарий №25: #date_key со счета клиента – #party_name #account_number осуществлено #cnt переводов д.с. с назначением платежа: #transaction_description.");
50141706 +
50151707 +%let tcs26=%str("Сценарий №26: #date_key со счета #remit_partner_name осуществлен перевод д.с. на сумму #debit_credit_amount #currency в пользу #benef_partner_name. Счет клиента –
50161707 !+#account_number");
50171708 +
5018 The SAS System
5019
50201709 +%let tcs27=%str("Сценарий №27: #date_key со счета #remit_partner_name осуществлен перевод д.с. на сумму #debit_credit_amount #currency в пользу #benef_partner_name. Счет клиента –
50211709 !+#account_number");
50221710 +
50231711 +%let tcs30=%str("Сценарий №30: #date_key счет #account_number - осуществлен перевод д.с. на сумму #debit_credit_amount #currency от #remit_partner_name в пользу #benef_partner_name.");
50241712 +
50251713 +%let tcs3001=%str("Сценарий 3001: Один из участников зарегистрирован или проживает в стране, не участвующей в международном сообществе ПОД/ФТ; сумма начислений #currency_amount; клиен
50261713 !+#party_name; ИНН#party_tax_id");
50271714 +
50281715 +%let tcs3011=%str("Сценарий 3011: Предоставление или получение займа от лица, зарегистрированному или проживающему в стране, не участвующей в международном сообществе ПОД/ФТ; сумма
50291715 !+транзакции #currency_amount; клиент #party_name; ИНН #party_tax_id");
50301716 +
50311717 +%let tcs3021=%str("Сценарий 3021: Операции с ценными бумагами от лица, зарегистрированному или проживающему в стране, не участвующей в международном сообществе ПОД/ФТ; сумма транзакции
50321717 !+ #currency_amount; клиент #party_name; ИНН #party_tax_id");
50331718 +
50341719 +%let tcs4004=%str("Сценарий 4004 Отправитель не известен; сумма транзакции #currency_amount; клиент #party_name; ИНН #party_tax_id");
50351720 +
50361721 +%let tcs4005=%str("Сценарий 4005: Клиент зарегистрирован менее 3 месяцев; сумма транзакции #currency_amount; клиент #party_name; ИНН #party_tax_id");
50371722 +
50381723 +%let tcs4006=%str("Сценарий 4006: Первая транзакция по счету юридического лица; сумма транзакции #currency_amount; клиент #party_name; ИНН #party_tax_id");
50391724 +
50401725 +%let tcs4007=%str("Сценарий 4007: Клиент – стратегически значимое предприятие (213-ФЗ); сумма транзакции #currency_amount; клиент #party_name; ИНН #party_tax_id");
50411726 +
50421727 +%let tcs5002=%str("Сценарий 5002: Выплата / получение страхового возмещения/премии; сумма транзакции #currency_amount; клиен #party_name; ИНН #party_tax_id");
50431728 +
50441729 +%let tcs5003=%str("Сценарий 5003: Финансовая аренда / лизинг; сумма транзакции #currency_amount; клиент #party_name; ИНН #party_tax_id");
50451730 +
50461731 +%let tcs5005=%str("Сценарий 5005: Скупка / продажа драгоценных металлов и камней, ювелирных изделий на сумму #currency_amount организацией #party_name, ИНН #party_tax_id");
50471732 +
50481733 +%let tcs5006=%str("Сценарий 5006: Получение / выплата юридическому лицу платы / выигрыша; сумма транзакции #currency_amount; клиент #party_name; ИНН #party_tax_id");
50491734 +
50501735 +%let tcs5007=%str("Сценарий 5007: Предоставление / получение беспроцентного займа на сумму #currency_amount организации #party_name, ИНН #party_tax_id");
50511736 +
50521737 +%let tcs6001_1=%str("Сценарий №1: Сумма снятий наличными более #p1_amount руб. за #p1_period дней; клиент = #party_name; ИНН = #party_tax_id; сумма пополнения счета =
50531737 !+#total_credits_amount руб.; сумма снятий наличными= #total_cash_amount руб. (#cash_to_credits от пополнения счета)");
50541738 +
50551739 +%let tcs6001_10=%str("Сценарий №10: Счет клиента возможно используется как транзит; клиент #party_name; ИНН #party_tax_id; сумма поступлений #total_credits_amount рублей; сумма
50561739 !+списаний #total_debits_amount");
50571740 +
5058 The SAS System
5059
50601741 +%let tcs6001_12=%str("Сценарий №12: Выявлены операции или сделки, цель которых - возврат клиентом денежных средств контрагенту в течение короткого промежутка времени; Клиент
50611741 !+#party_name, счет Клиента #account_number");
50621742 +
50631743 +%let tcs6001_14=%str("Сценарий №14: Выявлено нехарактерное увеличение денежных средств клиента; клиент #party_name, счет клиента #account_name");
50641744 +
50651745 +%let tcs6001_17=%str("Сценарий №17: выявлены операции клиента на покупку товаров или активов, не предусматривающих оплату НДС; клиент #party_name, счет лиента #account_number");
50661746 +
50671747 +%let tcs6001_2=%str("Сценарий №2: Сумма снятий наличными более #p2_amount за #p2_period дней; клиент #party_name; ИНН #party_tax_id; сумма пополнения счета #total_credits_amount руб.;
50681747 !+сумма снятий наличными #total_cash_amount руб. (#cash_to_credits от пополнений счета)");
50691748 +
50701749 +%let tcs6001_3=%str("Сценарий №3: За последние #p3_period дней снятие наличности через кассу; клиент #party_name; ИНН #party_tax_id; сумма снятий наличными #total_cash_amount рублей");
50711750 +
50721751 +%let tcs6001_4=%str("Сценарий №4: За последние #p4_period дней операции по расчетам с нерезидентами; клиент #party_name; ИНН #party_tax_id; сумма операций #total_amount рублей");
50731752 +
50741753 +%let tcs6001_4005=%str("Сценарий №11_4005: Выявлены операции или сделки, целью которых является уклонение от сценария 4005; Организация #party_name зарегистрирована #rus_egrul_date и
50751753 !+совершила транзакции на сумму #all_sum рублей");
50761754 +
50771755 +%let tcs6001_5=%str("Сценарий №5: Операции подозрительного клиента; клиент #party_name; ИНН #party_tax_id; сумма операций #total_sum_amount рублей");
50781756 +
50791757 +%let tcs6001_5007=%str("Сценарий №11_5007: Выявлены операции или сделки, целью которых является уклонение от сценария 5007; Организация #party_name совершила транзакции на сумму
50801757 !+#all_sum рублей");
50811758 +
50821759 +%let tcs6001_6=%str("Сценарий №6: Операции с подозрительным контрагентом; клиент #party_name; ИНН #party_tax_id; сумма операций #total_sum_amount рублей");
50831760 +
50841761 +%let tcs6001_7=%str("Сценарий №7: Сумма поступлений более #p7_amount_min рублей; клиент #party_name; ИНН #party_tax_id; сумма поступлений #total_credits_amount рублей; количество
50851761 !+поступлений #in_nmb");
50861762 +
50871763 +%let tcs6001_8=%str("Сценарий №8: Резкий рост поступлений на счет клиента; клиент #party_name; ИНН #party_tax_id; сумма поступлений в текущем месяце #total_credits_amount рублей; сумма
50881763 !+ поступлений в прошлом месяце #last_month_credits_amount рублей");
50891764 +
50901765 +%let tcs6001_9=%str("Сценарий №9: Счет клиента возможно используется как транзит; клиент #party_name; ИНН #party_tax_id; сумма поступлений #total_credits_amount рублей; сумма списаний
50911765 !+ #total_debits_amount");
50921766 +
50931767 +%let tcs7001=%str("Сценарий 7001: Один из участников сделки подозревается в терроризме; сумма транзакции #currency_amount; клиент #party_name; ИНН #party_tax_id");
50941768 +
50951769 +%let tcs8001=%str("Сценарий 8001: Сделка с недвижимым имуществом; сумма транзакции #currency_amount; клиент #party_name; ИНН #party_tax_id");
50961770 +
50971771 +%let tcs9001=%str("Сценарий 9001: Операция по зачислению денежных средств на сумму #currency_amount на счет #account_number некоммерческой организации #party_name, ИНН #party_tax_id");
5098 The SAS System
5099
51001772 +
51011773 +%let tcs9002=%str("Сценарий 9002: Операция по расходованию денежных средств на сумму #currency_amount некоммерческой организацией #party_name, ИНН #party_tax_id");
51021774 +
5103NOTE: %INCLUDE (level 4) ending.
5104NOTE: %INCLUDE (level 3) resuming.
51051775 +
51061776 +/* Set alert filenames */
51071777 +%let alert_fname=work._tempalerts;
51081778 +%let alert_fname_final=STG_ALER.TCS_DJ_PARTY_CHG_ALERT&runasofdate ;
51091779 +
51101780 +/* Macros for each scenario/risk factor */
51111781 +/* TCS_DJ_PARTY_CHG */
51121782 +%macro fcf_run_scenario_10170323 (
51131783 + );
51141784 +
51151785 + %include '!AMLROOT/scenario/scenario_code_active/TCS_DJ_PARTY_CHG.sas' ;
51161786 +%mend;
51171787 +
51181788 +/* End scenario/risk factor macros */
51191789 +
51201790 +/* Begin Header Code */
51211791 +
51221792 +data &alert_fname
51231793 + ;
51241794 + keep primary_entity_number scenario_id rundate actual_values_text entity_level_code
51251795 + ;
51261796 + format rundate date9. actual_values_text $512. entity_level_code $3.;
51271797 + format primary_entity_number $ 75.;
51281798 + set MST_PREP.TCS_DJ_PARTY_CHG
51291799 + ;
51301800 + by PARTY_NUMBER ;
51311801 + if _n_ eq 1 then do;
51321802 + retain rundate rundate_number entity_level_code run_scenario_init;
51331803 + rundate = input(put(&runasofdate,8.),yymmdd8.);
51341804 + rundate_number = input(put(rundate,date_to_num.),8.);
51351805 + entity_level_code = "PTY";
51361806 + run_scenario_init = 1;
51371807 + end;
5138 The SAS System
5139
51401808 + if first.PARTY_NUMBER then n = 0;
51411809 + n + 1;
51421810 + if not last.PARTY_NUMBER then return;
51431811 + primary_entity_number = PARTY_NUMBER;
51441812 +
51451813 + /* End Header Code Generation */
51461814 +
51471815 + /* Call each scenario/risk factor macro after setting scenario_id variable.*/
51481816 + scenario_id = 10170323;
51491817 + /* TCS_DJ_PARTY_CHG */
51501818 + %fcf_run_scenario_10170323 (
51511819 + );
5152NOTE: %INCLUDE (level 4) file !AMLROOT/scenario/scenario_code_active/TCS_DJ_PARTY_CHG.sas is file
5153 /sas/config/Lev1/Applications/SASComplianceSolutions/scenario/scenario_code_active/TCS_DJ_PARTY_CHG.sas.
51541820 +/* flag for output */
51551821 +flag = 0;
51561822 +
51571823 +actual_values_text = 'Клиент из списков санкций изменил';
51581824 +
51591825 +/* checking INDIVIDUALS */
51601826 +if party_type_desc = 'INDIVIDUAL'
51611827 + /* individual entrepreneurs */
51621828 + or (party_type_desc ='ORGANIZATION' and (klength(old_party_tax_id) = 12 or klength(new_party_tax_id) = 12))
51631829 + then do;
51641830 + if old_party_first_name ne new_party_first_name then do;
51651831 + flag = 1;
51661832 + catx(' ', actual_values_text, 'РёРјСЏ');
5167 _
5168 22
5169 76
5170ERROR: Undeclared array referenced: catx.
5171ERROR 22-322: Syntax error, expecting one of the following: +, =.
5172
5173ERROR 76-322: Syntax error, statement will be ignored.
5174
51751833 + end;
51761834 + if old_party_last_name ne new_party_last_name then do;
51771835 + flag = 1;
5178 The SAS System
5179
51801836 + catx(', ', actual_values_text, 'фамилию');
5181 _
5182 22
5183 76
5184ERROR: Undeclared array referenced: catx.
5185ERROR 22-322: Syntax error, expecting one of the following: +, =.
5186
5187ERROR 76-322: Syntax error, statement will be ignored.
5188
51891837 + end;
51901838 + if old_party_middle_name ne new_party_middle_name then do;
51911839 + flag = 1;
51921840 + catx(', ', actual_values_text, 'отчество');
5193 _
5194 22
5195 76
5196ERROR: Undeclared array referenced: catx.
5197ERROR 22-322: Syntax error, expecting one of the following: +, =.
5198
5199ERROR 76-322: Syntax error, statement will be ignored.
5200
52011841 + end;
52021842 + if old_party_date_of_birth ne new_party_date_of_birth then do;
52031843 + flag = 1;
52041844 + catx(', ', actual_values_text, 'дату рождения');
5205 _
5206 22
5207 76
5208ERROR: Undeclared array referenced: catx.
5209ERROR 22-322: Syntax error, expecting one of the following: +, =.
5210
5211ERROR 76-322: Syntax error, statement will be ignored.
5212
52131845 + end;
52141846 +end;
52151847 +
52161848 +/* checking ORGANIZATION*/
52171849 +else do;
5218 The SAS System
5219
52201850 + if old_party_name ne new_party_name then do;
52211851 + flag = 1;
52221852 + catx(' ', actual_values_text, 'название');
5223 _
5224 22
5225 76
5226ERROR: Undeclared array referenced: catx.
5227ERROR 22-322: Syntax error, expecting one of the following: +, =.
5228
5229ERROR 76-322: Syntax error, statement will be ignored.
5230
52311853 + end;
52321854 + if old_party_tax_id ne new_party_tax_id then do;
52331855 + flag = 1;
52341856 + catx(', ', actual_values_text, 'РРќРќ');
5235 _
5236 22
5237 76
5238ERROR: Undeclared array referenced: catx.
5239ERROR 22-322: Syntax error, expecting one of the following: +, =.
5240
5241ERROR 76-322: Syntax error, statement will be ignored.
5242
52431857 + end;
52441858 + if old_rus_reg_num ne new_rus_reg_num then do;
52451859 + flag = 1;
52461860 + catx(', ', actual_values_text, 'ОГРН');
5247 _
5248 22
5249 76
5250ERROR: Undeclared array referenced: catx.
5251ERROR 22-322: Syntax error, expecting one of the following: +, =.
5252
5253ERROR 76-322: Syntax error, statement will be ignored.
5254
52551861 + end;
52561862 +end;
52571863 +
5258 The SAS System
5259
52601864 +if flag = 1 then output;
5261NOTE: %INCLUDE (level 4) ending.
5262NOTE: %INCLUDE (level 3) resuming.
52631865 +
52641866 + run_scenario_init = 0;
52651867 + drop run_scenario_init;
52661868 + run;
5267
5268NOTE: The SAS System stopped processing this step because of errors.
5269NOTE: SAS set option OBS=0 and will continue to check statements. This might cause NOTE: No observations in data set.
5270WARNING: The data set WORK._TEMPALERTS may be incomplete. When this step was stopped there were 0 observations and 5 variables.
5271NOTE: DATA statement used (Total process time):
5272 real time 0.04 seconds
5273 user cpu time 0.03 seconds
5274 system cpu time 0.02 seconds
5275 memory 1112.28k
5276 OS Memory 190024.00k
5277 Timestamp 24.07.2019 02:32:33 после полудня
5278 Step Count 2034 Switch Count 308
5279 Page Faults 0
5280 Page Reclaims 198
5281 Page Swaps 0
5282 Voluntary Context Switches 1253
5283 Involuntary Context Switches 17
5284 Block Input Operations 0
5285 Block Output Operations 0
5286
5287
52881869 +
52891870 +%fcf_rcset(&syserr);
52901871 +
5291NOTE: %INCLUDE (level 3) ending.
5292NOTE: %INCLUDE (level 2) resuming.
52931872 +%fcf_sa_append_header_results(header=TCS_DJ_PARTY_CHG);
5294NOTE: %INCLUDE (level 2) ending.
5295NOTE: %INCLUDE (level 1) resuming.
5296NOTE: {START: fcf_chkrc}
5297SYSERR: 1012
5298 The SAS System
5299
5300ERROR: Aborting job.
5301WARNING: File WORK._TEMPALERTS_TRANS_KEYS.DATA does not exist.
5302NOTE: {END: fcf_chkrc}
5303NOTE: FCF_SYNC.FCF_SA_SYNC_MUTEX.DATA is no longer locked by you.
5304VERSION 6.3HF4 T69004-T68004
5305ERROR: Выполнение сценария завершилось с ошибками, см. подробности в журнале SAS.
5306
5307NOTE: DATA statement used (Total process time):
5308 real time 0.00 seconds
5309 user cpu time 0.00 seconds
5310 system cpu time 0.00 seconds
5311 memory 614.59k
5312 OS Memory 189520.00k
5313 Timestamp 24.07.2019 02:32:33 после полудня
5314 Step Count 2035 Switch Count 16
5315 Page Faults 0
5316 Page Reclaims 51
5317 Page Swaps 0
5318 Voluntary Context Switches 8
5319 Involuntary Context Switches 1
5320 Block Input Operations 0
5321 Block Output Operations 0
5322
5323
5324NOTE: fcf_sync.fcf_sa_sync_mutex is not locked
5325
5326NOTE: The data set WORK.ERR_MSG has 0 observations and 1 variables.
5327NOTE: DATA statement used (Total process time):
5328 real time 0.00 seconds
5329 user cpu time 0.00 seconds
5330 system cpu time 0.00 seconds
5331 memory 614.59k
5332 OS Memory 189520.00k
5333 Timestamp 24.07.2019 02:32:33 после полудня
5334 Step Count 2036 Switch Count 18
5335 Page Faults 0
5336 Page Reclaims 54
5337 Page Swaps 0
5338 The SAS System
5339
5340 Voluntary Context Switches 17
5341 Involuntary Context Switches 0
5342 Block Input Operations 0
5343 Block Output Operations 0
5344
5345
5346NOTE: PROCEDURE PRINT used (Total process time):
5347 real time 0.00 seconds
5348 user cpu time 0.01 seconds
5349 system cpu time 0.00 seconds
5350 memory 228.28k
5351 OS Memory 189264.00k
5352 Timestamp 24.07.2019 02:32:33 после полудня
5353 Step Count 2037 Switch Count 16
5354 Page Faults 0
5355 Page Reclaims 4
5356 Page Swaps 0
5357 Voluntary Context Switches 9
5358 Involuntary Context Switches 0
5359 Block Input Operations 0
5360 Block Output Operations 0
5361
5362
53631873 +
5364NOTE: %INCLUDE (level 1) ending.