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 😄
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.