SAS programmers often struggle to understand the full potential of CASL programming for data analytics, making many unsure about what it can do. In this article, we will demystify CASL and explain its importance in SAS Viya. First, let’s understand the basics of CAS and CASL in SAS Viya. What is CAS (Cloud Analytic Services)? … Read more
This article helps you understand the differences between BASE SAS and CASL (Cloud Analytic Services Language), so you can choose the best tool for your specific analytical needs and infrastructure. It highlights the strengths and capabilities of both, guiding you to the best solution for various analytical challenges and business goals. Why CASL is so … Read more
In this article you’ll learn hidden gems about DICTIONARY Tables In SAS. There are tons of useful use cases which many sas programmers aren’t aware of. This article exposes various aspects of DICTIONARY tables with detailed explanation. What Is a DICTIONARY Table In SAS? A DICTIONARY table is a read-only SAS view that contains information … Read more
The WHERE statement can be used to filter out or subsetting the data based on specific conditions. It specifies specific conditions to use to select observations from a SAS dataset. Using the WHERE statement might improve the efficiency of your SAS programs because SAS is not required to read all observations from the input data … Read more
You can use the PROC PRINT procedure to print observations in a SAS data set using some or all of the variables. It’s one of the oldest yet relevant SAS procedures which is being used widely. With the new more advanced procedure like PROC REPORT, ODS system, PROC PRINT kind of left behind in the … Read more
PROC REPORT statement combines features of the PROC PRINT, PROC MEANS, and PROC TABULATE procedures with features of the DATA step in a single report-writing tool that can produce a variety of reports. You can use PROC REPORT procedure to create a report with the SAS dataset and in the formats you would like to … Read more
With the PROC TRANSPOSE procedure you can create an output data set by restructuring the values in a SAS data set, transposing selected variables into observations. Usually datasets are structured but sometimes you may get the data in different formats, depending on how data is being collected at source. There are other external factors such … Read more
You can compare and find the matching and non-matching rows from two datasets in SAS using data merge technique. In the data merge technique data step statement is used with merge statement. In this method you can compare multiple datasets by listing them after the MERGE statement and create new datasets for matching and non-matching … Read more
The COMPARE procedure compares the contents of two SAS data sets, selected variables in different data sets, or variables within the same data set. PROC COMPARE compares two data sets: the base data set and the comparison data set. The procedure determines matching variables and matching observations. Matching variables are variables with the same name … Read more
PROC FREQ is an essential and most used procedure in SAS primarily for counting, displaying and analysing categorical type data. The PROC FREQ statement invokes the FREQ procedure in SAS. The FREQ procedure produces one-way to N-way frequency and cross-tabulation tables. The statistics for contingency (cross-tabulation) tables include the following: chi-square tests and measures measures … Read more