<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Spring 2023 Edmonton SAS User Group (ESUG) Meeting Presentations in SAS User Groups Discussions</title>
    <link>https://communities.sas.com/t5/SAS-User-Groups-Discussions/Spring-2023-Edmonton-SAS-User-Group-ESUG-Meeting-Presentations/m-p/879277#M415</link>
    <description>&lt;P&gt;Cheers to another meeting in the books! We hope everyone enjoyed the presentations...and the beer.&amp;nbsp;&lt;span class="lia-unicode-emoji" title=":clinking_beer_mugs:"&gt;🍻&lt;/span&gt; There's nothing quite like meeting other SAS Edmonton Users over a pint of beer, in my humble opinion. &amp;nbsp;&lt;span class="lia-unicode-emoji" title=":winking_face:"&gt;😉&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;In case you need a refresher, here was the agenda for the afternoon.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;TABLE class="stack blue" border="1"&gt;
&lt;TBODY&gt;
&lt;TR&gt;
&lt;TD width="89.875px" height="57px"&gt;12:30pm - 1:00pm&lt;/TD&gt;
&lt;TD width="976.125px" height="57px"&gt;&lt;STRONG&gt;Registration and Appetizers&lt;/STRONG&gt;&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="89.875px" height="57px"&gt;1:00pm - 1:05pm&lt;/TD&gt;
&lt;TD width="976.125px" height="57px"&gt;&lt;STRONG&gt;Welcome Remarks&lt;/STRONG&gt;&lt;BR /&gt;&lt;EM&gt;Doug Dover, ESUG President&lt;/EM&gt;&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="89.875px" height="57px"&gt;1:05pm - 1:20pm&lt;/TD&gt;
&lt;TD width="976.125px" height="57px"&gt;&lt;STRONG&gt;What's New at SAS?&lt;/STRONG&gt;&lt;BR /&gt;&lt;EM&gt;Alice Yuan, SAS Canada&lt;/EM&gt;&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="89.875px" height="85px"&gt;1:20pm - 1:55pm&lt;/TD&gt;
&lt;TD width="976.125px" height="85px"&gt;
&lt;P&gt;&lt;STRONG&gt;Diving Deeper Into SQL&lt;/STRONG&gt;&lt;BR /&gt;&lt;EM&gt;John Fleming, Alberta Health Services&lt;/EM&gt;&lt;/P&gt;
&lt;P&gt;Often with SQL, we get some basic stuff like joins.&amp;nbsp; But is there more we can do with SQL?&amp;nbsp; Today, we are going to take a deeper look.&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="89.875px" height="57px"&gt;1:55pm - 2:15pm&lt;/TD&gt;
&lt;TD width="976.125px" height="57px"&gt;&lt;STRONG&gt;Tips &amp;amp; Tricks&lt;/STRONG&gt;&lt;BR /&gt;&lt;EM&gt;Doug Dover &amp;amp; Emily Blagdon, University of Alberta&lt;/EM&gt;&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="89.875px" height="57px"&gt;2:15pm - 2:45pm&lt;/TD&gt;
&lt;TD width="976.125px" height="57px"&gt;&lt;STRONG&gt;Networking Break &amp;amp; Refreshments&lt;/STRONG&gt;&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="89.875px" height="316px"&gt;2:45pm - 3:20pm&lt;/TD&gt;
&lt;TD width="976.125px" height="316px"&gt;
&lt;P&gt;&lt;STRONG&gt;SAS Automation for Pragmatic Randomized Trials&lt;/STRONG&gt;&lt;BR /&gt;&lt;EM&gt;Erik Youngson, Alberta Health Services&lt;/EM&gt;&lt;/P&gt;
&lt;P&gt;The BedMed Frail study is currently enrolling patients to evaluate whether time of day blood pressure medications are taken in continuing care facilities impacts patient outcomes.&lt;/P&gt;
&lt;P&gt;This talk will highlight several ways that SAS is utilized within Alberta Health Services to conduct the study including the following:&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;Identifying eligible residents&lt;/LI&gt;
&lt;LI&gt;Connecting directly to a REDCap database&lt;/LI&gt;
&lt;LI&gt;Storing data in Oracle&lt;/LI&gt;
&lt;LI&gt;Randomization&lt;/LI&gt;
&lt;LI&gt;Securely emailing randomization lists&lt;/LI&gt;
&lt;LI&gt;Emailing summary results&lt;/LI&gt;
&lt;/UL&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="89.875px" height="167px"&gt;3:20pm - 3:50pm&lt;/TD&gt;
&lt;TD width="976.125px" height="167px"&gt;
&lt;P&gt;&lt;STRONG&gt;Case Use for SAS Visual Investigator – Combating Guns and Gangs in Alberta with the Correctional Services Intelligence Unit&lt;/STRONG&gt;&lt;BR /&gt;&lt;EM&gt;Chris Gibson, Alberta Justice&lt;/EM&gt;&lt;/P&gt;
&lt;P&gt;Exploring the use of SAS Visual Investigator and analytics &amp;nbsp;in the public safety sector including correctional settings and more.&amp;nbsp; On a daily basis members of the &amp;nbsp;Intelligence unit are conducting investigations to protect the people of Alberta and suppress crime.&amp;nbsp; With the assistance of SAS technology we are seeing drastic increases in officer efficiencies and less intelligence gaps tracking both gang and firearm crimes across the province.&amp;nbsp;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="89.875px" height="57px"&gt;3:50pm - 4:20pm&lt;/TD&gt;
&lt;TD width="976.125px" height="57px"&gt;&lt;STRONG&gt;SAS Graphing Tips &amp;amp; Tricks&lt;/STRONG&gt;&lt;BR /&gt;&lt;EM&gt;Allison Scott, Alberta Health Services&lt;/EM&gt;&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="89.875px" height="57px"&gt;4:20pm - 4:30pm&lt;/TD&gt;
&lt;TD width="976.125px" height="57px"&gt;&lt;STRONG&gt;Closing Remarks&lt;/STRONG&gt;&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="89.875px" height="57px"&gt;4:30pm - 5:30pm&lt;/TD&gt;
&lt;TD width="976.125px" height="57px"&gt;&lt;STRONG&gt;Optional: Happy Hour Networking &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;/STRONG&gt;&lt;/TD&gt;
&lt;/TR&gt;
&lt;/TBODY&gt;
&lt;/TABLE&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;PDF versions of the presentations can also be found in this post.&lt;/P&gt;</description>
    <pubDate>Mon, 05 Jun 2023 17:16:31 GMT</pubDate>
    <dc:creator>AliceYuan</dc:creator>
    <dc:date>2023-06-05T17:16:31Z</dc:date>
    <item>
      <title>Spring 2023 Edmonton SAS User Group (ESUG) Meeting Presentations</title>
      <link>https://communities.sas.com/t5/SAS-User-Groups-Discussions/Spring-2023-Edmonton-SAS-User-Group-ESUG-Meeting-Presentations/m-p/879277#M415</link>
      <description>&lt;P&gt;Cheers to another meeting in the books! We hope everyone enjoyed the presentations...and the beer.&amp;nbsp;&lt;span class="lia-unicode-emoji" title=":clinking_beer_mugs:"&gt;🍻&lt;/span&gt; There's nothing quite like meeting other SAS Edmonton Users over a pint of beer, in my humble opinion. &amp;nbsp;&lt;span class="lia-unicode-emoji" title=":winking_face:"&gt;😉&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;In case you need a refresher, here was the agenda for the afternoon.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;TABLE class="stack blue" border="1"&gt;
&lt;TBODY&gt;
&lt;TR&gt;
&lt;TD width="89.875px" height="57px"&gt;12:30pm - 1:00pm&lt;/TD&gt;
&lt;TD width="976.125px" height="57px"&gt;&lt;STRONG&gt;Registration and Appetizers&lt;/STRONG&gt;&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="89.875px" height="57px"&gt;1:00pm - 1:05pm&lt;/TD&gt;
&lt;TD width="976.125px" height="57px"&gt;&lt;STRONG&gt;Welcome Remarks&lt;/STRONG&gt;&lt;BR /&gt;&lt;EM&gt;Doug Dover, ESUG President&lt;/EM&gt;&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="89.875px" height="57px"&gt;1:05pm - 1:20pm&lt;/TD&gt;
&lt;TD width="976.125px" height="57px"&gt;&lt;STRONG&gt;What's New at SAS?&lt;/STRONG&gt;&lt;BR /&gt;&lt;EM&gt;Alice Yuan, SAS Canada&lt;/EM&gt;&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="89.875px" height="85px"&gt;1:20pm - 1:55pm&lt;/TD&gt;
&lt;TD width="976.125px" height="85px"&gt;
&lt;P&gt;&lt;STRONG&gt;Diving Deeper Into SQL&lt;/STRONG&gt;&lt;BR /&gt;&lt;EM&gt;John Fleming, Alberta Health Services&lt;/EM&gt;&lt;/P&gt;
&lt;P&gt;Often with SQL, we get some basic stuff like joins.&amp;nbsp; But is there more we can do with SQL?&amp;nbsp; Today, we are going to take a deeper look.&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="89.875px" height="57px"&gt;1:55pm - 2:15pm&lt;/TD&gt;
&lt;TD width="976.125px" height="57px"&gt;&lt;STRONG&gt;Tips &amp;amp; Tricks&lt;/STRONG&gt;&lt;BR /&gt;&lt;EM&gt;Doug Dover &amp;amp; Emily Blagdon, University of Alberta&lt;/EM&gt;&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="89.875px" height="57px"&gt;2:15pm - 2:45pm&lt;/TD&gt;
&lt;TD width="976.125px" height="57px"&gt;&lt;STRONG&gt;Networking Break &amp;amp; Refreshments&lt;/STRONG&gt;&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="89.875px" height="316px"&gt;2:45pm - 3:20pm&lt;/TD&gt;
&lt;TD width="976.125px" height="316px"&gt;
&lt;P&gt;&lt;STRONG&gt;SAS Automation for Pragmatic Randomized Trials&lt;/STRONG&gt;&lt;BR /&gt;&lt;EM&gt;Erik Youngson, Alberta Health Services&lt;/EM&gt;&lt;/P&gt;
&lt;P&gt;The BedMed Frail study is currently enrolling patients to evaluate whether time of day blood pressure medications are taken in continuing care facilities impacts patient outcomes.&lt;/P&gt;
&lt;P&gt;This talk will highlight several ways that SAS is utilized within Alberta Health Services to conduct the study including the following:&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;Identifying eligible residents&lt;/LI&gt;
&lt;LI&gt;Connecting directly to a REDCap database&lt;/LI&gt;
&lt;LI&gt;Storing data in Oracle&lt;/LI&gt;
&lt;LI&gt;Randomization&lt;/LI&gt;
&lt;LI&gt;Securely emailing randomization lists&lt;/LI&gt;
&lt;LI&gt;Emailing summary results&lt;/LI&gt;
&lt;/UL&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="89.875px" height="167px"&gt;3:20pm - 3:50pm&lt;/TD&gt;
&lt;TD width="976.125px" height="167px"&gt;
&lt;P&gt;&lt;STRONG&gt;Case Use for SAS Visual Investigator – Combating Guns and Gangs in Alberta with the Correctional Services Intelligence Unit&lt;/STRONG&gt;&lt;BR /&gt;&lt;EM&gt;Chris Gibson, Alberta Justice&lt;/EM&gt;&lt;/P&gt;
&lt;P&gt;Exploring the use of SAS Visual Investigator and analytics &amp;nbsp;in the public safety sector including correctional settings and more.&amp;nbsp; On a daily basis members of the &amp;nbsp;Intelligence unit are conducting investigations to protect the people of Alberta and suppress crime.&amp;nbsp; With the assistance of SAS technology we are seeing drastic increases in officer efficiencies and less intelligence gaps tracking both gang and firearm crimes across the province.&amp;nbsp;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="89.875px" height="57px"&gt;3:50pm - 4:20pm&lt;/TD&gt;
&lt;TD width="976.125px" height="57px"&gt;&lt;STRONG&gt;SAS Graphing Tips &amp;amp; Tricks&lt;/STRONG&gt;&lt;BR /&gt;&lt;EM&gt;Allison Scott, Alberta Health Services&lt;/EM&gt;&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="89.875px" height="57px"&gt;4:20pm - 4:30pm&lt;/TD&gt;
&lt;TD width="976.125px" height="57px"&gt;&lt;STRONG&gt;Closing Remarks&lt;/STRONG&gt;&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="89.875px" height="57px"&gt;4:30pm - 5:30pm&lt;/TD&gt;
&lt;TD width="976.125px" height="57px"&gt;&lt;STRONG&gt;Optional: Happy Hour Networking &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;/STRONG&gt;&lt;/TD&gt;
&lt;/TR&gt;
&lt;/TBODY&gt;
&lt;/TABLE&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;PDF versions of the presentations can also be found in this post.&lt;/P&gt;</description>
      <pubDate>Mon, 05 Jun 2023 17:16:31 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-User-Groups-Discussions/Spring-2023-Edmonton-SAS-User-Group-ESUG-Meeting-Presentations/m-p/879277#M415</guid>
      <dc:creator>AliceYuan</dc:creator>
      <dc:date>2023-06-05T17:16:31Z</dc:date>
    </item>
  </channel>
</rss>

