Desktop productivity for business analysts and programmers

Accessing SAS folder from outside of SAS

Reply
Occasional Contributor
Posts: 14

Accessing SAS folder from outside of SAS

Dear friends

Is it possible to access the WORK folder from outside of SAS like any other folder in our network using "my computer"?

Thanks

Rafael

Super User
Super User
Posts: 7,668

Re: Accessing SAS folder from outside of SAS

Yes.  Depends on OS, your access rights etc.  If you right click on the Work Library in SAS Explorer and choose properties, you will see the path to the work library, just navigate to that in your OS.

Respected Advisor
Posts: 4,130

Re: Accessing SAS folder from outside of SAS

If the server is not "local" then ideally you wouldn't be allowed to access SAS WORK other than within your SAS session using SAS (OS permissions) - and you certainly shouldn't be allowed to access someone else's WORK folder unless you're an Admin.

What's the background of your question? What do you try to achieve? May be there are other ways to get what you're after.

Occasional Contributor
Posts: 14

Re: Accessing SAS folder from outside of SAS

Hi Patrick

Thank you very much for your interest.

The reason i ask is that i can't use proc import and export to excahnge files with SAS Server because our SAS server can not access our local network yet.

I thought that if i had access to my own WORK folder or any other dedicated private folder, i could move files to that folder and use that in my SAS Programs.

Also The final output of many of our reports is in the form of excel files with multiple sheets and i need the proc export for that

Thanks

Rafael

Super User
Super User
Posts: 7,668

Re: Accessing SAS folder from outside of SAS

Eeek, I don't recommend using Excel full stop for anything.  Also, I would be cautious of using proc import/export as they guessing procedures.  Use a structured data transfer format (CSV,XML) and write a proper datastep import/export procedure.

As for you files, can you not just put them on your local drive (C: probably), then use that local area - note you will need SAS Access if you want to access M$ files (another good reason to avoid them and use data transfer file formats).

Respected Advisor
Posts: 4,130

Re: Accessing SAS folder from outside of SAS

I assume you're using SAS EG or SAS Studio. These are the clients. You then connect to a SAS Server. It's on the server where your SAS program gets executed and it's also on the server where SAS WORK lives (not on your local machine).

If done manually then SAS EG allows you to import/export a file and then execute the data on the server. But this works in a way that SAS EG as a very powerful client (installed on your local machine) accesses the data, imports it and then sends the data together with the SAS code to the Server for processing - so the resulting data still lives on the server.

SAS EG also gives you the ability to store (export) a SAS table as an Excel - but this is again the EG client communicating with the SAS Server, downloading the data to the client and then using .net to generate an Excel. This is nothing you can do programatically (except via EG "scheduling" - but this is just "automating" the client).

Soooo... The only real solution is to write server output to a file system which can also be accessed by the local computer.

...just thinking: Another option would be to create the desired output on the server and then send this output via email attachment to yourself (if the server can access an email server - which is very often possible).

Ask a Question
Discussion stats
  • 5 replies
  • 395 views
  • 3 likes
  • 3 in conversation