The SAS Output Delivery System and reporting techniques

Problem after exporting data using ODS Excel

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

Problem after exporting data using ODS Excel

Hello Team,

 

I have a formated ODS Excel code to export data.

I exported it successfully using ODS Excel.

The problem I am facing that when I open that exported file from the location and write some text manually in sheet 1, the same is reflecting on each sheet.

I need to write something on sheet 1 before sending it to the client.

Please provide the solution to this problem.

 

see the attached file here.

 

Thanks in advance,

With kind regards,

Vikas


Accepted Solutions
Solution
Friday
Super User
Super User
Posts: 8,261

Re: Problem after exporting data using ODS Excel

[ Edited ]
Posted in reply to vikaskubde

This has come up before on this forum. The problem is that ODS has somehow created a workbook where the sheets are linked or grouped together.  I forget the Excel terminology for this type of linkage and what the right solution was. 

 

Try searching this forum for your problem.

 

If nothing else just open the workbook and un-link the sheets before editing any of the values.

View solution in original post


All Replies
Solution
Friday
Super User
Super User
Posts: 8,261

Re: Problem after exporting data using ODS Excel

[ Edited ]
Posted in reply to vikaskubde

This has come up before on this forum. The problem is that ODS has somehow created a workbook where the sheets are linked or grouped together.  I forget the Excel terminology for this type of linkage and what the right solution was. 

 

Try searching this forum for your problem.

 

If nothing else just open the workbook and un-link the sheets before editing any of the values.

New Contributor
Posts: 4

Re: Problem after exporting data using ODS Excel

Thanks, Tom 

It is okay to ungroup worksheet manually in Excel (right click sheet and click Ungroup sheets).

However, I need the solution in SAS.

Can we implement the SAS code for Ungroup the worksheet in ODS Excel?

Greatly appreciate if we have a solution to it in SAS.

Thanks in advance,

Vicky

Frequent Contributor
Posts: 123

Re: Problem after exporting data using ODS Excel

Posted in reply to vikaskubde

Are you using SAS 9.4 maintenance release 3?  If so, there is a hot fix.  

 

Problem Note 56878: The ODS destination for Excel generates grouped worksheets when multiple sheets ...

New Contributor
Posts: 4

Re: Problem after exporting data using ODS Excel

Posted in reply to SuzanneDorinski
I am using SAS 9.4
New Contributor
Posts: 4

Re: Problem after exporting data using ODS Excel

Posted in reply to SuzanneDorinski

Hello Suzanne,

I am using SAS version 9.4 M3.

Is it any solution of Ungroup worksheet in SAS version M3?

Thanks in advance,

Vicky

☑ This topic is solved.

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

Discussion stats
  • 5 replies
  • 176 views
  • 1 like
  • 3 in conversation