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

 

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
  • 1989 views
  • 0 likes
  • 3 in conversation