Is there a way to export to a specific worksheet from UNIX, and not destroy the entire workbook in the process? I am basically trying to replace the 'data' worksheet in a workbook, but keep the pivot layout? This code works to export to my directory, but the sheets besides the 'Data' sheet are gone (because SAS is creating a completely new xlsx file? Otherwise I guess I need to rsubmit to a windows sas instance? Thanks proc export data=data_file dbms=xlsx replace outfile='/test/text.xlsx'; sheet=Data; run;
... View more
