topic Re: save data sets into XLSX files in sas screen in SAS Programming

save data sets into XLSX files in sas screen

Ronein — Sun, 27 Mar 2022 20:03:33 GMT

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

Re: save data sets into XLSX files in sas screen

Tom — Sun, 27 Mar 2022 22:23:04 GMT

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.

Re: save data sets into XLSX files in sas screen

andreas_lds — Mon, 28 Mar 2022 09:06:53 GMT

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.

Re: save data sets into XLSX files in sas screen

Ronein — Mon, 28 Mar 2022 13:17:36 GMT

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

Re: save data sets into XLSX files in sas screen

Ronein — Mon, 28 Mar 2022 13:20:08 GMT

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;

Re: save data sets into XLSX files in sas screen

Tom — Mon, 28 Mar 2022 13:24:20 GMT

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.