Automating SAS processes using Windows batch files
Leonid Batkhan shows you how to write Windows batch scripts that allow for conditional execution and effective job scheduling.
Tag: SAS Programmers
Getting Started with Python Integration to SAS® Viya® - Part 9 - Summarize Columns
Welcome to the continuation of my series Getting Started with Python Integration to SAS Viya. In previous posts, I discussed how to connect to the CAS server, how to execute CAS actions, and how to filter CAS tables. Now it's time to focus on how to summarize columns. Load and explore data Let's first load
The ADDROWID data set option maintains the order of your data when executing a DATA step in SAS® Cloud Analytic Services (CAS)
SAS' Kevin Russell compares how you order your data with a BY statement in SAS 9.4 versus in CAS using the ADDROWID data set option in SAS Viya.
Getting Started with Python Integration to SAS® Viya® - Part 8 - Creating Calculated Columns
Welcome to the continuation of my series Getting Started with Python Integration to SAS Viya. In previous posts, I discussed how to connect to the CAS server, how to execute CAS actions, and how to filter CAS tables. Now it's time to focus on creating calculated columns on a CAS table. Load and explore
SAS open-source treasures from around the world: SASjs
Veteran SAS user Leonid Batkhan introduces you to open-source SASjs framework.
Solve the Missionaries and Cannibals Problem with SAS
The Missionaries and Cannibals Problem (MCP) is a classic river-crossing logic puzzle. With SAS, we can solve this problem, visualize the solutions with SAS NETDRAW procedure and generate steps for any MCP problems.
Jedi SAS tricks: resizing, renaming and reformatting your data
SAS' Mark Jordan shows you how to modify data using PROC SQL, PROC DATASETS and SAS macros.
Solve "A Puzzle for Pirates" with SAS
This article introduces how to solve the pirate game with a recursive solving algorithm in SAS, and how to analyze and visualize the law behind the complex logic of the pirate game. If you join in a pirate game next time, you can know your destiny ahead of time to reap the benefits and avoid getting killed.
Getting Started with Python Integration to SAS® Viya® - Part 6 - Descriptive Statistics
Welcome to the sixth installment in my series Getting Started with Python Integration to SAS Viya. In previous posts, I discussed how to connect to the CAS server, how to execute CAS actions, and how to work with the results. Now it's time to generate simple descriptive statistics of a CAS table. Let's begin
Introducing TRIMS function to remove any leading and/or trailing characters from SAS strings
Leonid Batkhan introduces multipurpose TRIMS function that removes any leading, trailing or both leading and trailing characters from SAS strings.
Jedi SAS Tricks: 5 Ways to Make Your SAS Code Run Faster
Tired of waiting for answers? Then make your SAS code run faster with these 5 tips.
Removing trailing characters from SAS strings
SAS' Leonid Batkhan shows how to cut away ANY unwanted trailing characters (not just blanks) from SAS text strings to clean up your data.
Removing leading characters from SAS strings
SAS' Leonid Batkhan shows you how to remove ANY leading characters (not just blanks) from text strings to tidy up your data.
Two New SAS® Viya® Programming Certifications
SAS Global Certification is pleased to announce two (yes two!) new SAS Viya programming certifications. Traditional SAS programmers need to migrate their code and data to SAS Viya environments, and there are important skills required to make a successful transition. SAS Viya includes Cloud Analytic Services (CAS), where data is
Using SYSTASK and SAS macro loops for massively parallel processing
SAS' Leonid Batkhan presents an implementation of parallel processing by spawning multiple SAS sessions using SYSTASK statements with subsequent synchronization.
SAS Global Forum: Your experience, your way
It’s safe to say that SAS Global Forum is a conference designed for users, by users. As your conference chair, I am excited by this year’s top-notch user sessions. More than 150 sessions are available, many by SAS users just like you. Wherever you work or whatever you do, you’ll
Registration is open for a truly inspiring SAS Global Forum 2021
SAS Global Forum 2021 will be jam-packed with inspiring content. Register today to ensure you don't miss a second of this year's event.
Using shell scripts for massively parallel processing
SAS' Leonid Batkhan explores shell scripting as an alternative way to implement parallel processing.
To be and not to be – the uncertainty principle in SAS
If I were to say that we live in uncertain times, that would probably be an understatement. Therefore, I won’t say that. Oops, I already did. Or did I? For centuries, people around the world have been busy scratching their heads in search of a meaningful answer to Shakespeare’s profoundly
How to conditionally stop SAS code execution and gracefully terminate SAS session
SAS' Leonid Batkhan reveals a fuss-free way to halt SAS program execution and terminate SAS session in batch-processing scenarios.
How to conditionally execute SAS global statements
SAS' Leonid Batkhan reveals coding techniques that give you control of when and whether global statements are executed.
What makes SAS Global Forum great?
The people, the energy, the quality of the content, the demos, the networking opportunities…whew, all of these things combine to make SAS Global Forum great every year. And that is no exception this year. Preparations are in full swing for an unforgettable conference. I hope you’ve seen the notifications that
Deleting a substring from a SAS string
SAS' Leonid Batkhan shows you how to delete a substring from a character string - one of the common character data manipulation tasks.
Turning external files into SAS® data sets: common problems and their solutions
Amber Elam of SAS Technical Support reveals common challenges and solutions when you convert external files into SAS data sets.
Inserting a substring into a SAS string
SAS' Leonid Batkhan demonstrates a common character data manipulation task of inserting a substring into a character string.
Game on! Here's a fun way to learn SAS
SAS' Leonid Batkhan encourages you to join him at SASensei, an independent, third-party online SAS learning resource (game).
Running SAS programs in parallel using SAS/CONNECT®
SAS' Leonid Batkhan demonstrates a popular "divide-and-conquer" efficiency strategy using SAS/Connect®.
2020 roundup: SAS Users YouTube channel how to tutorials
Find out the most popular SAS Users YouTube channel how to tutorials, and learn a thing or two!
Moving from SAS Enterprise Guide to SAS Studio
If you're a SAS Enterprise Guide user who is looking to move to SAS Studio, there is a lot to like about your new coding environment.
Removing repeated characters in SAS strings
SAS' Leonid Batkhan explains the data cleansing task of removing unwanted repeated characters in SAS character variables.