https://communities.sas.com/t5/SAS-Procedures/quot-View-in-Excel-quot-right-click-fly-out-menu-from-Explorer/m-p/51604#M14160 Version 9 -- does anyone know how to suppress the "SAS" header that defaults in the Excel output when right-clicking on a dataset in the Explorer pane and clicking "View in Excel"? Mon, 06 Jul 2009 16:06:18 GMT deleted_user 2009-07-06T16:06:18Z https://communities.sas.com/t5/SAS-Procedures/quot-View-in-Excel-quot-right-click-fly-out-menu-from-Explorer/m-p/51604#M14160 Version 9 -- does anyone know how to suppress the "SAS" header that defaults in the Excel output when right-clicking on a dataset in the Explorer pane and clicking "View in Excel"? Mon, 06 Jul 2009 16:06:18 GMT https://communities.sas.com/t5/SAS-Procedures/quot-View-in-Excel-quot-right-click-fly-out-menu-from-Explorer/m-p/51604#M14160 deleted_user 2009-07-06T16:06:18Z https://communities.sas.com/t5/SAS-Procedures/quot-View-in-Excel-quot-right-click-fly-out-menu-from-Explorer/m-p/51605#M14161 replicate the code being generated and add that ods option which puts a title on the html page. there are examples around. <BR /> See Richard Devenezia's web site section "Actions" on <BR /> <A href="http://www.devenezia.com" target="_blank">http://www.devenezia.com</A>. The whole site is good value, but you can go straight to the section about these SAS Explorer Actions via <A href="http://www.devenezia.com/downloads/sas/actions/" target="_blank">http://www.devenezia.com/downloads/sas/actions/</A> . It was a few years ago I was seeking such explorer behaviour so there might be some more sites now.<BR /> These "actions" must be commands, but the GSUBMIT "string" command submits "string" like a statement.<BR /> <BR /> good luck <BR /> enjoy extending your working environment with behaviour of <B>your choice!</B><BR /> <BR /> PeterC Tue, 07 Jul 2009 07:05:00 GMT https://communities.sas.com/t5/SAS-Procedures/quot-View-in-Excel-quot-right-click-fly-out-menu-from-Explorer/m-p/51605#M14161 Peter_C 2009-07-07T07:05:00Z https://communities.sas.com/t5/SAS-Procedures/quot-View-in-Excel-quot-right-click-fly-out-menu-from-Explorer/m-p/51606#M14162 Hi Peter -- I'm not sure exactly what piece of code is needed to suppress that SAS header line. What I simply want to do is right-click on the dataset in the Explorer pane &gt; "View in Excel" and then have the dataset output without the SAS header line. I did look in your documents and not quite sure if I need to go the ODS route? Does that mean I wouldn't do the right-click anymore? Wed, 08 Jul 2009 17:41:51 GMT https://communities.sas.com/t5/SAS-Procedures/quot-View-in-Excel-quot-right-click-fly-out-menu-from-Explorer/m-p/51606#M14162 deleted_user 2009-07-08T17:41:51Z https://communities.sas.com/t5/SAS-Procedures/quot-View-in-Excel-quot-right-click-fly-out-menu-from-Explorer/m-p/51607#M14163 sorry, can't respond before middle of next week. Hope some other will be able to help if you need it before then. Those "actions" create behaviour and notes in online doc as well as thatr site tell you how to pass information from explorer into the action. Create a macro with parameters fed from the explorer ..... more next week Wed, 08 Jul 2009 22:23:15 GMT https://communities.sas.com/t5/SAS-Procedures/quot-View-in-Excel-quot-right-click-fly-out-menu-from-Explorer/m-p/51607#M14163 Peter_C 2009-07-08T22:23:15Z