The yearly Juletip is now finished for this year. 🎄We hope that you got some tips and tricks this year as well!' Best wishes for Christmas from the FANS Nordic Team.💚 And we look forward to a new FANS Year next year.💚     ... View more

*AI was used as much as possible to create this tip! A few years ago, I was at a restaurant and overheard a conversation about splitting a massive Excel file into smaller ones based on unique values in column X. They estimated it would take 10 weeks and likely lead to a mental breakdown from copying and pasting thousands of rows. Clearly, they weren't SAS users!   After experimenting with various AI tools and facing several unfulfilled requests, I found a straightforward solution. It may not be the most efficient, but it serves as a great generic example. Here's the code, the best documentation I've (AI) ever written, and a bit about the process.   /** * Macro to split a dataset into multiple datasets based on unique values of a specified column. * * Parameters: * - DSN: The name of the input dataset (default is sashelp.class). * - Column: The column based on which the dataset will be split. * - Prefix: The prefix for the names of the output datasets. * * Usage: * %split_dataset(DSN=sashelp.class, Column=SEX, Prefix=SEXSplit_); */ %macro split_dataset(DSN=sashelp.class, Column=SEX, Prefix=Split_); /* Get unique values from the specified column */ proc sql noprint; select distinct &Column into :values separated by ' ' from &DSN; quit; /* Use proc contents to get the column type */ proc contents data=&DSN out=colinfo(keep=name type) noprint; run; data _null_; set colinfo; if upcase(name) = upcase("&Column") then do; if type = 2 then call symput('coltype', 'char'); else if type = 1 then call symput('coltype', 'num'); end; run; /* Testing - Print the column type */ /* %put Column type: &coltype; */ /* Loop through each unique value and create a new dataset */ %let i = 1; %do %while (%scan(&values, &i) ne ); %let value = %scan(&values, &i); %put Processing value: &value; %if &coltype = char %then %do; data &Prefix.&value; set &DSN; where &Column = "&value"; run; %end; %else %do; data &Prefix.&value; set &DSN; where &Column = &value; run; %end; %let i = %eval(&i + 1); %end; %mend split_dataset; /* Example usage */ %split_dataset(DSN=sashelp.class, Column=Age, Prefix=AgeSplit_); Here is the first prompt where it all started: Next phase is feedback the log to AI until it works, or ask for new features or ask it to explain some parts of the code to you. Some prompt examples I tried on the way. One interesting point was to request complexity analysis for the algorithm in the code. This is not very often done and if development is done with small sample data, this could be very useful! Earlier I have been positively surprised about some OS level limitations info and some security analyses AI does.   After the macro was done I decided to make it a custom step in SAS Studio and it was super easy with this helpful guide: https://www.youtube.com/watch?v=yKdCwNLEhUI  ... View more

Yule Tip #19 is for all the merry Enterprise Guide users. If you are an EG user and sometimes run flows with multiple data steps or SQLs, you might find this tip useful. Run the code below and you’ll see the SYSECHO messages in the data step code, displayed in EG’s Submission Status panel. Consider a program with several and longer data steps - putting in a few SYSECHOs would give you a much better idea where you are in your flow, comparing to just seeing “Running DATA step…”. Try it out.   data _null_; sysecho "Starting a really big batch job..."; s = sleep(3); run; data AllCars; sysecho "Reading data about all sorts of cars"; set SASHELP.CARS; if _N_ = 1 then s = sleep(2); run; data SwedishCars; sysecho "Reading data about Swedish cars"; set SASHELP.CARS; where Make in ('Saab','Volvo'); if _N_ = 1 then s = sleep(2); run; Documentation on SYSECHO: https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lestmtsglobal/p1h1e01yyff0fon1iyh0mk51maf2.htm ... View more

Hello, Juletip readers! I hope you’ve been enjoying the series as much as I have. Today, I’d like to share a story from my world—healthcare—and show how AI is making a real difference.   Why AI Matters in Healthcare When it comes to health data, three key priorities stand out: Trust and Security: Patient data must stay safe, and insights need to be reliable for everyone. Bringing Data Together: Healthcare decisions rely on combining many types of information—medical records, test results, and even social factors. This has to happen quickly. Making it Easy: Tools should be simple enough for busy doctors, nurses, and even patients to use, no coding or tech expertise required. At SAS, I'm proud to say that we're able to tick all these boxes—and nowhere is this more exciting than with our RAAD solution described below.   Spotlight on RAAD RAAD (Rapid AI-Augmented Diagnostics) is an AI-powered tool we’ve developed in collaboration with Lillebælt Hospital’s Emergency Department.   Here’s how it works: When a patient is admitted to the Emergency Department, a blood sample is drawn and analyzed. The results are then processed through RAAD, which uses advanced algorithms to identify patterns or abnormalities. This analysis is presented to the clinical team in near real-time, providing augmented diagnostic recommendations to support their decision-making.   What’s great about RAAD is that it doesn’t replace the expertise of healthcare professionals—it enhances it. With these insights, clinicians can determine the best next steps more efficiently, ensuring that patients receive timely and accurate care.   The impact has been impressive: faster diagnostics, reduced workload for overburdened staff, and better outcomes for patients. RAAD is already making waves in Denmark, and we’re hopeful it will soon bring the same benefits to hospitals in Norway.   As we fine-tune the system, it’s thrilling to think about how this technology could change healthcare—and even inspire innovations in other fields.   With excitement for Dec. 25th and all the days after, Terry   ... View more

Well, a new SAS developer portal may not be on the top of your Holiday wish list; however, fear not, it’s there! Earlier this year SAS released a new version of developer.sas.com. Please feel free to check it out.    You'll notice that the SAS Viya API documentation is front and center (as should be the case with any developer portal). But wait, there's more. We scoured SAS digital resources and have identified over 200 developer- and API-related use cases. If you're an open source developer, we've got assets to help get you started and interface with SAS Viya.   SAS programmers, you're covered as well. We have a section on the page dedicated to our various SDKs. Further, we have added resources for SAS solutions and technologies which covers things like SAS Viya Workbench, Trustworthy AI, and Customer Intelligence 360, all geared towards developers. Finally, we have links to the Developers Community and the sassoftware resources on GitHub. It's truly one stop shopping.   We have received very positive feedback from both SAS employees and our users. It let’s us know our hard work is paying off.   This is only the beginning though and we will continue to refine the user experience, add content, and one day have an interactive “Try It” button for our APIs. We are striving to deliver an award worthy product! ... View more