1 The SAS System 09:39 Tuesday, August 23, 2016 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Program'; 4 %LET _CLIENTPROJECTPATH='Z:\SAS Data\user\qjiang\TLP ALLL\Title ALLL 05August.egp'; 5 %LET _CLIENTPROJECTNAME='Title ALLL 05August.egp'; 6 %LET _SASPROGRAMFILE=; 7 8 ODS _ALL_ CLOSE; 9 OPTIONS DEV=ACTIVEX; 10 GOPTIONS XPIXELS=0 YPIXELS=0; 11 FILENAME EGPDF TEMP; 12 ODS PDF(ID=EGPDF) FILE=EGPDF STYLE=printer SAS; WARNING: Unsupported device 'ACTIVEX' for PDF(EGPDF) destination. Using device 'ACTXIMG'. NOTE: Writing ODS PDF(EGPDF) output to DISK destination "EGPDF", printer "PDF". 13 FILENAME EGSR TEMP; 14 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 15 STYLE=HtmlBlue 16 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome_9.4/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css") 17 NOGTITLE 18 NOGFOOTNOTE 19 GPATH=&sasworklocation 20 ENCODING=UTF8 21 options(rolap="on") 22 ; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 23 24 GOPTIONS ACCESSIBLE; 25 OPTIONS FULLSTIMER SOURCE SOURCE2 MSGLEVEL=I MPRINT NOTES; 26 PROC OPTIONS GROUP=MEMORY; SAS (r) Proprietary Software Release 9.4 TS1M2 Group=MEMORY SORTSIZE=1073741824 Specifies the amount of memory that is available to the SORT procedure. SUMSIZE=0 Specifies a limit on the amount of memory that is available for data summarization procedures when class variables are active. MAXMEMQUERY=0 Specifies the maximum amount of memory that is allocated for procedures. MEMBLKSZ=16777216 Specifies the memory block size for Windows memory-based libraries. MEMMAXSZ=2147483648 Specifies the maximum amount of memory to allocate for using memory-based libraries. LOADMEMSIZE=0 Specifies a suggested amount of memory that is needed for executable programs loaded by SAS. MEMSIZE=75489227520 Specifies the limit on the amount of virtual memory that can be used during a SAS session. REALMEMSIZE=0 Specifies the amount of real memory SAS can expect to allocate. NOTE: PROCEDURE OPTIONS used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 20.09k OS Memory 25696.00k Timestamp 08/24/2016 03:42:40 PM Step Count 25 Switch Count 52 27 PROC OPTIONS GROUP=PERFORMANCE; 28 RUN; 2 The SAS System 09:39 Tuesday, August 23, 2016 SAS (r) Proprietary Software Release 9.4 TS1M2 Group=PERFORMANCE ARMAGENT= Specifies an ARM agent (which is an executable module or keyword, such as LOG4SAS) that contains a specific implementation of the ARM API. ARMLOC=ARMLOG.LOG Specifies the location of the ARM log. ARMSUBSYS=(ARM_NONE) Specifies the SAS ARM subsystems to enable or disable. BUFNO=1 Specifies the number of buffers for processing SAS data sets. BUFSIZE=0 Specifies the size of a buffer page for output SAS data sets. CGOPTIMIZE=3 Specifies the level of optimization to perform during code compilation. CMPMODEL=BOTH Specifies the output model type for the MODEL procedure. CMPOPT=(NOEXTRAMATH NOMISSCHECK NOPRECISE NOGUARDCHECK NOGENSYMNAMES NOFUNCDIFFERENCING) Specifies the type of code-generation optimizations to use in the SAS language compiler. COMPRESS=NO Specifies the type of compression to use for observations in output SAS data sets. CPUCOUNT=24 Specifies the number of processors that thread-enabled applications should assume are available for concurrent processing. NODBIDIRECTEXEC The SQL pass-through facility does not optimize the handling of SQL statements. DBSLICEPARM=(THREADED_APPS, 2) Specifies whether SAS procedures, applications, and the DATA step can read DBMS tables in parallel, and the number of threads to use to read the DBMS tables. MAXSEGRATIO=75 Specifies the upper limit for the percentage of index segments that the SPD Engine identifies as containing the value referenced in the WHERE expression. MEXECSIZE=65536 Specifies the maximum macro size that can be executed in memory. MINPARTSIZE=16777216 Specifies the minimum size of the data component partitions for SPD Engine data sets. SORTSIZE=1073741824 Specifies the amount of memory that is available to the SORT procedure. NOSPDEFILECACHE Disables caching of opened SPD Engine files. SPDEINDEXSORTSIZE=33554432 Specifies the memory size for sorting index values. SPDEMAXTHREADS=0 Specifies the maximum number of threads that the SPD Engine can spawn for I/O processing. SPDEPARALLELREAD=NO Enables or disables SPD Engine parallel reads when no WHERE clause is in effect. SPDESORTSIZE=33554432 Specifies the memory size that is used for sorting by the SPD Engine. SPDEUTILLOC= Specifies one or more locations where the SPD Engine can temporarily store utility files. SPDEWHEVAL=COST Specifies the WHERE statement evaluation process for the SPD Engine. SQLGENERATION=(NONE DBMS='TERADATA DB2 ORACLE NETEZZA ASTER GREENPLM HADOOP SAPHANA') Specifies whether and when SAS procedures generate SQL for in-database processing of source data. SQLREDUCEPUT=DBMS For PROC SQL, specifies the engine type to use to optimize a PUT function in a query. SQLREDUCEPUTOBS=0 For PROC SQL, specifies the minimum number of observations that must be in a table for PROC SQL to optimize the PUT function in a query. SQLREDUCEPUTVALUES=0 For PROC SQL, specifies the maximum number of SAS format values that can exist in a PUT function expression to optimize the PUT function in a query. STRIPESIZE= Specifies path and size pairs to identify I/O device stripe size. Stripe size indicates page size when creating a data set or utility file. THREADS Uses threaded processing for SAS applications that support it. UTILLOC="E:\UTILLOC" Specifies one or more file system locations in which threaded applications can store utility files. WORK=E:\WORK\_TD7308_CSSSASAPP_\Prc2 Specifies the libref or location of the Work library. SLEEPCNTL=NO Specifies whether SAS prevents Windows from going into sleep mode. ALIGNSASIOFILES Aligns SAS files on a page boundary for improved performance. MEMSIZE=75489227520 3 The SAS System 09:39 Tuesday, August 23, 2016 Specifies the limit on the amount of virtual memory that can be used during a SAS session. NOTE: PROCEDURE OPTIONS used (Total process time): real time 0.01 seconds user cpu time 0.00 seconds system cpu time 0.01 seconds memory 18.09k OS Memory 25696.00k Timestamp 08/24/2016 03:42:40 PM Step Count 26 Switch Count 144 29 LIBNAME _ALL_ LIST; NOTE: Libref= WORK Scope= IOM ROOT COMP ENV Engine= V9 Access= TEMP Physical Name= E:\WORK\_TD7308_CSSSASAPP_\Prc2 Filename= E:\WORK\_TD7308_CSSSASAPP_\Prc2 NOTE: Libref= IL2 Scope= IOM ROOT COMP ENV Engine= V9 Physical Name= \\aacadasas\cada\SAS Data\User\MZHANG\ILP ALLL\Run on Dec16, 2014 Filename= \\aacadasas\cada\SAS Data\User\MZHANG\ILP ALLL\Run on Dec16, 2014 NOTE: Libref= TITLES Scope= IOM ROOT COMP ENV Engine= V9 Physical Name= \\CSSSASAPP\CADA\SAS Data\user\qjiang\TLP ALLL\Title ALLL Model SAS Datasets Filename= \\CSSSASAPP\CADA\SAS Data\user\qjiang\TLP ALLL\Title ALLL Model SAS Datasets NOTE: Libref= SASDATA Scope= Object Server Engine= BASE Physical Name= D:\SAS\Config\Lev1\SASApp\Data Filename= D:\SAS\Config\Lev1\SASApp\Data NOTE: Libref= KITS Scope= Object Server Engine= BASE Access= READONLY Physical Name= D:\SAS\Config\Lev1\Web\SASEnvironmentManager\emi-framework\Datamart\kits Filename= D:\SAS\Config\Lev1\Web\SASEnvironmentManager\emi-framework\Datamart\kits NOTE: Libref= EVDM Scope= Object Server Engine= META Access= READONLY Physical Name= D:\SAS\Config\Lev1\Web\SASEnvironmentManager\emi-framework\Datamart\evdm Filename= D:\SAS\Config\Lev1\Web\SASEnvironmentManager\emi-framework\Datamart\evdm NOTE: Libref= ARTIFACT Scope= Object Server Engine= BASE Access= READONLY Physical Name= D:\SAS\Config\Lev1\Web\SASEnvironmentManager\emi-framework\apm\Data\artifacts Filename= D:\SAS\Config\Lev1\Web\SASEnvironmentManager\emi-framework\apm\Data\artifacts NOTE: Libref= ACM Scope= Object Server Engine= BASE Access= READONLY Physical Name= D:\SAS\Config\Lev1\Web\SASEnvironmentManager\emi-framework\Datamart\acm Filename= D:\SAS\Config\Lev1\Web\SASEnvironmentManager\emi-framework\Datamart\acm NOTE: Libref= NGSILO 4 The SAS System 09:39 Tuesday, August 23, 2016 Scope= Object Server Engine= ORACLE Physical Name= PEDWQA1 Schema/User= SC_SILO_NG NOTE: Libref= ONLINE Scope= Object Server Engine= BASE Physical Name= \\aacadasas\cada\sas data\datamart\online Filename= \\aacadasas\cada\sas data\datamart\online NOTE: Libref= ONLINEP Scope= Object Server Engine= ORACLE Physical Name= BIOR Schema/User= ONLINEDATA NOTE: Libref= ECACTR Scope= Object Server Engine= BASE Physical Name= E:\Shared\CADA\SAS Data\DataMart\ECA Filename= E:\Shared\CADA\SAS Data\DataMart\ECA NOTE: Libref= CORIOS Scope= Object Server Engine= BASE Physical Name= E:\Shared\CADA\SAS Data\Corios\Data Filename= E:\Shared\CADA\SAS Data\Corios\Data NOTE: Libref= SCDPEDW Scope= Object Server Engine= ORACLE Physical Name= PEDWQA1 Schema/User= SC_DMARTS NOTE: Libref= COMMON Scope= Object Server Engine= BASE Physical Name= E:\Shared\CADA\SAS Data\Common Shared Filename= E:\Shared\CADA\SAS Data\Common Shared NOTE: Libref= NGAR Scope= Object Server Engine= BASE Physical Name= E:\Shared\CADA\SAS Data\DataMart\NextGen\Accounting Reports Filename= E:\Shared\CADA\SAS Data\DataMart\NextGen\Accounting Reports NOTE: Libref= NEXTGEN Scope= Object Server Engine= BASE Physical Name= E:\Shared\CADA\SAS eMiner\UW Objects\NextGen data Filename= E:\Shared\CADA\SAS eMiner\UW Objects\NextGen data NOTE: Libref= MONEYGRM Scope= Object Server Engine= META Physical Name= EPPROD1 Schema/User= PSOWNER NOTE: Libref= MODELMIS Scope= Object Server Engine= BASE Physical Name= E:\Shared\CADA\SAS eMiner\UW Objects\Model Misc Filename= E:\Shared\CADA\SAS eMiner\UW Objects\Model Misc NOTE: Libref= TITLE Scope= Object Server Engine= BASE Physical Name= E:\Shared\CADA\SAS eMiner\UW Objects\Title data 5 The SAS System 09:39 Tuesday, August 23, 2016 Filename= E:\Shared\CADA\SAS eMiner\UW Objects\Title data NOTE: Libref= INSTALL Scope= Object Server Engine= BASE Physical Name= E:\Shared\CADA\SAS eMiner\UW Objects\Installment data Filename= E:\Shared\CADA\SAS eMiner\UW Objects\Installment data NOTE: Libref= DAILY Scope= Object Server Engine= BASE Physical Name= E:\Shared\CADA\SAS Data\DataMart\eadvdata\Daily Filename= E:\Shared\CADA\SAS Data\DataMart\eadvdata\Daily NOTE: Libref= ETAX Scope= Object Server Engine= ORACLE Physical Name= EDWPRD Schema/User= EDW_RPT NOTE: Libref= EADVDATA Scope= Object Server Engine= BASE Physical Name= E:\Shared\CADA\SAS Data\DataMart\eadvdata Filename= E:\Shared\CADA\SAS Data\DataMart\eadvdata NOTE: Libref= BIOR Scope= Object Server Engine= ORACLE Physical Name= BIOR Schema/User= BIOR NOTE: Libref= TXTITLE Scope= Object Server Engine= META Physical Name= EDWPRD Schema/User= edw NOTE: Libref= QFUND3 Scope= Object Server Engine= ORACLE Physical Name= EDWPRD Schema/User= QFUND3 NOTE: Libref= SCODSBI Scope= Object Server Engine= ORACLE Physical Name= EDWPRD Schema/User= SC_ODS_BI NOTE: Libref= RTDM Scope= Object Server Engine= ORACLE Physical Name= EDWPRD Schema/User= RTDM NOTE: Libref= QFUND1 Scope= Object Server Engine= ORACLE Physical Name= EDWPRD Schema/User= QFUND1 NOTE: Libref= DWQ1FIN Scope= Object Server Engine= ORACLE Physical Name= PEDWQA1 Schema/User= SC_ODS_FIN NOTE: Libref= OHCSO Scope= Object Server 6 The SAS System 09:39 Tuesday, August 23, 2016 Engine= ORACLE Physical Name= EDWPRD Schema/User= EDW NOTE: Libref= NGPRODV Scope= Object Server Engine= ORACLE Physical Name= NGRPTNG Schema/User= SC_DMARTS NOTE: Libref= FVS Scope= Object Server Engine= ORACLE Physical Name= EDWPRD Schema/User= STG_QFUND_VS NOTE: Libref= EEE Scope= Object Server Engine= ORACLE Physical Name= EAPROD1 Schema/User= EEE NOTE: Libref= EDW_STAR Scope= Object Server Engine= ORACLE Physical Name= EDWPRD Schema/User= EDW_STAR NOTE: Libref= EDW_ST Scope= Object Server Engine= ORACLE Physical Name= EDWPRD Schema/User= EDW_ST NOTE: Libref= EDW Scope= Object Server Engine= ORACLE Physical Name= EDWPRD Schema/User= EDW NOTE: Libref= ECA Scope= Object Server Engine= ORACLE Physical Name= EDWPRD Schema/User= ECA NOTE: Libref= CADA Scope= Object Server Engine= ORACLE Physical Name= BIOR Schema/User= CADA NOTE: Libref= EADV Scope= Object Server Engine= ORACLE Physical Name= EAPROD1 Schema/User= eadv NOTE: Libref= STPSAMP Scope= Object Server Engine= BASE Access= READONLY Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\inttech\sample Filename= C:\Program Files\SASHome\SASFoundation\9.4\inttech\sample NOTE: Libref= SASHELP Scope= Kernel Levels= 19 -Level 1- 7 The SAS System 09:39 Tuesday, August 23, 2016 Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\nls\en\SASCFG Filename= C:\Program Files\SASHome\SASFoundation\9.4\nls\en\SASCFG -Level 2- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\core\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\core\sashelp -Level 3- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\aacomp\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\aacomp\sashelp -Level 4- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\bimva\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\bimva\sashelp -Level 5- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\cmp\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\cmp\sashelp -Level 6- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\connect\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\connect\sashelp -Level 7- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\creditscrnod\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\creditscrnod\sashelp -Level 8- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\dcmsvr\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\dcmsvr\sashelp -Level 9- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\dmine\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\dmine\sashelp -Level 10- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\ets\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\ets\sashelp -Level 11- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\graph\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\graph\sashelp -Level 12- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\iml\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\iml\sashelp -Level 13- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\inttech\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\inttech\sashelp -Level 14- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\lasr\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\lasr\sashelp -Level 15- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\mmcommon\sashelp 8 The SAS System 09:39 Tuesday, August 23, 2016 Filename= C:\Program Files\SASHome\SASFoundation\9.4\mmcommon\sashelp -Level 16- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\mmcore\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\mmcore\sashelp -Level 17- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\or\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\or\sashelp -Level 18- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\spdsclient\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\spdsclient\sashelp -Level 19- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\stat\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\stat\sashelp NOTE: Libref= MAPS Scope= Kernel Engine= V9 Access= READONLY Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\maps Filename= C:\Program Files\SASHome\SASFoundation\9.4\maps NOTE: Libref= MAPSSAS Scope= Kernel Engine= V9 Access= READONLY Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\maps Filename= C:\Program Files\SASHome\SASFoundation\9.4\maps NOTE: Libref= MAPSGFK Scope= Kernel Engine= V9 Access= READONLY Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\mapsgfk Filename= C:\Program Files\SASHome\SASFoundation\9.4\mapsgfk NOTE: Libref= SASUSER Scope= Kernel Engine= V9 Access= READONLY Physical Name= D:\SASWork\My SAS Files\9.4 Filename= D:\SASWork\My SAS Files\9.4 30 PROC OPTIONS OPTION=WORK; SAS (r) Proprietary Software Release 9.4 TS1M2 WORK=E:\WORK\_TD7308_CSSSASAPP_\Prc2 Specifies the libref or location of the Work library. NOTE: PROCEDURE OPTIONS used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 19.12k OS Memory 25696.00k Timestamp 08/24/2016 03:42:40 PM Step Count 27 Switch Count 28 31 PROC OPTIONS OPTION=UTILLOC; 9 The SAS System 09:39 Tuesday, August 23, 2016 32 RUN; SAS (r) Proprietary Software Release 9.4 TS1M2 UTILLOC="E:\UTILLOC" Specifies one or more file system locations in which threaded applications can store utility files. NOTE: PROCEDURE OPTIONS used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 19.12k OS Memory 25696.00k Timestamp 08/24/2016 03:42:40 PM Step Count 28 Switch Count 32 33 DATA _NULL_; 34 %PUT This job started on &sysdate at &systime; This job started on 23AUG16 at 09:39 35 RUN; NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 210.40k OS Memory 25696.00k Timestamp 08/24/2016 03:42:40 PM Step Count 29 Switch Count 28 36 37 38 GOPTIONS NOACCESSIBLE; 39 %LET _CLIENTTASKLABEL=; 40 %LET _CLIENTPROJECTPATH=; 41 %LET _CLIENTPROJECTNAME=; 42 %LET _SASPROGRAMFILE=; 43 44 ;*';*";*/;quit;run; 45 ODS _ALL_ CLOSE; NOTE: ODS PDF(EGPDF) printed no output. (This sometimes results from failing to place a RUN statement before the ODS PDF(EGPDF) CLOSE statement.) 46 47 48 QUIT; RUN; 49