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

I'm making a pChart using PROC SHEWHART, and my subgroups (lots) have varying sizes.  I want to give each lot the same weight when calculating pbar, rather than let lots with larger sample sizes have more weight.   I assumed PROC SHEWHART would have a WEIGHT statement, but it does not.  My next thought is to calculate pbar myself, and then pass the value to SHEWHART via the p0 option on the pchart statement.  Does this seem like a reasonable approach?   As an example, given data like:   data have ; input lot pfailed ntested ; cards ; 1 .1 20 2 .2 20 3 .1 20 4 .2 20 5 .4 60 ; PROC SHEWHART will calculate pbar as a weighted mean of the proportions, giving lot 5 more weight than the other lots, and you get pbar=.26.   proc shewhart data=have ; pchart pfailed*lot/subgroupn=ntested dataunit=proportion; run ; My thought is to calculate pbar myself as the unweighted mean, and you get pbar=.2, and pass that value to PROC SHEWHART:   proc sql noprint; select mean(pfailed) into :pbar trimmed from have ; quit ; %put &=pbar ; proc shewhart data=have ; pchart pfailed*lot/subgroupn=ntested dataunit=proportion p0=&pbar; run ;   ... View more