Finding Physical Location of a File under Users Folder

[ern_23]

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

[Kurt_Bremser]

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).

[ern_23]

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.

[Kurt_Bremser]

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.

[ern_23 · Accepted solution]

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

[tampham92]

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,

[Kurt_Bremser]

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:

[Ksharp]

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

%put &=path. ;