topic Where is the physical location of work folder in SAS Procedures

Where is the physical location of work folder

Mike_Davis — Fri, 04 May 2012 16:35:18 GMT

Hello everyone,

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

Thanks!

shivas — Fri, 04 May 2012 16:39:16 GMT

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 — Fri, 04 May 2012 18:00:23 GMT

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 — Mon, 07 May 2012 02:15:46 GMT

Or, Macro method.

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

%put &work_path ;

Ksharp

George_S — Mon, 07 May 2012 13:13:44 GMT

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

Thanks

ballardw — Mon, 07 May 2012 15:09:39 GMT

Ksharps method should work with external files as well.

Peter_C — Mon, 07 May 2012 16:34:01 GMT

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 — Tue, 08 May 2012 08:20:13 GMT

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