topic Re: "Export to Excel" option in right click menu gone after software update in SAS Programming

"Export to Excel" option in right click menu gone after software update

abunte — Wed, 29 Jun 2022 08:08:59 GMT

Hi everyone,

I am working with SAS 9.4 TS Level 1M6 on Windows Version 1.0.18362. Until last week, SAS was working and I could export my results to excel by using the right click menu.

Over the weekend, my software upated and this week I lust this option. I am not sure if the two are related, but it seems likely given that it worked before. Can anyone tell me what to do to get it back? I tried to reinstall SAS with no success.

Thanks for your help!

Re: "Export to Excel" option in right click menu gone after software update

AMSAS — Wed, 29 Jun 2022 14:14:12 GMT

The right mouse click (Mouse Menu Select) is context-sensitive, without knowing what you right mouse on, it is difficult to suggest a solution.

For example below I right mouse click on a SAS Dataset (sashelp.cars) in the SAS Explorer and I have an option to "View in Excel"

If you can provide some additional information then someone will be more likely to assist you.

Alternatively, you can open a TS track:.

Please include the following:
- SAS Version you are running (the following code will report SAS version information)
%put &sysvlong ;
%put &sysscpl ;
%put &syssite ;
- Registry Report (*.txt files) for each server, please clearly name the report files to reflect the server it was executed on.
- Detailed description of the issue you are encountering
- Any supporting log files containing errors

Re: "Export to Excel" option in right click menu gone after software update

abunte — Wed, 29 Jun 2022 15:44:32 GMT

Thanks for getting back to me.

I am missing the "Export to Excel" function when right-clicking on output from an SQL inquery. Something like:

proc sql; select name from source where name eq "X";quit;

The Result Viewer would show me a table of output, which I used to be able to export to excel.

Re: "Export to Excel" option in right click menu gone after software update

Tom — Wed, 29 Jun 2022 15:54:37 GMT

It is definitely there ins SAS 9.4M5.

Of course if you want to generate a Excel file you could have just done that to start with: