Appending data tables is a common task for data analysis. Here are three of the several methods possible through the SAS Viya platform.
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.
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.
Kevin Russell of SAS Technical Support shows you how partitioning CAS tables speeds processing.
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
The stored compiled macro facility enables you to compile and save your macro definition in a permanent catalog in a library that you specify. The macro is compiled only once. When you call the macro in the current and subsequent SAS® sessions, SAS executes the compiled code from the macro
Being able to access information about your operating system from within SAS can be incredibly useful. For example, if you have a directory that contains an unknown number of CSV files that you would like to read into SAS, you certainly would not want to have to write an IMPORT
“Here’s Johnny!!!” and well sometimes John and sometimes Jonathan and sometimes Jon. In the real world, you sometimes need to make matching character strings more flexible. This is especially common when merging data sets. Variables, especially names, are not always exactly the same in all sources of your data. When
Some very common questions we receive into Technical Support are, “I need to be able to send the data for every hospital listed in my data set to a separate .csv file. How can I do that?” Or, “How can I run a PROC REPORT for each region listed in