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 😄
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.