The SAS Output Delivery System and reporting techniques

export to specific excel sheet from unix without overwriting file?

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

export to specific excel sheet from unix without overwriting file?

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;

 

 


Accepted Solutions
Solution
‎02-20-2017 06:02 PM
Esteemed Advisor
Posts: 6,646

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

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Solution
‎02-20-2017 06:02 PM
Esteemed Advisor
Posts: 6,646

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

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
New Contributor
Posts: 2

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

wow thats great Smiley Very Happy

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 121 views
  • 0 likes
  • 2 in conversation