PBALL
problem is rsubmit
excelxp works only "locally"
you could create the xml on the remote server (put the ods tagsets statements inside the rsubmit block), and arrange "delivery" of the xml in any of a variety of ways, .
> rsubmit;
> ods tagsets.excelxp file="%SYSFUNC(PATHNAME(WORK))/Extract.xml" RS=NONE
> style=minimal ;
>
> proc tabulate data = miu;
> class stat_typ umony;
> table stat_typ, umony*(N*F=5.)
> /rts =5 nocontinued;
>
>
> run;
>
> ods _all_ close;
PROC DOWNLOAD INFILE= "%SYSFUNC(PATHNAME(WORK))/Extract.xml"
OUTFILE= 'y:\Extract.xml' ;
RUN ;
> endrsubmit;
UNFORTUNATELY, handling remote servers on z/OS is less easy to equate to remote server handling for unix or windows platforms, so the above is not good enoughif your remote server is on z/OS. (if you don't know the server platorm, check by submitting
rsubmit ; %put &sysscp &sysscpL &sysVLong ; endrsubmit ;
Alternatively, you could use remote library services to create your xml in the local session, like:
%let rserver = %sysfunc( getoption(remote)) ;
libname rwork remote slibref= work server= &rserver ;
> ods tagsets.excelxp file='y:\Extract.xml' style=minimal ;
proc tabulate data = RWORK.miu;
> class stat_typ umony;
> table stat_typ, umony*(N*F=5.)
> /rts =5 nocontinued;
>
>
> run;
>
> ods _all_ close;
LIBNAME RWORK ;