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;
Use libname xlsx, you can then write a sheet as if it was a dataset.
Use libname xlsx, you can then write a sheet as if it was a dataset.
wow thats great 😄
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.