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
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.
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.
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
Are you using SAS 9.4 maintenance release 3? If so, there is a hot fix.
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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.