Access Files In PC SHARED DRIVE using UNIX SAS

[P_S_]

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.

[Doc_Duke]

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

[P_S_]

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.

[Doc_Duke]

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.