topic Re: SAS university edition and SQL Server in SAS Studio

SAS university edition and SQL Server

aleks2709 — Sat, 05 May 2018 02:36:34 GMT

I am using SAS university edition. I see no problem to get data from excel file. My question is if it is possible to connect SAS to SQL server? Thank you

Re: SAS university edition and SQL Server

Ksharp — Sat, 05 May 2018 10:27:50 GMT

https://communities.sas.com/t5/SAS-Analytics-U/Connect-to-SQL-Server-Oracle-Database-by-SAS-University-Edition/m-p/273857/highlight/true#M3724

Re: SAS university edition and SQL Server

Reeza — Sun, 06 May 2018 22:27:24 GMT

Not officially. If you’re at a post secondary institution they may have a full version available to no or low cost.

Re: SAS university edition and SQL Server

aleks2709 — Sun, 06 May 2018 22:44:32 GMT

This is interesting idea. But I have one more question. I use SAS on windows 10 PC. So to run SAS I use virtual box where I run Linux. When Linux starts, it automatically calls SAS. So to download additional application I need I need some way to get to Linux shell to open internet explorer to download file or download file by some other way. The question appear because I did not work in Linux before. Thank you

Re: SAS university edition and SQL Server

LinusH — Mon, 07 May 2018 06:05:05 GMT

You can download from Windows, and then move it/ACCESS from your VM.

Re: SAS university edition and SQL Server

Reeza — Mon, 07 May 2018 06:06:50 GMT

The SAS UE VM is locked down and cannot be modified.

Re: SAS university edition and SQL Server

LinusH — Mon, 07 May 2018 06:07:50 GMT

UE is strictly for learning (SAS programming) purposes only. So using a specific ACCESS engine IMO doesn't really meet this criteria.
If you have a use case for which you actually produce results, chances are that you are violating the licence.
Hence the hint from @Reeza.

Re: SAS university edition and SQL Server

aleks2709 — Tue, 03 Jul 2018 01:58:28 GMT

I do not understand what did you mean in last answer. I installed university edition to study product. Why this should be called violating licence?

Re: SAS university edition and SQL Server

GenDemo — Wed, 06 Nov 2019 04:45:34 GMT

I have the same sentiment here... but I think one should bear in mind what SAS University Edition is intended for.
It is an awesome program (as I am sure we all here in the community know full well) and they need to make sure that University Edition is not used for corporate gain. Having a SQL server running, is a very strong indicator that you are in a corporate environment and should not be using University Edition. The licence agreement that you agree to by using SAS University Edition, is that you are not using it in a corporate environment and/or for financial gain.
But yes, I too have SQL running on my local machine so that I can practice and hone my skills. And it is unfortunate that you can't connect SAS University Edition to it... but I feel there is a good enough reason for it.

Just my 2c worth.