Hello,   I have 9 records that contain missing SI values (in 10^9/L - LBSTRESU) for paramcd= 'EOS' test while raw values (in % unit- LBORRES) are provided,  I would need to add the following derivation to  convert values to the SI units in my analysis dataset (variable AVAL ) to handle the missing values while raw values (in % unit) are provided:   EOS (SI unit, 10^9/L, Column AVAL) = WBC (10^9/L, Column AVAL from WBC test at the same time/visit - AVISIT) x EOS in percentage % (Column LBORRES from EOS test at the same time/visit - AVISIT) , where WBC is the lab result from the same patient at the same time/visit (i.e., both WBC and EOS are collected at the same time - AVISIT).   current data (green are missing - need calculated values):     want (calculated values are color-coded. Previously green colored - eg 4.5 * .04 = 0.18)   attached is the data in excel format (sheet 3)     Thank you very much! ... View more

For the Curious, Passionate, and Creative   In a world facing a number of challenges, the future presents exciting opportunities to make a real impact. Data has become central to nearly every aspect of society, offering unlimited potential limited only by imagination. At the heart of this transformation are SAS data and AI solutions, which provides global organisations with trusted insights during critical moments—fuelling bold innovation across industries. For decades, SAS has partnered with universities to nurture the next generation of analytics leaders. Yet, the global demand for analytics talent continues to outpace supply. A recent McKinsey survey highlighted a significant shortage of qualified professionals in key tech areas, reflecting a persistent skills gap across the STEM landscape. Despite this, immense opportunities exist for both educational institutions preparing future tech leaders and students looking to gain a competitive edge in their careers. This Lunch & Learn workshop was held in collaboration with:              Students explored how data and analytics could shape their futures, while sharing the inspiring ways these skills had already empowered countless graduates to succeed.                                     The session covered: SAS Skill Builder Program Overview – Students were introduced to free e-learning resources and valuable certification pathways recognised by industry leaders. • Hands-on Experience with the NEW SAS® Workbench for Learners – Attendees explored a cloud-based compute environment perfect for working on data science projects using SAS or Python.  Connecting with Employers Seeking SAS Skills – The workshop highlighted the @sas.ribit.net platform, which connects skilled students with organizations actively seeking analytics talent. Keen to join in future activities – Register your interest on the SAS® Student Connection program here: https://www.sas.com/en_au/learn/academic-programs/resources/student-series.html   ... View more

    New Features Coming Soon: Customer Journeys   Often marketing campaigns are more than a one-time email blast. Many campaigns involve an orchestrated series of touchpoints across multiple channels.   In Q2 SAS will be rolling out a new Customer Journey feature. This new capability compliments 360 Activities. The new journey feature is designed to support scheduled bulk-oriented campaign experiences – like Brand Awareness, Product Launch, Seasonal Campaigns, Event Promotions, Customer Onboarding, etc. Activities work well for 1:1 real-time always-on campaigns triggered by the behavior of a known or anonymous customer.   To differentiate the 2 capabilities, Activities will be re-named “Real-time Journeys”, and the new bulk-oriented journeys will be under “Scheduled Journeys”. Marketers will enjoy a new modernized drag-n-drop journey builder canvas for both.   Real-time Journeys typically start with a Triggered Event, followed by Triggered Tasks, Web and/or Mobile Spots. Scheduled Journeys start with an Audience, followed by Bulk Tasks. Initially Email and Custom Tasks will be supported. Support for Push Notifications, SMS and Advertising Tasks (e.g. Google, Facebook, etc.) will follow. Note: 360 Audiences is necessary to execute a Scheduled Journey Both employ various Wait and Split decision nodes to orchestrate the experience.     Scheduled Journeys introduces many additional features to help you measure, monitor and maximize your campaigns.   Highlights: Performance Goals – classify the journey’s purpose (e.g., Onboard, Purchase), set a target goal (e.g., 10,000 purchases), and define success events (e.g., Online Purchase w/ SUMMER25 coupon) Entry Conditions – control if or when customers may re-entry a journey Drop Conditions – set event triggers to remove someone from a journey (e.g., made a purchase, registered for a program, used a coupon, asked not to be contacted) Personalize – use Split decisions to personalize the path and touchpoints delivered to a subset of the audience, use audience and event attributes to personalize content within touchpoints (e.g. “Hi %%FirstName%% here’s a discount code for %%ProductViewed%%”) Schedule Runtimes – flexible options allow you to start a journey as often as hourly or less frequently such as every Monday at noon, 1 st of the month, last Friday of the month, etc. Insight Reports – see how the journey is performing against your target goal, how customers are flowing through the various paths and understand how the conversion rate for this journey compares against other journeys with the same purpose. Test – apply a holdout control group to understand impact of any given journey   Stay tuned for more details soon! The original author of this post is @MarkKorey_sas  ... View more