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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.