The SAS/ACCESS Interface to PC Files is not installed error when importing Excel data

[BritAshley]

I reinstalled SAS 9.3 on to my computer today, and when I went to import an Excel file, I got the following error:

The SAS/ACCESS Interface to PC Files is not installed

However, I ran

proc setinit;

run;

And the SAS/ACCESS Interface to PC Files is listed under the products that are installed.

If I reinstall, is there a way to ensure that this piece will be installed correctly?

Thanks!

[KevinL70]

Hello BritAshley,

Make sure that SAS PC Files Server is installed and running.

If you are using Windows 7 you can check by clicking on the Start Icon and typing in services and hitting enter.  You should find the entry called:  "SAS PC Files Server" and it should say "Started" under Status.

[BritAshley]

Hi KevinL70,

I do not think I need SAS PC Files Server because I have 32-bit MS Office and 32-bit SAS.  I believe I am having problems with the SAS/ACCESS Interface to PC Files.

Thanks!

[KevinL70]

Hi BritAshley,

According to the SAS documentation, I believe the SAS PC Files Server needs to run regardless if a PC is 64 or 32 Bit:

SAS/ACCESS(R) 9.3 Interface to PC Files: Reference

Thanks,

[SASKiwi]

BritAshley is correct. If the "bitness" between SAS and Office is the same no PC File Server is required. Where I work we use 64-bit SAS and MS Office components and it works fine.

[Reeza]

What's your code then? How are you trying to import your file?

[BritAshley]

Hi Reeza,

I can import csv and txt files, just not MS office files (Excel/Access).  I was using proc import to do it.

Thanks

[Reeza]

Do you have the license for the product?

Run

proc setinit; run; to see if it's licensed and

proc product_status; run; to see if it's installed.

[BritAshley]

Thank you, okay, it was on the list of licensed products, but NOT on the list of installed products.  However, I know I clicked the box to install it when I installed SAS.

[SASKiwi]

Try re-installing, using the additional software option.