Appending data tables is a common task for data analysis. Here are three of the several methods possible through the SAS Viya platform.
Tag: Problem Solvers
SAS' Kathryn McLawhorn reveals an elegant option to introduce dynamic header data using DATA step logic and the FORMAT procedure.
SAS' Bari Lawhorn introduces you to the MFILE option as a way to home in on errors and warnings in your macros.
SAS' Chevell Parker walks you through eight formatting scenarios that can occur when using ODS Excel and how to address them using formatting and formatting values after export.
SAS' Kevin Russell compares how you order your data with a BY statement in SAS 9.4 versus in CAS using the ADDROWID data set option in SAS Viya.
There are several alternatives to writing to a Microsoft Word file when you use the SAS® Output Delivery System (ODS). The RTF, TAGSETS.RTF and TAGSETS.RTF_SAMPLE destinations create an RTF formatted file. The WORD destination, which is still considered preproduction, creates a DOCX formatted file. The destinations provide many of the same functions, although some features are unique to each one. The destination that you choose might vary depending on your desired final output.
SASPy and the SAS kernel for Jupyter Notebook enable you to connect to SAS® 9.4 and the SAS® Viya® compute server from your client machine. You can then interact with SAS and SAS Viya via Python. If you are not familiar with SASPy and the SAS kernel, this article provides an introduction.
SAS' Bari Lawhorn shows you how to access files you've stored with SAS® Studio.
Have you ever submitted a stored process, and instead of the expected output, you saw errors or no output at all? Depending on how you submit the stored process, various logs are available to assist you with debugging. This article provides guidance for understanding which situations call for which logs, where to find each log, and what you should look for in each log.
What happens if you need to edit graph output files from SAS in a different application (for example, Microsoft Word)? It is not recommended that you edit your SAS graph output outside of SAS, but, if you must do so, you need to create your graphics output as EMF (Enhanced Metafile Format) graph output.
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.
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.
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.
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.