Creating an AI Assistant for SAS Viya in 5 steps (@sassoftware/viya-assistantjs) - Part I
Recent Library Articles
Recently in the SAS Community Library: SAS' @kumardeva debunks the myth that developing AI assistants is too hard. He shows you how to use the @sassoftware/viya-assistantjs library to jump start your development.
Good morning – I have basic knowledge of SAS EG. I usually make minor edits on existing program but I am trying to understand early delinquency rate by cohorts and have no idea how to go about it.
I have the following two tables and data fields:
Performance Table
loan_nbr : Unique identifier for each mortgage. Datatype varchar2.
entity_id : The code that identifies the entity. Datatype varchar2.
mthly_activity_dte : As of date. Datatype is char (YYYYMM).
active_flag : Flag to identify if the loan is in the entity's current book of business. A = Active N = Not Active.
loan_status_cde : The status of the mortgage. For active or delinquent mortgages, it is the status as of the mthly_activity_dte.
00 = Current
01 = 30 - 59 days delinquent
02 = 60 - 89 days delinquent
03 = 90 - 119 days delinquent
04 = 120 - 179 days delinquent
05 = 180+ days delinquent
06 = In Foreclosure
cur_upb_amt : The outstanding unpaid principal balance of the loan as of the mthly_activity_dte.
lpi_dte : The date of the last paid installment for the loan. Datatype is char (YYYYMMDD).
WLM table
loan_nbr : Unique identifier for each mortgage. Datatype varchar2.
entity_id : The code that identifies the entity. Datatype varchar2.
first_pmt_dte : The date of the first scheduled mortgage payment to be made by the borrower under the terms of the mortgage. Datatype is char (YYYYMMDD).
orig_dte : The date the mortgage was originated. Datatype is char (YYYYMMDD).
I am trying to pull the rate of loans that ever went 90+ delinquent (loan_status_cde = 03, 04, 05, 06) for the first year by month since first payment date. Similar to the table below.
Origination Year
Months Since First Payment Due Date
1
2
3
4
5
6
7
8
9
10
11
12
Year
Year
Year
Year
... View more
Hi all, I have some code that uses proc hpbin in SAS Viya, however everytime I try to run it in my environment - we get an error message saying that there is insufficient resources to proceed. I have tried breaking down the dataset into smaller chunks and using do loops but still have the same error. Are there any likely causes code wise or this just an environment issue? Also, are there any alternatives to using proc hpbin to perform binning? Thanks
... View more
My default region is Europe, but I need to create a course for PharmaSUG on the server for United States 1. How do I create an account away from my default region?
... View more
8:30am
Registration and Light Refreshments
9:00am
Welcome and Introduction Karine Désilets, Canada Revenue Agency
9:10am
SAS News Alice Yuan, SAS Canada
A quick look at new developments in the world of SAS.
9:20am
SAS Innovate Debrief Joe Furbee, SAS US
This session will provide an update on the latest news from SAS Innovate, which took place in April 2024.
10:00am
Wrangling Excel Sheets Tom Kari, Tom Kari Consulting
A comprehensive fix for all your Excel import needs.
10:30am
Break, Networking, and Job Exchange Table
10:45am
SAS Viya and Open Source: Better Together Thomas Hindle, SAS Canada
This presentation will cover two of the main ways that open-source programmers can integrate with SAS Viya.
11:25am
Modernizing 1,000 SAS® Users on Multiple Legacy SAS Solutions Pierre Dupuis, Desjardins
Desjardins' modernization journey to SAS® Viya® on Azure - Sharing challenges, successes and lessons learned.
11:55am
Closing Remarks and Prize Draw
Register Now
... View more
Get ready to reignite connections, forge new ones, and exchange insights over a delicious lunch. Whether you're a seasoned SAS User or just starting to dip your toes, you will get a chance to engage with like-minded peers.
11:30 AM - 12:00 PM
Registration and Networking
12:00PM - 12:30PM
Welcome Remarks and SAS Updates Alice Yuan, SAS Canada
Alice will welcome everyone back and share resources details about upcoming events. We will also share a survey link and QR code for you to share your suggestions and thoughts to help us plan future user group meetings.
12:30PM - 1:30 PM
Lunch, Cake, & Networking
Come enjoy some lunch with a side of great conversations!
Register Now
... View more