BookmarkSubscribeRSS Feed
Obsidian | Level 7

I have 30+ years of SAS programming experience (hello TSO/MVS!!) but am a total neophyte when it comes to SAS  Studio (but I like it). in the SAS PC version, when listing the data-sets, you can right click on a data-set and there is an option to immediately export to Excel. Is there such an option in Studio? If so, would someone please kindly point me to where it can be found?


I don't need to write code, I just want a quick export.



Barite | Level 11

I know you like SAS studio and far be it for me to suggest the old boring text editor, but I can highlight a dataset in the old text editor, hit a function key or type xlsh on the command line an excel will popup with the dataset. I can then save it anywhere. You could type xlsl on the command line to open the last dataset created in excel. Obviously you can easily tailor the commnd macro to do other things.


Here is the macro


I have attached a zip file that will demonstrates some function key settings and some command macros that are helpful.


I do have some additional command line capabilitues like 'EVLH' which will evaluate any highlighted formula line 2*3+6.


You need the old text editor because key SAS scripting capabilities have been removed in all subsequent editors, ir EE, EG, and SAS Studio (most notable the 'save' command.


%macro xlsh /cmd ;
   store;note;notesubmit '%xlsha;';
%mend xlsh;

%macro xlsha/cmd;

    filename clp clipbrd ;
    data _null_;
     infile clp;
     put _infile_;
     call symputx('argx',_infile_);

    %let __tmp=%sysfunc(pathname(work))\myxls.xlsx;

    data _null_;
        rc=filename(fname, "&__tmp");
        put rc=;
        if rc = 0 and fexist(fname) then

    libname __xls excel "&__tmp";
    data __xls.%scan(__&argx,1,%str(.));
        set &argx.;
    libname __xls clear;

    data _null_;z=sleep(1);run;quit;

    options noxwait noxsync;
    /* Open Excel */
    x "'C:\Program Files\Microsoft Office\OFFICE14\excel.exe' &__tmp";

%mend xlsha;
Obsidian | Level 7

Thanks Roger - I'll try it. Even though I frankly prefer the text editor (DOS girl here!!), I need to brush up on my macro code so I'll give it a try.


Appreciate the relly




SAS Studio 3.5

In the Libraries Drawer use the RightMouseButton and you get a menu item to export the data, see also below




Obsidian | Level 7
Thanks Bruno - SWEET. I'll give Roger's answer a try too - can't have too many tools in the SAS arsenal.
Quartz | Level 8

When I try Bruno's option from SAS Studio it saves it to the SAS server file system, which in my case is remote.


Was hoping it would trigger a download...

Obsidian | Level 7

You can then browse to the file and right click and click save to trigger the download. It's an extra step, but it works. It would be nice if there would be a button that does this automatically in the output.

Calcite | Level 5

I exported a very simple dataset to a .csv file.  I want to use this data in excel to make a simple scatter plot graph.  But for some reason when the data comes from SAS, excel does not want to draw a graph?  Can anybody help?


Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.


Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 7 replies
  • 6 in conversation