topic Re: in memory/work/pc path in SAS Programming

in memory/work/pc path

Ronein — Mon, 28 Mar 2022 13:58:41 GMT

Hello

I want to ask a question about export SAS data set into XLSX file.

What is the difference between:

1- save the file in memory ?

2-save the file in work directory

3-save the file in computer path

thanks

Re: in memory/work/pc path

SASKiwi — Mon, 28 Mar 2022 19:25:34 GMT

1- save the file in memory ?

You can't export a SAS dataset to an Excel XLSX file in memory. It has to be on disk. Once on disk, use Excel to open the workbook and that loads it into memory.

2-save the file in work directory

I assume you mean the SAS WORK directory here? Run this to find out where it is:

%put %sysfunc(pathname(WORK));

3-save the file in computer path

Save the file to a particular folder on disk.

Re: in memory/work/pc path

PaigeMiller — Mon, 28 Mar 2022 19:52:14 GMT

@Ronein wrote:

I want to ask a question about export SAS data set into XLSX file.

What is the difference between:

1- save the file in memory ?

2-save the file in work directory

3-save the file in computer path

1- no such thing

2 vs 3 ... different folder on one of your hard disks or network disks

Re: in memory/work/pc path

Ronein — Mon, 28 Mar 2022 19:52:22 GMT

Thanks,

In previous post it was said that I can export sas data set into XLSX file that will be "saved" in work library.

As I see you said that it cannot be done?

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

Re: in memory/work/pc path

PaigeMiller — Mon, 28 Mar 2022 19:56:10 GMT

You can export a SAS data set as an .xlsx file to ANY folder you have write permission to, including the folder assigned to the WORK library in SAS.

So what is your real question?

Re: in memory/work/pc path

Ronein — Mon, 28 Mar 2022 20:04:25 GMT

Thanks,
Should I have special permission in order to export sas data set into XLS file in work library?
How can I know If i have this permission?

I was sure that work library is only for sas data sets and now I understand that I can save there also XLSX files that were created from sas data sets?

Re: in memory/work/pc path

Kurt_Bremser — Mon, 28 Mar 2022 20:08:03 GMT

By definition, you have complete read/write/execute permission on your WORK directory, otherwise it would be of no use. You need these permissions to create datasets there, and retrieve a library listing.

Re: in memory/work/pc path

SASKiwi — Mon, 28 Mar 2022 20:10:28 GMT

Saving XLSX files in your SAS work directory is not a good idea as this is deleted at the end of your SAS session.

Re: in memory/work/pc path

Tom — Mon, 28 Mar 2022 20:12:53 GMT

@SASKiwi wrote:

Saving XLSX files in your SAS work directory is not a good idea as this is deleted at the end of your SAS session.

Depends on what you are trying to do.

Saving XLSX files in your SAS work directory IS a GOOD idea BECAUSE this is deleted at the end of your SAS session.

Re: in memory/work/pc path

PaigeMiller — Mon, 28 Mar 2022 20:15:49 GMT

@Ronein wrote:

Thanks,
Should I have special permission in order to export sas data set into XLS file in work library?
How can I know If i have this permission?

I was sure that work library is only for sas data sets and now I understand that I can save there also XLSX files that were created from sas data sets?

The WORK library is in a folder somewhere. It has not other special meaning other than it is a folder. You can write any files you want to that folder (if you have write permission to that folder). Your operating system doesn't care. SAS doesn't care. People like those of us trying to respond to your question do care ... why would you want to do this? What is your real question?

Re: in memory/work/pc path

PaigeMiller — Mon, 28 Mar 2022 20:20:37 GMT

@Tom wrote:

@SASKiwi wrote:

Saving XLSX files in your SAS work directory is not a good idea as this is deleted at the end of your SAS session.

Depends on what you are trying to do.

Saving XLSX files in your SAS work directory IS a GOOD idea BECAUSE this is deleted at the end of your SAS session.

I look at it differently. If you want it deleted at the end of your SAS session, why create the Excel file at all? What is the benefit?

Re: in memory/work/pc path

Tom — Tue, 29 Mar 2022 04:43:02 GMT

The benefit is that something/someone else cleans up after you.

https://communities.sas.com/t5/SAS-Programming/save-data-sets-into-XLSX-files-in-sas-screen/m-p/804435/highlight/true#M316784