topic Re: EXCEL EXPORT in SAS Programming

EXCEL EXPORT

Woop122 — Thu, 22 Jun 2017 20:53:00 GMT

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.

Re: EXCEL EXPORT

Yavuz — Thu, 22 Jun 2017 21:07:22 GMT

as i understand "odds ratios" sheet has been already created in excel. firstly change your code and Replace sheet name as "my_data". Then get figures from "my_data" sheet to "odds ratios" sheet in excel by creating cell link.

Re: EXCEL EXPORT

Reeza — Thu, 22 Jun 2017 22:51:35 GMT

Try creating a named range and then exporting to the named range.