SAS Access - Gateway to Other Applications: Livestream Recording
*Note: I may be compensated, but you will not be charged, if you click on the links below.
🔵Download the slides from the lectures in the series here: https://buff.ly/3rCh71r
🟠Want to participate in our upcoming online workshop “Application Basics”? Details are here: https://buff.ly/43SfASM
💖This livestream event was originally recorded on February 13, 2024. See original LinkedIn event here: / sasaccess-gatewaytootherapplica71585358770...
💖To register for our live events, follow our company page on LinkedIn: / dethwench-professional-services
💡 Read about all our online educational resources: https://buff.ly/45amjaQ
💡 Learn more about online group mentoring program: https://buff.ly/3Sw4Fsa
💡 EXCLUSIVE! Download 9-page list of applications terminology with definitions along with flash cards from the course! https://buff.ly/43yEUgT
💡 EXCLUSIVE! Download cheat sheet for Monika’s preferred Microsoft Excel defaults! https://mailchi.mp/3092e5e77ee5/rsasa...
WANT TO SUPPORT MONIKA ON SOCIAL MEDIA?
🔵Sign up for Monika’s weekly data science e-newsletter: https://buff.ly/2UYW60l
🟠Follow/connect with Monika on LinkedIn: / dethwench
🟢Try Monika’s courses on LinkedIn Learning: https://linkedin-learning.pxf.io/NKN0JO
⚫Follow Monika on Twitter: / dethwench
🟣Follow Monika on Instagram: https://www.instagram.com/dethwench/?...
🟤Follow Monika on Facebook: / dwprofsvcs
💜Intro and outro by CJ Hutchings, recorded exclusively for DPS. Check out more of CJ’s music and art here: https://dethwench.com/cjhutchings/
❤️Got too much work? You can hire Ebenezer as YOUR executive assistant, too! He is highly competent and reliable. Contact him here: https://ebdado.netlify.app/
Links/Timestamps from Video:
01:04 Pain points connecting to the legacy SAS environment
01:57 Two use cases for SAS Access component: Connecting to SQL, and connecting to MS Excel
03:20 Terminology definitions: ODBC and API
05:18: Use case #1: Connecting PC SAS to a SQL server at an organization using SAS Access
08:38 Going over SAS Access code to connect to MS SQL (and PROC SQL code)
11:27 SAS OnDemand for Academics user interface
12:40 Use case #2: Connecting PC SAS to an MS Excel file on the same computer
15:15 Example of data transfer using data steps instead of PROC SQL