BookmarkSubscribeRSS Feed
abunte
Calcite | Level 5

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!

3 REPLIES 3
AMSAS
SAS Super FREQ

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"

 

AMSAS_0-1656511955811.png


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

abunte
Calcite | Level 5

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. 

 

 

 

Tom
Super User Tom
Super User

It is definitely there ins SAS 9.4M5.

Tom_0-1656517944242.png

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

Tom_1-1656518060720.png

 

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1852 views
  • 0 likes
  • 3 in conversation