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

Not able to import excel file in SAS Enterprise Guide

bsachin94 — Sun, 18 Dec 2016 19:42:41 GMT

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

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

Shmuel — Sun, 18 Dec 2016 18:07:11 GMT

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

Brows and select the SAS Server (insread local)

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

bsachin94 — Sun, 18 Dec 2016 19:41:10 GMT

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?

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

Reeza — Sun, 18 Dec 2016 20:44:53 GMT

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.

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

Kurt_Bremser — Mon, 19 Dec 2016 08:22:46 GMT

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.

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

bsachin94 — Mon, 19 Dec 2016 09:09:56 GMT

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.

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

Kurt_Bremser — Mon, 19 Dec 2016 09:13:56 GMT

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?

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

bsachin94 — Mon, 19 Dec 2016 14:50:17 GMT

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.”

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

Reeza — Mon, 19 Dec 2016 14:53:55 GMT

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.

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

ChrisHemedinger — Mon, 19 Dec 2016 14:57:20 GMT

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

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

Kurt_Bremser — Mon, 19 Dec 2016 14:58:23 GMT

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.

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

MM7 — Thu, 03 Jan 2019 08:31:26 GMT

i am facing the same issue.Have you been able to solve the issue? If yes, kindly hel me with the same.

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

Kurt_Bremser — Thu, 03 Jan 2019 08:41:51 GMT

Please open a new thread with your own question. This old one is 'visible' to the former participants only, so you won't get much attention.

Post exactly what problems you have, describe your environment and how your SAS is set up (single or multi machine, operating system(s), versions, etc).

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

thpkml — Fri, 18 Oct 2019 17:34:39 GMT

I have the exact same problem and I'm using my university lab machine which has no other option than 'local' any ideas?

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

TomKari — Fri, 18 Oct 2019 19:44:41 GMT

On your Windows Start menu you should have a program entry something along the lines of SAS 9.4.

Try running that, and if SAS starts, you should see a message in the log, or watch for any other kinds of diagnostics. There may be a problem with SAS starting up.

Tom