Where is the physical location of work folder

[Mike_Davis]

Hello everyone,

Could you tell me where is the physical location of work folder(temporary  library)?

Thanks!

[shivas]

Hi Mike,

Right click on the work library and you can find the work library path.

or you can see it in sasv9.cfg file.

Thanks,

Shiva

[ballardw]

This code will show it:

proc sql;

select path from dictionary.libnames

where libname='WORK';

quit;

If you're using windows with a default installation the library will change every time you start SAS.

[Ksharp · Accepted solution]

Or,  Macro method.

%let work_path=%sysfunc(pathname(work));

%put &work_path ;

Ksharp

[George_S]

If the fileref is on a remote Unix server,How to do this? 

Thanks

[ballardw]

Ksharps method should work with external files as well.

[Peter_C]

George

Ksharp's method works (or reduce it to one statement

%put %quote( %sysfunc( pathname(work)) );
) with  %quote() added to protect any special characters in the physical path

, if you execute it in the sas session in the "remote Unix server" you referred to.

or if you prefer to avoid the macro language,  just

rsubmit ;

libname work list ;

endrsubmit ;

peterC

[Ksharp]

I am not sure, but you can check dictionary table "dictionary.EXTFILES" to see whether it exist there .