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!
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
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.
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:
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.
Ready to level-up your skills? Choose your own adventure.