Help using Base SAS procedures

List available/installed SAS Access engines?

Reply
Contributor
Posts: 58

List available/installed SAS Access engines?

Hi to all,
let me explain my problem: unfortunately I'm working in an environment where I don't know what it's really installed for SAS, and still I'm asked to build datawarehouse solutions...so somehow I'm getting crazy Smiley Happy
Now, I'm just trying to access to a Microsoft SqlServer, but it doesn't seem possible through OLEDB...while I don't have problem with ODBC (but still, ODBC isn't a solution: I haven't an access to the server where SAS runs, so I cannot define there the ODBC!)...and I'll have to try if I can access to an Oracle and so on...
So I'd like to know: is there a way to list which SAS Engines are available in my SAS installation? So I can hope to ask to the admins if they can fix some of these problems...
Thanks

Daniele
Super User
Posts: 5,260

Re: List available/installed SAS Access engines?

One easy way is to run

proc setnit;
run;

on the server. That will show which SAS products that your site has a license for (but that doesn't necessarily mean that all of them are installed).

/Linus
Data never sleeps
Contributor
Posts: 58

Re: List available/installed SAS Access engines?

Thanks! Smiley Happy
Ask a Question
Discussion stats
  • 2 replies
  • 244 views
  • 0 likes
  • 2 in conversation