topic export to specific excel sheet from unix without overwriting file? in ODS and Base Reporting

export to specific excel sheet from unix without overwriting file?

birdcity — Mon, 20 Feb 2017 22:53:34 GMT

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;

Re: export to specific excel sheet from unix without overwriting file?

Kurt_Bremser — Mon, 20 Feb 2017 22:56:14 GMT

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

Re: export to specific excel sheet from unix without overwriting file?

birdcity — Mon, 20 Feb 2017 23:06:18 GMT

wow thats great 😄