Join this webinar to learn techniques for interpreting machine learning models and how to use them in SAS® Viya®.   You will learn: What are black box models? Why interpretability matters. When to distinguish between local and global explanations. Register Now   ... View more

Looking to streamline your model development process? Or perhaps you’d like to enhance cross-team collaboration. In either case, we’ve got you covered.   You will learn about: Auto-tuning multiple statistical and machine learning models. An enhanced modeling approach and fine-tuning advanced ML algorithms. Easily building sophisticated data visualizations. Responsible AI, fairness, bias and interpretability. A comprehensive approach to model assessment. Extensive methods for model tournament and deployment. Register Now   ... View more

SAS® Customer Intelligence 360 users: want to streamline your team’s campaign design process? We’ll show you how the new task design experience will maximize your efforts.   You will learn how: The new campaign task design experience is different, and why. To manage creatives both within and outside of a campaign’s task. To personalize your marketing content for your campaigns. Best practice approaches to creating tasks to support your campaigns. Register Now   ... View more

Join us for a morning of learning and connecting at the National Arts Centre in the Salon Room.   Agenda   8:30am - 9:00am Registration & Refreshments 9:00am - 9:05am Welcome Remarks OASUS Committee 9:05am - 9:20am SAS Innovate 2025 Highlights Sylvain Tremblay, SAS Canada 9:20am - 10:05am SAS®9 to SAS® Viya®: How to Streamline Your Migration Eric Lacombe, Ernst & Young LLP 10:05am - 10:35am SAS Discovery Tools Frank Scott, SAS Canada 10:35am - 10:55am Networking Break and Jobs Table 10:55am - 11:25am Gen AI: Synthetic Data in the Public Sector Arnold Toporowski, SAS Canada 11:25am - 11:55am CGC Migration to ELA Kevin Morgan, CGC 11:55am - 12:00pm Closing Remarks               Register Now   ... View more

Another eSUG Meeting in the books! 🕺   It was a gloomy day, but it was brightened up by lots of presentations and discussions about AI and LLMs. It's always a great day to learn. 😉   Thank you to all of our presenters for sharing their knowledge. Thank you to everyone who came out to join us and make the meeting another fruitful one. Made better by the Oilers winning the series and moving on to Round 3! 💪   If you have something to share with the group - a 2 min tip/trick, a cool project you recently worked on, review on a SAS book you got from the meeting - please let us know. 😁   Here is the agenda for your reference. You will also find the presentations attached to this post.   8:30am - 9:00am Registration and Refreshments 9:00am - 9:05am Welcome Remarks Doug Dover, eSUG President 9:05am - 9:20am What's New at SAS? Alice Yuan, SAS Canada 9:20am - 9:50am SAS Innovate 2025 Highlights Walie Aktary (@speaker), SAS Canada Won't be able to attend SAS Innovate this year? Hear about the major announcements and hot topics from this year's conference. 9:50am - 10:20am How Computers Understand & Generate Language: From Basics to Breakthroughs in Large Language Models (LLMs) Mehrdad Yousefpoori-Naeim, Government of Alberta 10:20am - 10:40am Networking Break 10:40am - 11:20am How to Make Your LLM Work For You @Sundaresh1, SAS US (Virtual Presentation)   Join SAS expert, Sundaresh Sankaran, as he explores the core techniques for effectively building with large language models (LLMs). 11:20am - 11:50am SAS Observability Tools @nicosigal, SAS Canada 11:50am - 12:00pm Closing Remarks ... View more

Doubletree by Hilton | Ovation   13h00 - 13h30 Inscription et rafraîchissements légers 13h30 - 13h35 Mot de bienvenue 13h35 - 13h55 SAS Innovate 2025 Highlights Sylvain Tremblay, SAS Canada 13h55 - 14h40 Recette de migration vers Viya chez Desjardins Frédéric Gendron, Desjardins 14h40 - 15h10 Pause 15h10 - 15h55 État SAS 9.4 et présentation de SAS Workbench Robin Drolet, SAS Canada 15h55 - 16h10 Comment mieux profiter de vos produits et solutions SAS Cemre Uzunmehmetoglu, SAS Canada 16h10 - 16h30 MONSUG Planning Committee - Call for Volunteers 16h30 - 17h00 Mot de la fin 17h00 5 à 7    Register Now   ... View more

Register Now   ... View more

Watch this Ask the Expert session to learn how to render SAS results into Microsoft PowerPoint format.   Watch the Webinar   You will learn how to: Use SAS Output Delivery System (ODS) code. Modify result formats in SAS Enterprise Guide. Create PowerPoint outputs in SAS Studio. Add stored processes and tasks in PowerPoint with SAS Office Analytics.   The questions from the Q&A segment held at the end of the webinar are listed below and the slides from the webinar are attached.   Q&A   How do you get the SAS plug in for PowerPoint? How do we get the SAS add-in for MS office? You will need the SAS MS Add-In license; you can speak to your sales representative if you're interested in that.   Maybe I missed but how can we add the SAS plugin to PowerPoint/excel/word? Again, you'll have to have the appropriate license. So, you'll have to talk to your sales representative and inquire about SAS Office Analytics and SAS Microsoft add in application.   Can you edit tables and graph in PowerPoint after inserting? You can edit the created tables in PowerPoint, but not the graphs. However, this is not recommended, you should do all your data table manipulation before creating your PowerPoint results.   Can ODS PowerPoint save .pptx? Yes, ODS PowerPoint can save .pptx files.   Does this also support .pptx format files? Not pptx? Can the extension file of the PowerPoint file be a .pptx or it should only be .ppt? The .ppt file format is an outdated PowerPoint file format, which was replaced in 2007 by the .pptx file format. Has SAS made updates to allow creation of .pptx files? Yes, the file extension can be .pptx   What if my company requires use of a specific PPTX template on all slides- is it possible to generate PPTX files using or honoring that template from SAS, or would we have to revert to copy/paste? You would have to create your SAS results first, then copy and paste to your company template.   When the output is written to ppt, are the tables live in terms of each column/row can be edited or is it written without editing capabilities? You can edit the created tables in Powerpoint, but not the graphs. However, this is not recommended, you should do all your data table manipulation before creating your PowerPoint results.   From EG ODS PowerPoint statement, can you specify a pre-defined 'blank' page like the blank slide you showed in SAS Microsoft add-on? No, there is no option that will insert a blank slide, but you can add ODS startpage = NOW; in between procedures to ensure new procedure results start on a new page.   Is the SAS add-in in MS Office the only way to output to a design template? Or could I do this directly from SAS PC 9.4? Designing a custom PowerPoint template in SAS PC 9.4 can be done with Proc Template. Here is a link to a helpful paper.   Can you build interactive reports in PowerPoint? No, it's pretty much a static PowerPoint result. The add-in gives you the most type of interactivity in that you're working directly in SAS in PowerPoint. If you're building your tasks, you're already in PowerPoint with the add-in, but not with the ODS statements.   The main issue I've had with ODS PowerPoint is that it adds cell padding to the bottom of cells. If I make the same table in RTF, the table is more compact when I copy that into PowerPoint vs using ODS PowerPoint directly. In the past, I've been told it's not possible to remove this padding. Has this been updated at all? It makes tables that should fit a slide not fit at times. Try creating a custom Style with Proc Template:   proc template;     define style styles.custom;         parent = styles.powerpointlight;         style Graph from Graph /             padding = 0;     end; run;   Link to Padding= Documentation   How can we preview the styles in SAS PC (9.4)? You can create a list of the style names in SAS PC 9.4, but there is no option to preview. proc template;  list styles; run;   My SAS add-ins to Microsoft crashes all the time, do you know what could be the reason for that? I'm not sure. You're going to have to check with our Technical Support on that one.   How can we put multiple output results into one slide? Try adding the LAYOUT= TWOCONTENT to your ODS statement. Keeping in mind that the size of your results may not fit on one page even with this option. You may need to add other options to reduce the size of your output. Consult the documentation. ods powerpoint file="c:\temp\test.pptx"  layout=twocontent;   Is it possible to insert a slide to an existing PowerPoint (using either enterprise guide or SAS studio)? The file created with the ODS PowerPoint statement will be overwritten every time you execute the code, so you would have to copy and paste to an existing presentation to avoid overwriting it.   My organization has a PowerPoint style template. Is there any way in SAS to use that style template easily, or would this require working with PROC TEMPLATE instead? Can you use a customized PPT style? Yes. After you have created your .pptx file with the ODS PowerPoint statement. Open the created file in PowerPoint, go to the Design Tab, and choose your customized style. Or, copy and paste your SAS PowerPoint results into your company template.   Is the output in an accessible format when put into PowerPoint? Overview of the Accessibility System Options   Can we specify a slide number to insert output? A slide number, there should be an option for that. We'll have to explore the options. It should be able to specify a slide number. So, I should have mentioned that there are additional options you can add to that ODS statement where you can do a little bit more with the output. I just wanted to show you the basics in all the interfaces today. But there's a lot of customization that you can do with different options on that ODS statement. Slide numbers are turned on with the global options statement: Options number; You cannot specify a specific slide number to insert output;   Is there a way of setting the no. of pages? That's exploring the options. So, you want to take a look at the documentation on the ODS PowerPoint statements, specifically for PowerPoint and explore all the options. Slide numbers are turned on with the global options statement: Options number;   In EG, how do you select just one output (a bar chart, for example)? If you're using the task, then it would be the output for that bar chart task and then you would go into the properties of that bar chart task and only choose the options for PowerPoint for that particular task, if I understand the question correctly. OK, so it's a matter of just choosing that task and that result.   If I'm running separate pieces of code that produce different charts, can SAS insert the charts in separate slides? The code does not use by statements. So, you have multiple procedures. I only had a one procedure, the PROC print, but I could have had a PROC print, PROC frequency, PROC univariate, multiple procedures. Long as you've got that ODS statement at the top, it's open, ODS close. All the results from all those different procedures will go to the same file specified. You can apply it to multiple procedure results. I only showed you one procedure, but it could be multiple procedures. So, all those procedure results will go to the same file and all separate slides would be created. ODS STARTPAGE = YES;   inserts a new slide at the start of each new table or graph   Can Visual Analytics reports be converted to PowerPoint? In Visual Analytics, you can export and image which saves as a .PNG file that you can copy and paste to PowerPoint.   Can I create PowerPoint results directly from a SAS table? No, PowerPoint results can only be created from a Procedure result.   Are the results in PowerPoint dynamic, meaning if source files changes do they update? Only in the MS-Add-in, you can refresh the results. If using the ODS statements, you must re-run the code to re-create the output .pptx file.   Testing on SAS EG and getting the following error: ERROR: Insufficient authorization to access /opt/sas/Config/Lev1/SASApp/c:\ppttest.ppt. Yeah, that's a Technical Support question. Just check the file path that you have a proper file path that you're writing to.   Is there somewhere to see examples of all of the different styles for people who use SAS Studio? Maybe a link? You can create a list of the style names, but there is no option to preview.  proc template;  list styles; run;   Hello, can you create one in Enterprise Guide? If you're writing code in Enterprise Guide, just use those ODS statements. If you're using the tasks, you're going into the properties of the task and changing the results options.     Recommended Resources Creating PowerPoint Output Setting PowerPoint Results Options SAS® Programming 1: Essentials SAS® Office Analytics: Getting Started Please see additional resources in the attached slide deck.   Want more tips? Be sure to subscribe to the Ask the Expert board to receive follow up Q&A, slides and recordings from other SAS Ask the Expert webinars. ... View more

Join this webinar to learn how Large Language Models (LLMs) - ChatGPT, Claude, and DeepSeek, for example - can be seamlessly integrated into the SAS 9.4 environment.   You will learn: How to call and interact with LLMs using PROC HTTP in SAS. How SAS Macro Language can be repurposed to dynamically structure prompts and automate AI-driven responses. Techniques to refine and control LLM responses, ensuring they are relevant and useful for SAS-based workflows. Register Now   ... View more

Join this webinar to learn how to modernize information delivery across your organization.   You will learn: The experience of accessing SAS content through Microsoft 365. What it’s like to create new content in SAS® Viya®. About the wider array of analytics and procedures not available in SAS®9. The migration process for SAS®9 content included in Microsoft Office documents. Register Now   ... View more

We'll take a look at the multiple pathway options when transitioning from SAS Enterprise Guide to SAS Viya. Plus, get a comparison of SAS Studio features.   You will learn: What options are available to a SAS Enterprise Guide user transitioning to Viya. How SAS Enterprise Guide compares to SAS Studio. About additional benefits gained with SAS Viya. Register Now   ... View more

Want to uplevel your customers' experience? We'll show you a powerful tool to enhance your marketing with deep customer analytics.   You will learn: How to use the power of personalized web and mobile app experiences to drive conversions. Best practice approaches to configuring behavior and identity tracking. Which Customer Intelligence 360 data tables to explore for deeper analysis. Register Now   ... View more

Join this webinar to explore the possibilities of no-code real-world evidence analytics in SAS® Viya®.   You will learn: How custom steps and SAS Visual Analytics can automate no-code analytics. To use analytics visualization for real-time model decisioning. How to choose a correct propensity score matching model. What methods to use for causal inference after matching. Register Now   ... View more

Watch this Ask the Expert session to learn how to automate the conversion of JSON files to streamline projects.   Watch the Webinar   You will learn how to: Seamlessly automate the JSON conversion. Enhance data integrity and regulatory compliance. Provide scalable innovation for broader business impact.   The questions from the Q&A segment held at the end of the webinar are listed below and the slides from the webinar are attached.   Q&A Just curious, why Proc JSON, Proc Import or Proc DS2 was not used to read your file. At the time when the solution was presented, I wasn't aware of PROC JSON. When I looked at the complexity of JSON, and I'm more familiar dealing with Python, I felt like Python was a more optimal solution to deal with this challenging situation. Also, I know SAS is quite IO intensive, so I had a feeling that having to deal with these many files would be quite cumbersome from a coding perspective. That's why we decided to go with the Python integration.   What types of data other than lab data might use a JSON format? It totally depends upon the vendor. Most vendors are not comfortable in delivering the data or formalizing the data in SAS data sets, most of them are comfortable in delivering ASCII files or CSV files. They can take any data, and they can transfer any data into the JSON format, which I believe is now going to be the universal format going down the road, but it's not universally accepted. But again, comes down to the vendor.   Would we be able to format data from CSV into JSON? https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/p0ie4bw6967jg6n1iu629d40f0by.htm I think it might make more sense to first read the CSV into a SAS table and then export to JSON. proc json out="C:\Users\myuserid\JSON\Output.json"; export work.mydata; run;   If you have a column in a SAS file that has a text field in JSON style (concatenation of several key-value), what is the fastest way to reconvert that field into a new SAS table with all the fields found in the key-value combination? From my perspective, I would want to see what that pattern is within the dataset and without seeing the actual value, it's hard for me to visualize. But if I understand that question correctly, I think one of the fastest ways you can do is using the perl regular expression on that specific column containing JSON type key-value combination. You can use that to particularly parse the value, or the JSON formatted value, within that column and then you can use that to extract the specific values you need for your SAS data sets. From there, you can create new data sets for those values that isn't there. I don't know whether I answered the question correctly, but that would be an optimal way to do it. For those who are not familiar with PERL expressions the fastest and most robust method to parse and reconvert this into a structured SAS table is by leveraging SAS's native JSON parsing capabilities available in PROC DS2 or by using custom parsing logic through PROC JSON and DATA step programming. For reliable, scalable, and performance-based approach you can try the below approach: PROC DS2 JSON Package (Recommended if you have access to SAS Viya or newer SAS versions): SAS DS2 provides native JSON parsing methods that efficiently convert JSON strings into structured data directly. Example 1: proc ds2; data new_dataset (overwrite=yes);                dcl package json j();                dcl varchar(32767) json_text;                dcl varchar(256) key value;    method run();         set original_dataset;         json_text = json_column;         j.createParser(json_text);         do while (j.getNextToken() ^= 0);             if (j.isKey()) then do;                 key = j.getText();                 j.getNextToken();                 value = j.getText();                 output;             end;         end;     end; enddata; run; quit; If DS2 is not available then you can try the below approach: Example 2 (DATA step code with JSON parsing functions (JSON libname engine) to convert JSON strings): filename tempjson temp; data null;                set original_dataset;                file tempjson;                put json_column; run; libname jsontmp json fileref=tempjson; data parsed_json;                set jsontmp.alldata;  run; Example 3 (PERL Regx): data parsed_regex;                set original_dataset;                length key value $256;                 retain prx_key_val; if n = 1 then prx_key_val = prxparse('/"([^"]+)":\s*"([^"]+)"/'); start = 1;                stop = length(json_column); do while(prxmatch(prx_key_val, json_column, start));     call prxposn(prx_key_val, 1, start, len_key);     key = substr(json_column, start, len_key);     call prxposn(prx_key_val, 2, start_val, len_val);     value = substr(json_column, start_val, len_val);     output;     start = start_val + len_val; end; run;     What software are you using for your trigger events to start your SAS code? We're working on our Windows Server 2012. Once the entire process is done, one of the key challenges that we had was because the data ETL process automation. In our server, we were using Anaconda Python which works differently than the regular Python. So when you have an Anaconda Python processing, the way that Anaconda server needs to be started is completely different from a regular Python process. So having said that, there was a different batch process that needs to be set up to trigger that Python process. But to answer your question, we're running on Windows 2020 12/20/22 server. It was a Windows scheduler that was set up to be monitored at that set frequency that we know where the data was supposed to come in. Every 3rd Monday, the process was set up to kick off. We also set it up to be monitoring the set location for data drops every 5 minutes. So that is how the process will be kicked off.     Recommended Resources CDISC | Clear Data. Clear Impact. Working with Dataset-JSON using SAS Introducing JSON Please see additional resources in the attached slide deck.   Want more tips? Be sure to subscribe to the Ask the Expert board to receive follow up Q&A, slides and recordings from other SAS Ask the Expert webinars. ... View more

8:30am - 9:00am Registration and Refreshments 9:00am - 9:05am Welcome Remarks Doug Dover, eSUG President 9:05am - 9:20am What's New at SAS? Alice Yuan, SAS Canada 9:20am - 9:50am SAS Innovate 2025 Highlights Walie Aktary, SAS Canada Won't be able to attend SAS Innovate this year? Hear about the major announcements and hot topics from this year's conference. 9:50am - 10:20am TBD 10:20am - 10:40am Networking Break 10:40am - 11:20am How to Make Your LLM Work For You Sundaresh Sankaran, SAS US (Virtual Presentation) Join SAS expert, Sundaresh Sankaran, as he explores the core techniques for effectively building with large language models (LLMs). 11:20am - 11:50am TBD 11:50am - 12:00pm Closing Remarks   Register Now   ... View more