topic Re: Finding Physical Location of a File under Users Folder in Administration and Deployment

Finding Physical Location of a File under Users Folder

ern_23 — Fri, 29 Apr 2022 08:56:13 GMT

Hi everyone,

My purpose is to share a SAS output stored as csv/xlsx/txt file under SAS Content folder through e-mail. I'm trying to attach the file by referencing it but since SAS run on Unix/Linux , the path and filename I give does not reflect the true path & filename.

Is there any function or efficient way to obtain name & location of a file locates any of folders under SAS Content?

Thank you,

Eren

Re: Finding Physical Location of a File under Users Folder

Kurt_Bremser — Fri, 29 Apr 2022 09:06:16 GMT

How do you create the output files? SAS will show the full location in the log, and the code will also have the location present in some form (the location string may be built out of macro variables, so you need the contents of those).

Re: Finding Physical Location of a File under Users Folder

ern_23 — Fri, 29 Apr 2022 11:02:15 GMT

I'm using Proc Export to create .csv version of SAS file. Before Proc Export step, I'm specifying file reference by using filename , folderpath and other necessary parameters. I had tried URI path and File Identifier information given in the log (after creation CSV file) , but it did not work out.

Re: Finding Physical Location of a File under Users Folder

Kurt_Bremser — Fri, 29 Apr 2022 11:27:47 GMT

Please post the complete log of your PROC EXPORT step and the DATA step that sends the mail. Both should be run in immediate succession.

Re: Finding Physical Location of a File under Users Folder

Ksharp — Fri, 29 Apr 2022 13:11:26 GMT

filename x '.';
%let path=%sysfunc(pathname(x));

%put &=path. ;

Re: Finding Physical Location of a File under Users Folder

ern_23 — Fri, 29 Apr 2022 13:32:33 GMT

Hi Kurt_Bremser,

I fixed the problem by changing the folder path to /PUBLIC/ and taking the filename name given in the log.

Thank you !

Eren

Re: Finding Physical Location of a File under Users Folder

tampham92 — Tue, 09 Jan 2024 02:47:39 GMT

Hello,

I am trying to do the same thing in SAS EG. The log said /sasusera_home/xxx but I don’t have a full path.
May I ask what you mean by changing it to /public/. I cannot connect sas with c drive either.

Best Regards,

Re: Finding Physical Location of a File under Users Folder

Kurt_Bremser — Tue, 09 Jan 2024 10:01:42 GMT

What kind of file do you create?

Which of the tools provided by EG do you use (code node, export wizard)?

Please post the complete log by copy/pasting it into a window opened with this button: