tried that, noticing this error at the end i dont understand.
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 774.62k
OS Memory 32672.00k
Timestamp 2020/10/09 07:37:58 PM
Step Count 8621 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 773.71k
OS Memory 32672.00k
Timestamp 2020/10/09 07:37:58 PM
Step Count 8622 Switch Count 0
Page Faults 0
Page Reclaims 2
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 1
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 774.62k
OS Memory 32672.00k
Timestamp 2020/10/09 07:37:58 PM
Step Count 8623 Switch Count 0
Page Faults 0
Page Reclaims 3
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 1
Block Input Operations 0
Block Output Operations 0
77 +ODS excel FILE=_webout style=plateau OPTIONS(SHEET_NAME="Class");
78 +proc print data=SASHELP.CLASS; run;
NOTE: There were 19 observations read from the data set SASHELP.CLASS.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.04 seconds
user cpu time 0.04 seconds
system cpu time 0.00 seconds
memory 1837.87k
OS Memory 40388.00k
Timestamp 2020/10/09 07:37:58 PM
Step Count 8624 Switch Count 0
Page Faults 0
Page Reclaims 317
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 7
Block Input Operations 0
Block Output Operations 0
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=SASHELP.RETAIL; run;
NOTE: There were 58 observations read from the data set SASHELP.RETAIL.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.10 seconds
user cpu time 0.10 seconds
system cpu time 0.01 seconds
memory 1714.31k
OS Memory 41668.00k
Timestamp 2020/10/09 07:37:59 PM
Step Count 8625 Switch Count 0
Page Faults 0
Page Reclaims 374
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 9
Block Input Operations 0
Block Output Operations 0
81 !+ quit;
82 +
83 +ods excel close ;
NOTE: Writing EXCEL file: ./3F9A708B-5F2B-BD4C-AE18-EABD74948E86
ERROR: Physical file does not exist, /grid/config/Lev1/SASApp/3F9A708B-5F2B-BD4C-AE18-EABD74948E86.
84 +
85 +
86 +* Begin EG generated code (do not edit this line);
87 +;*';*";*/;quit;
88 +
