The SAS Output Delivery System and reporting techniques

proc export issue

Accepted Solution Solved
Reply
Regular Contributor
Posts: 152
Accepted Solution

proc export issue

[ Edited ]

Hi Experts,

I am getting error message:

Can not replace sheet because it has existing formulas that reference other pages

when I export the data into an Excel file.

I understand the reason why it has generated the error but would like to know if there is a work around?

 

 

Thanks


Accepted Solutions
Solution
‎04-14-2016 01:11 AM
Super User
Posts: 17,818

Re: proc export issue

Can you explain further?

 

How are you exporting your data? To a pre-populated excel workbook? 

 

If you have formula's can you use ods tagsets and put the formula's back in?

 

Have you dropped the information first?

 

 

 

 

View solution in original post


All Replies
Solution
‎04-14-2016 01:11 AM
Super User
Posts: 17,818

Re: proc export issue

Can you explain further?

 

How are you exporting your data? To a pre-populated excel workbook? 

 

If you have formula's can you use ods tagsets and put the formula's back in?

 

Have you dropped the information first?

 

 

 

 

Regular Contributor
Posts: 152

Re: proc export issue

thanks problem solved!!!!!!

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 706 views
  • 0 likes
  • 2 in conversation