topic Re: E. Guide: Save files in other server in SAS Enterprise Guide

E. Guide: Save files in other server

deleted_user — Wed, 15 Sep 2010 17:39:15 GMT

We're working in a server with OS UNIX (AIX). We want to export a lot of files (PROC EXPORT) to a local pc (OS Windows), but we got an error message. We tried to create a library in this server routed to windows pc. is it possible? how do I do?

this code, I run in server:
Libname mylib '\\172.1.1.11\files\'

thanks,
Luis

Re: E. Guide: Save files in other server

SASKiwi — Wed, 15 Sep 2010 21:57:29 GMT

Please share your complete PROC EXPORT code and SAS log with error messages. We cannot provide the best advice without knowing the full story. For example we do not know what format your exported files are (CSV, Excel, Access, etc...)

Re: E. Guide: Save files in other server

deleted_user — Wed, 15 Sep 2010 23:12:40 GMT

I need to export files from Server (UNIX) to my pc(Windows). Thanks.

PROC EXPORT DATA= WORK.Data
OUTFILE= "d:\Datos de Usuarios\S08027\My Documents\Data.csv"
DBMS=CSV REPLACE;
RUN;

-------LOG-------------
ERROR: Insufficient authorization to access /sas/SASConfig/Lev1/SASMain/d:\Datos de Usuarios\S08027\My Documents\Data.csv.

Re: E. Guide: Save files in other server

SASKiwi — Thu, 16 Sep 2010 05:45:28 GMT

Your OUTFILE = string needs to reference your PC from your Unix server. Is this what you were trying to do in your first message with: '\\172.1.1.11\files\'? If so try this in your OUTFILE=. Message was edited by: SASKiwi

Re: E. Guide: Save files in other server

Patrick — Thu, 16 Sep 2010 13:35:40 GMT

Hi

If you look at the path in the ERROR log you will see that the part before d:\ is actually a UNIX path.

What happens here is:
As the code runs on the UNIX server path names must be declared as the UNIX server sees them. The path you pass to PROC EXPORT is a Windows path (as you might have mapped it on your PC) about which the UNIX server knows nothing - and because the path starts with "d" UNIX thinks this a a partial path starting from where you are right now in the moment (which is the directory from where you start SAS on the server).

Easiest would be you point OUTFILE to a directory on a share which you also can map from your PC.

If this is only a once off: What about just manually selecting work.data, left click, chose export and as file type .csv.

HTH
Patrick

Re: E. Guide: Save files in other server

deleted_user — Thu, 16 Sep 2010 15:15:42 GMT

I understand that the path is the problem, what do I modify in this code?

PROC EXPORT DATA= WORK.Data /* This dataset is in UNIX Server*/
OUTFILE= "\\193.29.1.1\Target\Data.csv" /*this path is a windows pc*/
DBMS=CSV REPLACE;
RUN;

thanks a lot for your help. SOS!

Luis Message was edited by: LuchoR

Re: E. Guide: Save files in other server

ChrisHemedinger — Thu, 16 Sep 2010 16:09:35 GMT

In this case, you need your UNIX server to drop a file to your Windows PC. You would need to use a drive-mapping technology such as SAMBA (so you can address your UNIX path from your PC as a mapped drive), or get fancier to push the CSV file to the PC using FTP (using the FTP method in the FILENAME statement).

Chris

Re: E. Guide: Save files in other server

deleted_user — Thu, 16 Sep 2010 19:22:16 GMT

I think that I can not do it through code.

ok, thanks a lot everybody.

Re: E. Guide: Save files in other server

SASKiwi — Fri, 17 Sep 2010 01:07:37 GMT

Yes you can do it through code using the FILENAME statement and the FTP option. Check this out in SAS online help. However it would be a good idea to talk to your Unix system administrator to see if the security/network setup at your site would allow this in the first place. If you are not familiar with FTP it stands for File Transfer Protocol and is an easy way to move files between computers especially those with different operating systems.

Re: E. Guide: Save files in other server

deleted_user — Fri, 17 Sep 2010 14:16:39 GMT

Thanks SASKiwi. Unix is causing me problems!!.

Luis