NOTE: PROCEDURE PRINTTO used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 98.93k OS Memory 33440.00k Timestamp 2020/10/09 07:32:39 PM Step Count 8591 Switch Count 10 Page Faults 0 Page Reclaims 4 Page Swaps 0 Voluntary Context Switches 40 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 41 + 42 + 43 +%let caserk=674484 ; 44 +libname ecm_db &ecm_libname_conn ; NOTE: Libref ECM_DB was successfully assigned as follows: Engine: ORACLE Physical Name: corcrime 45 + 46 +%macro getTxns (tbl); 47 + 48 + data work.&tbl.; 49 + set ecm_db.SUBP_X_CASE_&tbl. (where=(case_rk=&caserk)); 50 + run; 51 + 52 + /*proc export data=work.&tbl. dbms=xlsx 53 + outfile="%sysfunc(pathname(work))/subpoena_&caserk._txns.xlsx"; 54 + sheet="&tbl."; 55 + run;*/ The SAS System 56 + 57 +%mend getTxns; 58 +%getTxns(FITACCTSTXNS) ; NOTE: There were 629 observations read from the data set ECM_DB.SUBP_X_CASE_FITACCTSTXNS. WHERE case_rk=674484; NOTE: The data set WORK.FITACCTSTXNS has 629 observations and 47 variables. NOTE: Compressing data set WORK.FITACCTSTXNS decreased size by 94.29 percent. Compressed is 4 pages; un-compressed would require 70 pages. NOTE: DATA statement used (Total process time): real time 0.04 seconds user cpu time 0.03 seconds system cpu time 0.01 seconds memory 19858.62k OS Memory 51968.00k Timestamp 2020/10/09 07:32:39 PM Step Count 8592 Switch Count 3 Page Faults 0 Page Reclaims 828 Page Swaps 0 Voluntary Context Switches 48 Involuntary Context Switches 124 Block Input Operations 0 Block Output Operations 1032 59 +%getTxns(FITCCACCSTXNS) ; NOTE: There were 0 observations read from the data set ECM_DB.SUBP_X_CASE_FITCCACCSTXNS. WHERE case_rk=674484; NOTE: The data set WORK.FITCCACCSTXNS has 0 observations and 20 variables. 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 857.68k OS Memory 33440.00k Timestamp 2020/10/09 07:32:39 PM The SAS System Step Count 8593 Switch Count 0 Page Faults 0 Page Reclaims 7 Page Swaps 0 Voluntary Context Switches 3 Involuntary Context Switches 6 Block Input Operations 0 Block Output Operations 264 60 +%getTxns(FITWESACCSTXNS) ; NOTE: There were 0 observations read from the data set ECM_DB.SUBP_X_CASE_FITWESACCSTXNS. WHERE case_rk=674484; NOTE: The data set WORK.FITWESACCSTXNS has 0 observations and 8 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 1187.18k OS Memory 33860.00k Timestamp 2020/10/09 07:32:39 PM Step Count 8594 Switch Count 1 Page Faults 0 Page Reclaims 41 Page Swaps 0 Voluntary Context Switches 8 Involuntary Context Switches 7 Block Input Operations 0 Block Output Operations 264 61 +%getTxns(FITZDCACCSTXNS) ; NOTE: There were 252 observations read from the data set ECM_DB.SUBP_X_CASE_FITZDCACCSTXNS. WHERE case_rk=674484; NOTE: The data set WORK.FITZDCACCSTXNS has 252 observations and 23 variables. NOTE: Compressing data set WORK.FITZDCACCSTXNS decreased size by 60.00 percent. The SAS System Compressed is 2 pages; un-compressed would require 5 pages. NOTE: DATA statement used (Total process time): real time 0.01 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 897.81k OS Memory 33748.00k Timestamp 2020/10/09 07:32:39 PM Step Count 8595 Switch Count 0 Page Faults 0 Page Reclaims 84 Page Swaps 0 Voluntary Context Switches 7 Involuntary Context Switches 11 Block Input Operations 0 Block Output Operations 264 62 +%getTxns(NEPS_TXN) ; NOTE: There were 16 observations read from the data set ECM_DB.SUBP_X_CASE_NEPS_TXN. WHERE case_rk=674484; NOTE: The data set WORK.NEPS_TXN has 16 observations and 27 variables. NOTE: Compressing data set WORK.NEPS_TXN increased size by 100.00 percent. Compressed is 2 pages; un-compressed would require 1 pages. NOTE: DATA statement used (Total process time): real time 0.01 seconds user cpu time 0.01 seconds system cpu time 0.01 seconds memory 2291.09k OS Memory 34892.00k Timestamp 2020/10/09 07:32:39 PM Step Count 8596 Switch Count 1 Page Faults 0 Page Reclaims 157 Page Swaps 0 Voluntary Context Switches 10 Involuntary Context Switches 12 The SAS System Block Input Operations 0 Block Output Operations 264 63 +%getTxns(PACS_057JTXNS) ; NOTE: There were 0 observations read from the data set ECM_DB.SUBP_X_CASE_PACS_057JTXNS. WHERE case_rk=674484; NOTE: The data set WORK.PACS_057JTXNS has 0 observations and 14 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 1668.28k OS Memory 34192.00k Timestamp 2020/10/09 07:32:39 PM Step Count 8597 Switch Count 1 Page Faults 0 Page Reclaims 61 Page Swaps 0 Voluntary Context Switches 8 Involuntary Context Switches 9 Block Input Operations 0 Block Output Operations 264 64 +%getTxns(PACS_067JTXNS) ; NOTE: There were 0 observations read from the data set ECM_DB.SUBP_X_CASE_PACS_067JTXNS. WHERE case_rk=674484; NOTE: The data set WORK.PACS_067JTXNS has 0 observations and 13 variables. NOTE: DATA statement used (Total process time): real time 0.52 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 1790.37k OS Memory 34548.00k Timestamp 2020/10/09 07:32:40 PM The SAS System Step Count 8598 Switch Count 1 Page Faults 0 Page Reclaims 125 Page Swaps 0 Voluntary Context Switches 9 Involuntary Context Switches 19 Block Input Operations 0 Block Output Operations 264 65 +%getTxns(RTC_CONVERSTXNS) ; NOTE: There were 0 observations read from the data set ECM_DB.SUBP_X_CASE_RTC_CONVERSTXNS. WHERE case_rk=674484; NOTE: The data set WORK.RTC_CONVERSTXNS has 0 observations and 38 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds user cpu time 0.00 seconds system cpu time 0.01 seconds memory 4040.21k OS Memory 36440.00k Timestamp 2020/10/09 07:32:40 PM Step Count 8599 Switch Count 1 Page Faults 0 Page Reclaims 304 Page Swaps 0 Voluntary Context Switches 10 Involuntary Context Switches 40 Block Input Operations 0 Block Output Operations 360 66 +%getTxns(RTC_PAYMENTSTXNS) ; NOTE: There were 0 observations read from the data set ECM_DB.SUBP_X_CASE_RTC_PAYMENTSTXNS. WHERE case_rk=674484; NOTE: The data set WORK.RTC_PAYMENTSTXNS has 0 observations and 46 variables. NOTE: DATA statement used (Total process time): The SAS System real time 0.01 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 7815.46k OS Memory 40396.00k Timestamp 2020/10/09 07:32:40 PM Step Count 8600 Switch Count 1 Page Faults 0 Page Reclaims 553 Page Swaps 0 Voluntary Context Switches 9 Involuntary Context Switches 39 Block Input Operations 0 Block Output Operations 520 67 +%getTxns(SEC32ACCSTXNS) ; NOTE: There were 0 observations read from the data set ECM_DB.SUBP_X_CASE_SEC32ACCSTXNS. WHERE case_rk=674484; NOTE: The data set WORK.SEC32ACCSTXNS has 0 observations and 21 variables. 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 860.59k OS Memory 33700.00k Timestamp 2020/10/09 07:32:40 PM Step Count 8601 Switch Count 0 Page Faults 0 Page Reclaims 72 Page Swaps 0 Voluntary Context Switches 3 Involuntary Context Switches 4 Block Input Operations 0 Block Output Operations 264 The SAS System 68 +%getTxns(VODS_FIN_LOGTXNS) ; NOTE: There were 0 observations read from the data set ECM_DB.SUBP_X_CASE_VODS_FIN_LOGTXNS. WHERE case_rk=674484; NOTE: The data set WORK.VODS_FIN_LOGTXNS has 0 observations and 19 variables. NOTE: DATA statement used (Total process time): real time 0.29 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 1795.15k OS Memory 34184.00k Timestamp 2020/10/09 07:32:40 PM Step Count 8602 Switch Count 1 Page Faults 0 Page Reclaims 61 Page Swaps 0 Voluntary Context Switches 9 Involuntary Context Switches 22 Block Input Operations 0 Block Output Operations 264 69 + 70 + 71 +ods listing close; 72 +data _null_; rc = stpsrv_header('Content-type','application/vnd.ms-excel'); run; INFO: Character variables have defaulted to a length of 200 at the places given by: (Line):(Column). Truncation can result. 72:15 rc 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 776.78k OS Memory 33440.00k Timestamp 2020/10/09 07:32:40 PM Step Count 8603 Switch Count 0 Page Faults 0 The SAS System Page Reclaims 2 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 73 +data _null_; rc = stpsrv_header('Content-type','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); run; INFO: Character variables have defaulted to a length of 200 at the places given by: (Line):(Column). Truncation can result. 73:15 rc 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 777.78k OS Memory 33440.00k Timestamp 2020/10/09 07:32:40 PM Step Count 8604 Switch Count 0 Page Faults 0 Page Reclaims 2 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 2 Block Input Operations 0 Block Output Operations 0 74 + 75 + 76 +data _null_; rc = stpsrv_header('Content-disposition', "attachment; filename=subpoena_&caserk._FITACCTSTXNS.xls"); run; INFO: Character variables have defaulted to a length of 200 at the places given by: (Line):(Column). Truncation can result. 76:15 rc NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds The SAS System system cpu time 0.00 seconds memory 776.78k OS Memory 33440.00k Timestamp 2020/10/09 07:32:40 PM Step Count 8605 Switch Count 0 Page Faults 0 Page Reclaims 3 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 77 +ODS excel FILE=_webout style=plateau OPTIONS(SHEET_NAME="Class"); 78 +proc print data=FITACCTSTXNS; run; NOTE: There were 629 observations read from the data set WORK.FITACCTSTXNS. NOTE: PROCEDURE PRINT used (Total process time): real time 9.13 seconds user cpu time 8.99 seconds system cpu time 0.09 seconds memory 128359.46k OS Memory 184264.00k Timestamp 2020/10/09 07:32:49 PM Step Count 8606 Switch Count 0 Page Faults 0 Page Reclaims 32777 Page Swaps 0 Voluntary Context Switches 1 Involuntary Context Switches 882 Block Input Operations 0 Block Output Operations 2344 78 !+ quit; 79 + 80 +ODS excel FILE=_webout OPTIONS(SHEET_NAME="Class2"); The SAS System NOTE: Writing EXCEL Body file: _WEBOUT 81 +proc print data=NEPS_TXN; run; NOTE: There were 16 observations read from the data set WORK.NEPS_TXN. NOTE: PROCEDURE PRINT used (Total process time): real time 0.16 seconds user cpu time 0.17 seconds system cpu time 0.00 seconds memory 1611.78k OS Memory 44740.00k Timestamp 2020/10/09 07:32:50 PM Step Count 8607 Switch Count 0 Page Faults 0 Page Reclaims 72 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 14 Block Input Operations 0 Block Output Operations 0 81 !+ quit; 82 + 83 +ods excel close ; NOTE: Writing EXCEL file: ./ED9867EE-E4EC-F541-AECF-FA3E4FE868D3 ERROR: Physical file does not exist, /grid/config/Lev1/SASApp/ED9867EE-E4EC-F541-AECF-FA3E4FE868D3. 84 + 85 + 86 +* Begin EG generated code (do not edit this line); 87 +;*';*";*/;quit; 88 + 89 +proc printto ; 90 +run ;