Kevin Russell of SAS Technical Support reveals the effects of data size and language elements in your code when you execute the DATA step in CAS.
Set it and forget it. That’s how SAS Viya Jobs and Flows should work, right? Well, just like most other things in life, it’s not that simple. What if you have multiple Jobs set to run in a Flow and one fails? Do you exit the process or continue with
This blog demonstrates how to create a report that provides only the column headings for data that is missing. The blog also explains how to create, select, and exclude output objects as well as how to generate reports with the SAS® Output Delivery System (ODS). These concepts are relevant to the task of generating a report with the column headings for a data set that contains no (0) observations.
Date and time values are handled differently when programming in DS2. It can process databases and has access to ANSI data types, which have greater precision.
Amber Elam of SAS Technical Support reveals common challenges and solutions when you convert external files into SAS data sets.
This, the third of three posts on our hot-fix process, provides a spreadsheet and tips to track and manage your SAS®9 environment.
Passionate about helping SAS customers, Sandy Gibbs of Technical Support sheds light on the SASHFADD tool report. This is the second of three posts on our hot-fix process.
SAS' Sandy Gibbs kicks off a series of posts on hot fixes for SAS®9 environments.
When you use SAS software, you might occasionally encounter an issue with SASUSER. This post helps you debug some of the more common issues: a warning message indicates that SASUSER.TEMPLAT is not an item store or that you cannot write to SASUSER.TEMPLAT a note in the log indicates that SAS
Learn how to use the SGPLOT procedure for graphical representation when you perform statistical analysis for a quadratic ANCOVA model with the GLM procedure.
This blog post, inspired by my work on this topic with a SAS customer, focuses on how to create and use locale-specific informats to read in numeric values from a Microsoft Excel file and then transform them into SAS character values. I incorporated this step into a macro that transforms ones and zeroes from the Excel file into meaningful information for multilingual readers.
You want to use an API to retrieve data and process it with SAS. How do you do it? PROC HTTP offers the features of the cURL command within your SAS code.
Kevin Russell of SAS Technical Support shows you how partitioning CAS tables speeds processing.
This blog demonstrates how to modify your ODS HTML code to make your column headers “sticky,” or fixed in position. Using sticky headers is most beneficial when you have long tables on your web page and you want the column headers to stay in view while scrolling through the rest of the page.
In this edition of Problem Solvers, SAS Technical Support's Kathryn McLawhorn walks you through two PROC REPORT techniques.
Martin Mincey of SAS Technical Support shows you how to debug when listing registered SAS fonts, registering new fonts, getting SAS SG procedures to use a new font and more.
SAS' Kris Stobbe shows how you can predict survival rates of Titanic passengers with a combination of both Python and CAS using SWAT, then see how the models performed.
2020 is here and systems that use 2-digit years in date values are getting confused. Do we mean 1920 or 2020? In SAS, the YEARCUTOFF= option lets you decide.
Parts 1 and 2 of this blog post discussed exploring and preparing your data using SASPy. To recap, Part 1 discussed how to explore data using the SASPy interface with Python. Part 2 continued with an explanation of how to prepare your data to use it with a machine-learning model.
The DATA step remains a popular way to create and manipulate SAS data sets. Whether you are reshaping a data set entirely or simply assigning values to a new variable, there are numerous tips and tricks that you can use to save time and keystrokes.
Grace Whiteis of SAS Technical Support shows you how to capitalize on arrays using SAS software -- and streamline your code, whether it involves arrays or not.
Generating a word cloud (also known as a tag cloud) is a good way to mine internet text. Word (or tag) clouds visually represent the occurrence of keywords found in internet data such as Twitter feeds.
This article continues a series that began with Machine learning with SASPy: Exploring and preparing your data (part 1). Part 1 showed you how to explore data using SASPy with Python. Here, in part 2, you will learn how to begin to prepare your data to use it within a
SASPy is a powerful Python library that interfaces with SAS and can help with your machine-learning solutions. SASPy was created for Python programmers to leverage the power of SAS within their Python scripts. If you are not familiar with SASPy, see the following resources: Introducing SASPy: Use Python code to
A few examples to demonstrate some of the common output-related problems with ODS Graphics Procedures. If your graphical output does not appear as you wanted, consider the options that you are using and make sure that you are using the correct option.
The RANK procedure (PROC RANK) is useful for ranking numeric variables in a data set across observations. You often see PROC RANK used to rank data into quartiles, deciles, or percentiles. This action requires that you use the GROUPS= option in the PROC RANK statement. This blog answers three questions
For every project in SAS®, the first step is almost always making your data available. This blog shows you how to load three of the most common input data types—a data set, a text file, and a Microsoft Excel file—into SAS® Cloud Analytic Services (CAS) tables. The three methods that
Did you know that you can run Lua code within Base SAS? Learn more about what PROC LUA can do through some examples.
This article demonstrates the ODS Excel destination’s flexibility and how you can modify its default behavior by using the SHEET_INTERVAL= option.
As word spreads that SAS integrates with open source technologies, people are beginning to explore how to connect, interact with, and use SAS in new ways. More and more users are examining the possibilities and with this comes questions like: How do I code A, integrate B, and accomplish C?
