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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.