export to specific excel sheet from unix without overwriting file?

[birdcity]

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;

[Kurt_Bremser · Accepted solution]

Use libname xlsx, you can then write a sheet as if it was a dataset.

[birdcity]

wow thats great 😄