save data sets into XLSX files in sas screen

[Ronein]

Hello

I have 3 data sets and I want to put them in XLSX file.

The issue is that I don't want to save the XLSX files in my computer .

I want that the XLSX files will be shown in SAS screen(process flow screen) and then I will mark them and make copy and paste them in the location that I want.

What is the way to do it please?

Let's say that the 3 data sets that I want to create in XLSX are:

SASHELP.cars

SASHELP.class

SASHELP.baseball

[Tom]

Your question does make any sense.  If you want SAS to write an XLSX file then the file will be written on the machine where SAS runs.  The files have nothing to do with what is on your screen, unless your screen is showing you the files that you have written.

[Ronein]

Excatly! I want that the XLSX file will be written on the machine where SAS runs.

For example: I want to save data set cars in XLSX file that will be written on SAS .

May you please show how to do it please?

Data cars;
set sashelp.cars;
Run;

[Tom · Accepted solution]

I have no idea how to deal with "work flows" but if you want to write a xlsx file to the WORK directory then just write the code that way.

proc export dbms=xlsx data=sashelp.class
  file="%sysfunc(pathname(work))/class.xlsx" replace
;
run;

If you want to download files in Enterprise Guide then I think there is a separate TASK that you can use for that.

[andreas_lds]

Afaik this is not possible in the "sas screens" i am more or less familiar with: Enterprise Guide, SAS Studio and Display Manager.

It is difficult to suggest a solution without knowing the complete process.

[Ronein]

 I will try to explain again,

I want to put the data set in XLSX file .

I dont want to save the XLSX file .

I want that the XLSX file will be in work library (or similar temporary library)

It means that when sas session end then the XLSX file will not be saved

The XLSX file should be seen in process flow and from there I can copy it (right click and copy) and paste it in any location that I want