Help using Base SAS procedures

Access Files In PC SHARED DRIVE using UNIX SAS

Reply
Contributor
Posts: 42

Access Files In PC SHARED DRIVE using UNIX SAS

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.
Trusted Advisor
Posts: 2,115

Re: Access Files In PC SHARED DRIVE using UNIX SAS

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
Contributor
Posts: 42

Re: Access Files In PC SHARED DRIVE using UNIX SAS

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.
Trusted Advisor
Posts: 2,115

Re: Access Files In PC SHARED DRIVE using UNIX SAS

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.
Ask a Question
Discussion stats
  • 3 replies
  • 182 views
  • 0 likes
  • 2 in conversation