Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using Proc Import without ODBC Connection

Status
Not open for further replies.
sap1958

sap1958

Technical User
Oct 22, 2009
138
0
0
US
In my last job we had ODBC connectivity in SAS so I was able to use proc import to connect MS Access to SAS. In my present job we pull SAS from a server so ODBC connections are not used. Would I still be able to use proc import to connect an access table to SAS. I want to be able to to write programs that will populate my access tables from the results of sas
 
Sort by date Sort by votes
I think it will largely depend on the modules your current SAS version has to whether ODBC is part of it.

If you run:

proc setinit;
run;

In your log window it will show you all the modules associated with your SAS
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Anna dlC
  • Locked
  • Question
proc sql duplicate column name
Replies
0
Views
149
Anna dlC
Anna dlC
Ken
  • Locked
  • Question
how can we filter on yyyymm in proc sql ?
Replies
1
Views
249
klaz2002
klaz2002
Ken
  • Locked
  • Question
user prompt in proc sql with parameter
Replies
0
Views
82
Ken
Ken
mmignot
  • Locked
  • Question
How To Insert An Image Using Proc Report
Replies
0
Views
70
mmignot
mmignot
lulumohca
  • Locked
  • Question
Proc Transpose Data transpose question
Replies
1
Views
64
lulumohca
lulumohca

Part and Inventory Search

Sponsor

Back
Top