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:
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.