List available/installed SAS Access engines?

[DanieleTiles]

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 🙂
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

[LinusH]

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

[DanieleTiles]

Thanks! 🙂