Desktop productivity for business analysts and programmers

Not able to import excel file in SAS Enterprise Guide

Reply
New Contributor
Posts: 4

Not able to import excel file in SAS Enterprise Guide

[ Edited ]

Hi Team,

 

I have installed SAS EG recently. I was trying to import excel file in SAS. However, while I am trying to import the excel file, the next option in the dialog box is not getting highlighted. As a result, I am not able to complete the import. Please let me know what should be done to resolve this issue.

 

It would be of great help if anybody could give the solution to this problem.


Regards,

Sachin B

Attachment
Super User
Posts: 1,244

Re: Not able to import excel file in SAS Enterprise Guide

If you run SAS EG you probably run on a server and not local host.

Brows and select the SAS Server (insread local)

New Contributor
Posts: 4

Re: Not able to import excel file in SAS Enterprise Guide

Thanks for your reply. I am running through an installed application i.e. from Programs > SAS > SAS EG

 

Not sure why that next button is not enabled. Is there any way to enable it?

 

 

Grand Advisor
Posts: 17,427

Re: Not able to import excel file in SAS Enterprise Guide

The options your selecting in the window aren't correct for some reason. 

 

Is SAS running on your desktop or does your company have a server? If you log on and have access to datasets not stored on your computer, it's likely a server set up. 

 

This means you need to change the Server option.

 

Another possibility is that you've selected the wrong file type. You have an XLS file, which is an older format. 

See if you have the option for older Excel files. 

Or you may need to be using PCFILES option. But try these two things first.  

New Contributor
Posts: 4

Re: Not able to import excel file in SAS Enterprise Guide

Please elaborate on the options I have to resolve the issue. I have installed it in my system and I am not able to import simple excel file.

 

Settings if any required, please suggest.

Esteemed Advisor
Posts: 6,698

Re: Not able to import excel file in SAS Enterprise Guide

You did not answer my question.

 

Let me elaborate: did you install a whole SAS system, including SASFoundation, from a SAS depot with the SAS Deployment Wizard, or just Enterprise Guide from the SASEnterpriseGuidexx_x86_x64 executable?

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Esteemed Advisor
Posts: 6,698

Re: Not able to import excel file in SAS Enterprise Guide

Did you install a complete SAS system, or only Enterprise Guide?

If you only installed EG, then you need to point your Enterprise Guide to a SAS server that runs the SAS system itself.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
New Contributor
Posts: 4

Re: Not able to import excel file in SAS Enterprise Guide

I installed "Install SAS Foundation and Related Software" then I selected "Clients only" and under this I selected all, then under default product type I selected "SAS Enterprise Guide.”

Grand Advisor
Posts: 17,427

Re: Not able to import excel file in SAS Enterprise Guide

It sounds like you may not have installed everything. 

Reinstall and make sure to include SASfoundation unless you are connecting to a SAS server. If you have a SAS administrator ask them for help to connect to server. 

 

 

Community Manager
Posts: 2,697

Re: Not able to import excel file in SAS Enterprise Guide

Use the steps in this article to ensure you have Local SAS and that it's set up correctly.

Esteemed Advisor
Posts: 6,698

Re: Not able to import excel file in SAS Enterprise Guide

Enterprise Guide is just a frontend and comprises less than 12 percent of the whole SAS system, storagewise.

Make sure you follow the correct deployment plan; if that deployment plan has two machines (n which case you installed what you need), this means that you need to specify a server that EG can connect to.

You do this in Tools - Options - Administration - Connection (Profile)

For server name and post number, consult your site administrator.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 10 replies
  • 237 views
  • 0 likes
  • 5 in conversation