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.
Tag: SAS Programmers
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.
Using Microsoft Excel functions in SAS
SAS' Leonid Batkhan summarizes a lesser known but useful feature in SAS that allows you to bring Microsoft Excel functions into your SAS programs.
How to refactor SAS code to leverage SAS Viya
If you're a SAS programmer who now uses SAS Viya and CAS, it's worth your time to optimize your existing programs to take advantage of the new environment. This post is a continuation of my SAS Global Forum 2020 paper Best Practices for Converting SAS® Code to Leverage SAS® Cloud
How to unquote SAS character variable values
SAS' Leonid Batkhan reviews SAS functionality related to the character strings quoting/unquoting, then dives deep into unquoting SAS character variables.
All hail the SAS programmer!
SAS offering free learning resources in celebration of programmers For more than 40 years, SAS programmers have crafted software and solutions that transform the world. From statistics to data science, to analytics and artificial intelligence, people writing code have architected a new economy with incredible opportunities. SAS Programmer Week honors
Expanding lengths of all character variables in SAS data sets
SAS' Leonid Batkhan reveals how to change lengths for all character variables in a data set and all data sets in a data library to facilitate data migration to Unicode encoding environment.
Splitting a data set into smaller data sets
SAS' Leonid Batkhan shows you how to split a large data set into many by a subsetting by a number of observations to produce smaller, better manageable data sets.
Multi-way lookup tables
A lookup table is a programming technique where one or more values can be used to retrieve another value. For example, many years ago, I had benzene exposure estimates for 10 years (1940 to 1949) for each of five locations in a factory. Given a year and a job location,
How to create and use SAS macro functions
SAS' Leonid Batkhan differentiates between SAS macro and programming languages, defines two types of SAS macros and much more.
Working remotely? A list of 5 ways to spend your down time
As many of us are learning to navigate the changing world we are living in amid the COVID-19 outbreak, and as we care for our loved ones, friends, and our community, many of us now find ourselves working and studying from home much more than we did before. As an
Extending Excel with Python and SAS
Whether you like it or not, Microsoft Excel is still a big hit in the data analysis world. From small to big customers, we still see fit for daily routines such as filtering, generating plots, calculating items on ad-hoc analysis or even running statistical models. Whenever I talk to customers,