topic Re: Proc import in SAS Enterprise Guide 4.3 in SAS Enterprise Guide

Proc import in SAS Enterprise Guide 4.3

Walternate — Thu, 16 Oct 2014 14:30:29 GMT

Hi,

I am trying to import an Excel spreadsheet into SAS Enterprise Guide 4.3 using the following code:

proc import out=cohort

datafile="\\C:\Datafile.xlsx"

dbms=excel replace;

run;

When I run this, I get an error message saying that dbms type Excel is not valid for import. If I replace excel with xlsx in the code, I get the same error message.

Any help is much appreciated.

Re: Proc import in SAS Enterprise Guide 4.3

TomKari — Thu, 16 Oct 2014 15:15:26 GMT

There are a lot of permutations between Excel and SAS. Does anything from this thread help?

Tom

https://communities.sas.com/thread/40828

Re: Proc import in SAS Enterprise Guide 4.3

Butterfly — Fri, 17 Oct 2014 13:18:34 GMT

I've had the same thing happen. There is a problem with some versions of SAS that you can't import/export to Excel and Access. I convert the Excel file into a text file (tab-delimited or comma-delimited) and then import it.

Re: Proc import in SAS Enterprise Guide 4.3

fredmayer23 — Fri, 17 Oct 2014 14:47:04 GMT

First thing to check is your licensing; make no assumptions whenever troubleshooting.

Re: Proc import in SAS Enterprise Guide 4.3

reddymano542 — Wed, 14 Jun 2017 09:01:55 GMT

Hi,

When I run this, I get an error message saying that dbms type Excel is not valid for import. If I replace excel with xlsx in the code, I get the same error message.

first check ur saseg settings it is only for server thats why u are getting 'dbms type Excel is not valid for import'.

For this u can use import directly.

go to file >> import data >> browse the file, then click ok button, then finish button .