topic Re: Problem after exporting data using ODS Excel in ODS and Base Reporting

Problem after exporting data using ODS Excel

vikaskubde — Sun, 29 Jul 2018 13:20:25 GMT

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

Re: Problem after exporting data using ODS Excel

Tom — Mon, 30 Jul 2018 04:01:44 GMT

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.

Re: Problem after exporting data using ODS Excel

SuzanneDorinski — Wed, 01 Aug 2018 00:08:31 GMT

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 are produced

Re: Problem after exporting data using ODS Excel

vikaskubde — Wed, 01 Aug 2018 10:28:02 GMT

I am using SAS 9.4

Re: Problem after exporting data using ODS Excel

vikaskubde — Sat, 11 Aug 2018 03:09:34 GMT

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

Re: Problem after exporting data using ODS Excel

vikaskubde — Sat, 11 Aug 2018 03:18:39 GMT

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