topic Re: Is it possible to modify the "View in Excel" context menu command output formatting? in SAS Programming

Is it possible to modify the "View in Excel" context menu command output formatting?

eshupp — Mon, 28 Jun 2021 16:03:44 GMT

I frequently use the "View in Excel" right click context menu command to view files in the SAS Windows UI but would like to get rid of titles and column labels so that i can see the variable names instead of the labels. I can eliminate the titles by submitting a title; prior to the view command but have not been able to eliminate the generation of labels. Is there any way to modify the process to do this short of modifying the dataset? Another oddity is that when labels are generated they are in multiple rows rather than in a single row.

Re: Is it possible to modify the "View in Excel" context menu command output formatting?

Reeza — Mon, 28 Jun 2021 16:08:56 GMT

I don't know if it's possible to change the GUI command but you can control all of that if you do it via code rather than the GUI.

Use either ODS EXCEL or PROC EXPORT - EXPORT Is likely closer to what you want.

proc export data=sashelp.class outfile='/home/fkhurshed/Class.xlsx' dbms=xlsx replace; run;

@eshupp wrote:

I frequently use the "View in Excel" right click context menu command to view files in the SAS Windows UI but would like to get rid of titles and column labels so that i can see the variable names instead of the labels. I can eliminate the titles by submitting a title; prior to the view command but have not been able to eliminate the generation of labels. Is there any way to modify the process to do this short of modifying the dataset? Another oddity is that when labels are generated they are in multiple rows rather than in a single row.

Re: Is it possible to modify the "View in Excel" context menu command output formatting?

eshupp — Fri, 02 Jul 2021 12:01:28 GMT

Thanks for the alternative suggestion. After some additional thought I determined that if I submit the following before doing a view the output is formatted the way I want:

TITLE;

OPTIONS NOLABEL;

This is an accep

Re: Is it possible to modify the "View in Excel" context menu command output formatting?

eshupp — Wed, 29 Sep 2021 14:31:10 GMT

I solved my problem by submitting OPTIONS NOTITLE; TITLE; before performing "View in Excel".

Re: Is it possible to modify the "View in Excel" context menu command output formatting?

Tom — Wed, 29 Sep 2021 15:08:16 GMT

You can customize how Explorer works in Display Manager.

Here is what the current entry that you are using looks like:

Looks like it is currently calling some SCL program that SAS supplied.

AFA C=SASHELP.EXPLORER.EXCEL_TABLE_OPEN.SCL LIBRARY='%8b' TABLE='%32b';

You probably cannot change that program. It is not clear if it has a option to NOT use the labels.

But you could always either associate this menu item with a different command or make a new menu item that does what you want.