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.
Tag: tips & techniques
CAS-Action! fetch CAS, fetch! - Part 2
In Part 1 of my series fetch CAS, fetch!, I executed the fetch CAS action to return rows from a CAS table. That was great, but what can you do with the results? Maybe you want to create a visualization that includes the top five cars by MSRP for all
Going from SAS 9 to SAS Viya and I can hardly contain myself
I am a long-time SAS 9 Administrator, I feel very confident in my understanding of SAS 9 administration. I will admit I don’t know everything, but I have been administering SAS since the days of SAS 9.1.3. I often tell my students I am a general practitioner when it comes
Little known secrets of DO-loops with index variables
SAS' Leonid Batkhan reveals how to use versatile iterative DO loops with index variable pertaining to SAS DATA steps.
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
How to draw a Mandelbrot set in SAS Visual Analytics
Cindy Wang's curiosity about the Mandelbrot set led her to draw one using SAS Visual Analytics.
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.
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!
Append and Replace Records in a CAS Table
In my previous blog post, I talked about using PROC CAS to accomplish various data preparation tasks. Since then, my colleague Todd Braswell and I worked through some interesting challenges implementing an Extract, Transform, Load (ETL) process that continuously updates data in CAS. (Todd is really the brains behind getting
Connect, learn and share during virtual SAS Global Forum 2021
If you’re like me and the rest of the conference team, you’ve probably attended more virtual events this year than you ever thought possible. You can see the general evolution of virtual events by watching the early ones from April or May and compare them to the recent ones. We
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.
How to save Jupyter notebooks in assorted formats
Learning never stops. When SAS had to change this year’s SAS Global Forum (SASGF) to a virtual event, everyone was disappointed. I am, however, super excited about all of the papers and stream of video releases over the last month (and I encourage you to register for the upcoming live
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,
Automating SAS variable labels creation
SAS' Leonid Batkhan shows you how to automate creation of SAS variable labels so tables and reports are easier to read.
Shifting a date by a given number of workdays
This blog post demonstrates process and SAS coding techniques to shift dates by a given number of workdays accounting for weekends and holidays.
Make the most of SAS Global Forum with the session catalog
When I attend a conference, one of the first things I do is look at the agenda. This gives me a good overview of how my time will be spent. The next thing I do is find the detailed breakdown of sessions, so I can start building out my own
How to compare SAS data tables for common/uncommon columns
SAS' Leonid Batkhan shows you how to compare SAS data sets that include common and uncommon columns. You'll learn how to check mark commonalities and color-code differences in data tables side-by-side columns and add a comments field to see greater detail.
Gifts to give the SAS fan in your life
If you’re like me, you struggle to buy gifts. Most folks in my inner circle already have everything they need and most of what they want. Most folks, that is, except the tech-lovers. That’s because there’s always something new on the horizon. There’s always a new gadget or program. Or
How to create checklist tables in SAS®
Leonid Batkhan shows you easy ways to create a checklist table in SAS software.
The Little SAS Book 6.0: The best-selling SAS book gets even better
Find out about the changes and enhancements to the best-selling book, The Little SAS Book.
Top 8 Global English Guidelines
The SAS Global Forum 2020 call for content is open until Sept. 30, 2019. Are you thinking of submitting a paper? If so, we have a few tips adapted from The Global English Style Guide that will help your paper shine. By following Global English guidelines, your writing will be
A DATA step compiler trick to get the record count
Years ago I saw a line of SAS code that was really puzzling. It was a statement that started with: if 0 then … ; What? This was a statement that would always be evaluated as false. Why would anyone write such a statement? Recently, I was discussing with a
Summer reading – Book recommendations from SAS Press authors
One of my favorite parts of summer is a relaxing weekend by the pool. Summer is the time I get to finally catch up on my reading list, which has been building over the year. So, if expanding your knowledge is a goal of yours this summer, SAS Press has