PROC EXPORT
DATA=ODDSRATIOS_COMBINED
DBMS=XLSX
OUTFILE = "FILE PATH"
REPLACE;
SHEET = 'ODDS RATIOS';
RUN;
I keep getting an error that says cannot replace sheet because it has existing formulas that reference other pages
ERROR: export unsuccessful.
I know there's a hot fix available but I can't download it because of the server I'm working on. Is there any way around this problem?
I need to be able to update the exported excel file w/ different iterations without deleting the sheet and re-creating the formulas each time.
Try creating a named range and then exporting to the named range.
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.