topic Re: Access Files In PC SHARED DRIVE using UNIX SAS in SAS Procedures

Access Files In PC SHARED DRIVE using UNIX SAS

P_S_ — Tue, 19 Apr 2011 15:17:12 GMT

Hello,
I am trying to read some excel, txt etc files stored in a PC shared drive using UNIX SAS directly rather than PC SAS. I am using
libname abc pcfiles but not having much luck with it. The error I get is:

ERROR: The PCFILES engine cannot be found.

Have anyone tried this before?

Thank you,
P.S.

Re: Access Files In PC SHARED DRIVE using UNIX SAS

Doc_Duke — Tue, 19 Apr 2011 19:26:36 GMT

yes. It does not work. The Unix versions of SAS do not support the PC files engines.

You can read .txt files just as though they were on Unix. Reading Excel files requires (PC) SAS to call some of the Microsoft routines to get the work done, so Unix SAS can't do that.

It is documented with the PCFILES engine.

Doc Muhlbaier
Duke

Re: Access Files In PC SHARED DRIVE using UNIX SAS

P_S_ — Wed, 20 Apr 2011 01:51:56 GMT

Hi Doc@Duke,

You have mentioned that you can 'You can read .txt files just as though they were on Unix.'. Would you mind sharing the tips on how you can do it. I have some txt files as well. It will be helpful.

Thank you,
P.S.

Re: Access Files In PC SHARED DRIVE using UNIX SAS

Doc_Duke — Wed, 20 Apr 2011 14:12:21 GMT

The only difference between a Unix text file and a PC text file is the end-of-line character. Fortunately, SAS treats them both the same. Therefore, you can use the usual tools to read the text files. DATA, INFILE, INPUT all work the same. PROC IMPORT will also bring in .CSV files.