BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
CG11164
Fluorite | Level 6

When I have been importing data from 32 bit office into Sas 9.4 I had a drop down box that allowed me to choose PC File Server Excel from the IMPORT Wizard.  Not sure what happened on my system but that option is gone and I can only choose from csv, Tab Delimited, Delimited and JMP.

 

Does anyone know how to get the IMPORT options back?  I have reinstalled multiple times - nothing seems to be working.

 

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
CG11164
Fluorite | Level 6

I do get the line in the log you list.  I haven't had to use the PC File server before so will need to locate documentation on configuring it. 

 

Thanks

View solution in original post

3 REPLIES 3
Tom
Super User Tom
Super User

What user interface are you using? SAS Display Manager?  Enterprise Guide?  SAS/Studio?

ballardw
Super User

When you reinstalled are you sure that Interface to PC files was installed?

You can run to check install status

proc product_status;
run;

If the log shows a line like :

For SAS/ACCESS Interface to PC Files ...

then it was installed and likely needs to be configured.

CG11164
Fluorite | Level 6

I do get the line in the log you list.  I haven't had to use the PC File server before so will need to locate documentation on configuring it. 

 

Thanks

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1122 views
  • 0 likes
  • 3 in conversation