cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
vikaskubde
‎11-29-2022
  • 14 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Need to print two datasets side by side in one excel sheet

by Calcite | Level 5 in ODS and Base Reporting
‎11-02-2018 02:25 PM
‎11-02-2018 02:25 PM
So is there any option to print two data sets in same excel sheet side by side. ... View more

Re: Need to print two datasets side by side in one excel sheet

by Calcite | Level 5 in ODS and Base Reporting
‎11-02-2018 12:28 PM
‎11-02-2018 12:28 PM
Ods excel file='d:/report.xlsx'; Ods excel options(sheet_name='one' sheet_interval='none'); Proc print data=class; Run; Ods excel options(sheet_name='two' start_at='4,5') Proc print data=cars; Run; Ods excel close; ... View more

Re: Need to print two datasets side by side in one excel sheet

by Calcite | Level 5 in ODS and Base Reporting
‎11-02-2018 11:34 AM
‎11-02-2018 11:34 AM
Start_at= option does not seem to be working? Is there anyway it can be done in ODS Excel? Please let me know. Any help will be very much appreciated. Thank you, vikas ... View more

Need to print two datasets side by side in one excel sheet

by Calcite | Level 5 in ODS and Base Reporting
‎11-02-2018 11:16 AM
‎11-02-2018 11:16 AM
I have 2 tables and I need to export both tables in same worksheet side by side, not one below another. I used sheet_interval='name It gives me the result one below another, however I need output side by side in same sheet. I also tried with start_at option as well, but not getting the desire output. ... View more

Re: How to enable data tips for graph in ods excel

by Calcite | Level 5 in ODS and Base Reporting
‎11-02-2018 10:49 AM
‎11-02-2018 10:49 AM
Okay, please let me know once you find the solution. Thanks, Vikas ... View more

Re: How to enable data tips for graph in ods excel

by Calcite | Level 5 in ODS and Base Reporting
‎11-01-2018 02:49 PM
‎11-01-2018 02:49 PM
So you mean there is no option to enable data tips for graphs in ods excel. ... View more

Re: How to enable data tips for graph in ods excel

by Calcite | Level 5 in ODS and Base Reporting
‎11-01-2018 10:38 AM
‎11-01-2018 10:38 AM
I have code like: Ods excel file="d:/report.xlsx"; Proc split data=work.sorttemptablesorted; Plot ib*week mn*week hm*week/ overlay Grid vaxis=axis1 haxis=axis2 ; Run; Ods excel close; In the result window it showing the related graph and data tips as well. However, when I open the report.xlsx from destination, it is showing the graph but it is not showing the data tips over graph in excel. ... View more

Re: How to enable data tips for graph in ods excel

by Calcite | Level 5 in ODS and Base Reporting
‎11-01-2018 10:26 AM
‎11-01-2018 10:26 AM
Do we have any option to show the data tips on graph in SAS, after exporting a graph in excel using ods excel ... View more

Re: How to enable data tips for graph in ods excel

by Calcite | Level 5 in ODS and Base Reporting
‎11-01-2018 10:16 AM
‎11-01-2018 10:16 AM
There is a graphics option "imagemap=on" for ods html. However this option is not applicable with ods excel. ... View more

Re: Problem after exporting data using ODS Excel

by Calcite | Level 5 in ODS and Base Reporting
‎08-10-2018 11:18 PM
‎08-10-2018 11:18 PM
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 ... View more

Re: Problem after exporting data using ODS Excel

by Calcite | Level 5 in ODS and Base Reporting
‎08-10-2018 11:09 PM
‎08-10-2018 11:09 PM
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 ... View more

Re: Problem after exporting data using ODS Excel

by Calcite | Level 5 in ODS and Base Reporting
‎08-01-2018 06:28 AM
‎08-01-2018 06:28 AM
I am using SAS 9.4 ... View more

Problem after exporting data using ODS Excel

by Calcite | Level 5 in ODS and Base Reporting
‎07-29-2018 09:20 AM
‎07-29-2018 09:20 AM
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 ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-29-2022 07:26 AM
Group Hubs for vikaskubde
View All
Likes given to
View All
Quick links