I have installed SQL Express 2014 with AdventureWorks 2014 database. My idea is to install VMWare and SAS University Edition in order to learn some SAS and practice it at my home.
My first and most important question is: Is it possible to connect SAS University Edition with SQL Express 2014 database?
I am currently downloadint SAS UE, and will install VMWare and SAS UE as soon as it is finished, however, all this work will be in vain if I cannot connect it to database on which I would practice.
Of course, if you have another solution, I am open for your recommendation.
Exactly as you stated, my idea is to create a working environment. I am about to embark on a job opportunity where we have a pretty large database, and knowledge of SAS is essential for large number of reporting purposes.
My idea was to have a connection to the database in order to have data for running certain analysis on them.
I have never used SAS, so don't know it's possibilities in terms of data import and similar, but will investigate it now that the download is done.
I will look into the courses you are referring to.
That is definitely an option, however, it would take me long time to export all tables, but will probably do it like this. I have also several databases in Access/SQL files (baseball database for years 2001 - 2014), should I assume same approach is needed for these databases also.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.
Find more tutorials on the SAS Users YouTube channel.