SAS Users
Providing technical tips and support information, written for and by SAS users.![CALL EXECUTE made easy for SAS data-driven programming](https://blogs.sas.com/content/sgf/files/2017/08/CALL-EXECUTE-made-easy-for-SAS-data-driven-programming2-702x336.jpg)
In my prior posts (Data-driven SAS macro loops, Modifying variable attributes in all datasets of a SAS library, Automating the loading of multiple database tables into SAS tables), I presented various data-driven applications using SAS macro loops. However, macro loops are not the only tools available in SAS for developing
![Controlling Stored Process Execution through Request Initialization Code Injection](https://blogs.sas.com/content/sgf/files/2017/07/ControlledStoredProcess2-702x336.png)
Recently, I was working with a client who had a unique problem. He needed a way to cancel a stored process from executing in cases where the stored process wasn’t registered to the matching Metadata folder-structure for its selected server context. For example, if a stored process was stored under
![SAS Visual Analytics 8.1: Configuring prompts with different source data](https://blogs.sas.com/content/sgf/files/2017/07/Configuring-prompts-with-different-source-data2.png)
In a previous blog, I describe how there are a few new features related to report and page prompts in SAS Visual Analytics 8.1; namely the ability to configure cascading prompts in VA 8.1: Cascading Prompts as Report and Page Prompts. In this blog, I will cover how to configure prompts, either
![Programming tips from experienced SAS users](https://blogs.sas.com/content/sgf/files/2017/07/code-b.jpg)
Trivial Pursuit, Justin Bieber and Timbits. Some pretty great things have come from Canada, eh? Well, you can go ahead and add expert SAS programmers to that impressive list. In this video, six Canadian SAS programmers, with more than 115 years of SAS programming experience between them, share some of their favorite, little-known SAS programming tips. You're sure to discover a new trick or
![Selecting the top n% and bottom n% of observations from a data set](https://blogs.sas.com/content/sgf/files/2017/05/ProblemSolvers_Graphic-400x336.jpg)
SAS® offers several ways that you can find the top n% and bottom n% of data values based on a numeric variable. The RANK procedure with the GROUPS= option is one method. Another method is The UNIVARIATE procedure with the PCTLPTS= option. Because there are several ways to perform this
![What are the characteristics of “true clusters?”](https://blogs.sas.com/content/sgf/files/2017/07/true_clusters-522x336.png)
In the digital world where billions of customers are making trillions of visits on a multi-channel marketing environment, big data has drawn researchers’ attention all over the world. Customers leave behind a huge trail of data volumes in digital channels. It is becoming an extremely difficult task finding the right