topic Re: SAS access interface to PC files in SAS Programming

SAS access interface to PC files

Babloo — Tue, 17 Mar 2015 10:05:10 GMT

I've access to 'SAS access interface to PC files' and my SAS 9.4 was installed in AIX server. When I tried to import\export local (C:\) files, I got the error as follows. Do I need in to install SAS in local drive to make it happen? Even If I do so, can I access files from server after I do local (C:\) installation.?

16 LIBNAME myfile 'c:\FCU.csv';

NOTE: Library MYFILE does not exist.

19 proc import datafile=myfile out=rawdata dbms=csv;

20 run;

NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to

WORK.PARMS.PARMS.SLIST.

ERROR: Physical file does not exist, /data/rawdata/SAS_93/biserver/Lev1/SASApp/MYFILE.

ERROR: Import unsuccessful. See SAS Log for details.

Re: SAS access interface to PC files

Kurt_Bremser — Tue, 17 Mar 2015 10:22:01 GMT

Your AIX server is UNIX! This means that you have to acquaint yourself with the UNIX filesystem syntax.

So the moronic windows style filenames will not work. UNIX has no drive letters, and uses the forward slash to separate directory names.

Your libname statement cannot work at all, libraries are represented as directories in the filesystem, and not as files!

You probably tried to assign a logical filename; use the filename statement for that.

In order to open a file that resides on your PC, you either have to transfer it to the AIX server first or have a network share connection set up (AD, Novell, NFS) so that the AIX server can "see" a directory that you can also use from your PC.

Re: SAS access interface to PC files

Babloo — Tue, 17 Mar 2015 10:29:38 GMT

Got the same error with the file name statement as well.

May I request you to elaborate 'have a network share connection set up (AD, Novell, NFS) so that the AIX server can "see" a directory that you can also use from your PC'? So that I can ask network team to complete the set up.

What will be the likely answer for my question on , Do I need in to install SAS in local drive to make it happen? Even If I do so, can I access files from server after I do local (C:\) installation.?

Re: SAS access interface to PC files

Kurt_Bremser — Tue, 17 Mar 2015 11:17:20 GMT

SAS is delivered with a specific license for a specific system environment. You also receive your media (or package download) for that specific environment.

So while there will be software that can be installed on several platforms (things like the Management Console, which is Java-based), your base SAS will only be installable on the main target platform. So you most likely will not have SAS for Windows.

You need to make your wanted infile (FCU.csv) visible for the SAS system on AIX. In order to do this, your adminstrator can set up a network share that is both visible by your PC and the SAS server, and supply you with the path names in the respective environments. Or you can simply transfer the file to the AIX server with a program like WinSCP.

For both of these options to work, you need to get a grasp on how files are named/found in a UNIX system. Learn what the root directory is, where your home directory is located, and the difference between relative and absolute path names.