Almost!! But I think we are getting somewhere.
Removed the Package result capability.
First, I had to add a third proc print for reasons you will soon understand.
ods _all_ close;
ods Excel file=_webout options(sheet_name='Class');
proc print data=sashelp.class; run; quit;
ods excel options(sheet_name='Cars');
proc print data=sashelp.cars; run; quit;
ods excel options(sheet_name='Airline');
proc print data=sashelp.airline; run; quit;
ods Excel close;
Doesn't matter where I specify my result output I get two outputs in Excel.
If I select "new workbook" the first output is a new workbook called Workbook8 (or 5, 6, 7 in previous tests, just regular name for new workbook), with one sheet called "Stored Process for teste" and with the "Class" data in it. This is just a opened Excel, there are no files and I have to save it to keep it.
If I select "new worksheet" and specify its name I get the same result in a new worksheet. If I specify a range the same result in the specified range.
The other output is called "Main.html". It opens in Excel and it has two sheets called "Cars" and "Airlines" with their respective data. This one is an html file saved in a temporary folder "\<user>\Documents\My SAS Files\Add-In for Microsoft Office\_SOA_A5XKMNSB.BC0003I6_601538504"
In the same folder there is a file called "main.log" that I pasted here, maybe it will give you some insight.
As a last note, I tried deleting the Data Targets output stream, but it changed nothing.
t11 The SAS System 14:03 Friday, December 14, 2018
t
n NOTE: Copyright (c) 2016 by SAS Institute Inc., Cary, NC, USA.
n NOTE: SAS (r) Proprietary Software 9.4 (TS1M5)
n Licensed to TRIBUNAL DE CONTAS DA UNIAO, Site 70200868.
n NOTE: This session is executing on the Linux 4.1.12-124.16.3.el7uek.x86_64 (LIN X64) platform.
d
d
d
n NOTE: Updated analytical products:
n
n SAS/STAT 14.3
n SAS/ETS 14.3
n
n NOTE: Additional host information:
n
n Linux LIN X64 4.1.12-124.16.3.el7uek.x86_64 #2 SMP Wed Jun 13 07:40:34 PDT 2018 x86_64 Oracle Linux Server release 7.5
n
d You are running SAS 9. Some SAS 8 files will be automatically converted
d by the V9 engine; others are incompatible. Please see
d http://support.sas.com/rnd/migration/planning/platform/64bit.html
d
d PROC MIGRATE will preserve current SAS file attributes and is
d recommended for converting all your SAS libraries from any
d SAS 8 release to SAS 9. For details and examples, please see
d http://support.sas.com/rnd/migration/index.html
d
d
d This message is contained in the SAS news file, and is presented upon
d initialization. Edit the file "news" in the "misc/base" directory to
d display site-specific news and information in the program log.
d The command line option "-nonews" will prevent this display.
d
d
d
d
n NOTE: SAS Initialization used (Total process time):
n real time 0.00 seconds
n cpu time 0.00 seconds
n
n NOTE: The autoexec file, /sasconfig/Lev1/SASApp/WorkspaceServer/autoexec.sas, was executed at server initialization.
d
d >>> SAS Macro Variables:
d
d SYSDBMSG=ODBC: [DataDirect][ODBC lib] Data source name not found and no default driver specified
d SYSDBRC=IM002
d
d _APSLIST=_RESULT,_CLIENTVERSION,_CLIENTMACHINE,_ODSDEST,_ODSSTYLESHEET,_ODSOPTIONS,_TIMEZONE,_GOPT_DEVICE,_CLIENTUSERID,_MSOFFICECLI
d ENT,_CLIENTNAME,_CLIENTUSERNAME,_METAUSER,_ODSM_SR_RAW,_ENCODI
d NG,_ODSSTYLE,_METAPERSON,_METAFOLDER,_PROGRAM,_CLIENT,_USERNAME,_SECUREUSERNAME
d _CLIENT=SAS Add-In for Microsoft Office; CLR 4.0.30319.42000; Microsoft Windows NT 6.1.7601 Service Pack 1
d _CLIENTMACHINE=E-087408
d _CLIENTNAME=SAS Add-In for Microsoft Office
d _CLIENTUSERID=antonaci
d _CLIENTUSERNAME=Giuseppe de Abreu Antonaci
d _CLIENTVERSION=7.100.5.6165
d _ENCODING=UTF8
d _GOPT_DEVICE=ACTIVEX
d _METAFOLDER=/User Folders/antonaci(1)/My Folder/
d _METAPERSON=antonaci
t12 The SAS System 14:03 Friday, December 14, 2018
t
d _METAUSER=antonaci
d _MSOFFICECLIENT=Excel
d _ODSDEST=tagsets.sasreport13
d _ODSM_SR_RAW=on
d _ODSOPTIONS=options(rolap="on")
d _ODSSTYLE=EGDefault
d _ODSSTYLESHEET=(URL="file:///D:/Program%20Files/SASHome/x86/SASAddinforMicrosoftOffice/7.1/Styles/AMODefault.css")
d _PROGRAM=/User Folders/antonaci(1)/My Folder/Stored Process for teste
d _REPLAY="&_URL?_sessionid=00000000-0000-0000-0000-000000000000&_program=replay&_entry=&_TMPCAT.."
d _RESULT=STREAM
d _SECUREUSERNAME=(Process)
d _TIMEZONE=GMT-02:00
d _TMPCAT=APSWORK.TCAT0000
d _USERNAME=(Process)
d
n NOTE: %INCLUDE (level 1) file /sasdata/usuarios/antonaci/Credibilidade_teste/Stored_Process_for_teste.sas is file /sasdata/usuarios/antonaci/Credibilidade_teste/Stored_Process_for_teste.sas.
s 3 +ods _all_ close;
s 4 +
s 5 +ods Excel file=_webout options(sheet_name='Class');
t1 The SAS System
t
s 6 +
s 7 +
s 7 !+ proc print data=sashelp.class; run;
n
n NOTE: There were 19 observations read from the data set SASHELP.CLASS.
n NOTE: PROCEDURE PRINT used (Total process time):
n real time 0.05 seconds
n cpu time 0.05 seconds
n
n
s 7 !+ quit;
s 8 +
s 9 +ods excel options(sheet_name='Cars');
s 10 +
s 11 +
s 11 !+ proc print data=sashelp.cars; run;
n
n NOTE: There were 428 observations read from the data set SASHELP.CARS.
n NOTE: PROCEDURE PRINT used (Total process time):
n real time 2.36 seconds
n cpu time 2.37 seconds
n
n
s 11 !+ quit;
s 12 +
s 13 +ods excel options(sheet_name='Airline');
s 14 +
s 15 +
s 15 !+ proc print data=sashelp.airline; run;
n
n NOTE: There were 144 observations read from the data set SASHELP.AIRLINE.
n NOTE: PROCEDURE PRINT used (Total process time):
n real time 0.24 seconds
n cpu time 0.25 seconds
n
n
s 15 !+ quit;
s 16 +
t1 The SAS System
t
s 17 +ods
