SAS Users

SAS Viya sharing credentials for database access

SAS Viya deployments use credentials for accessing databases and other third-party products that require authentication. In this blog post, I will look at how this sharing of credentials is implemented in SAS Environment Manager. In SAS Viya, domains are used to store the: Credentials required to access external data sources. Identities that are allowed to… Continue reading SAS Viya sharing credentials for database access

SAS Users

CALL EXECUTE made easy for SAS data-driven programming

I presented various data-driven applications using SAS macro loops. However, macro loops are not the only tools available in SAS for developing data-driven programs.However, macro loops are not the only tools available in SAS for developing data-driven programs. CALL EXECUTE is one of them. The CALL EXECUTE routine accepts a single argument that is a… Continue reading CALL EXECUTE made easy for SAS data-driven programming

SAS Users · Uncategorized

CALL EXECUTE made easy for SAS data-driven programming

I presented various data-driven applications using SAS macro loops.I presented various data-driven applications using SAS macro loops. However, macro loops are not the only tools available in SAS for developing data-driven programs. CALL EXECUTE is one of them. The CALL EXECUTE routine accepts a single argument that is a character string or character expression. The… Continue reading CALL EXECUTE made easy for SAS data-driven programming

SAS Users

SAS Visual Analytics 8.1: Configuring prompts with different source data

In this blog, I will cover how to configure prompts, either report, page, or report canvas prompts, that use different data sources. Different Data Sources with overlapping data values First, you must have two different data sources added to your Visual Analytics report. These data sources must have values that overlap that you wish to… Continue reading SAS Visual Analytics 8.1: Configuring prompts with different source data

SAS Users

Selecting the top n% and bottom n% of observations from a data set

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 task, you can choose the… Continue reading Selecting the top n% and bottom n% of observations from a data set

SAS Users

How to stay informed about SAS hot fixes

SAS releases regular updates to software products in the form of hot fixes and maintenance releases. Hot fixes are SAS’ timely response to customer-reported problems, as well as a way to deliver occasional security-related updates that can affect any software product. At SAS we call them “hot fixes.” Other companies might call these “updates,” “patches”… Continue reading How to stay informed about SAS hot fixes