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
You can easily compare two tables in SAS using different methods. Comparison can be done on sampled data or the entire datasets. The following methods can be used to compare two tables by identifying matching, non-matching, and common observations from both the datasets. PROC SQL DATA MERGE PROC COMPARE The following two sample datasets will … 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
The PROC SUMMARY procedure is used to explore and analyse data not only in terms of count and distribution but also statistically. The SUMMARY and PROC MEANS are quite a similar SAS procedures with two minor differences. The first difference is, PROC MEANS prints a report by default, whereas PROC SUMMARY does not. And the … Read more
This is a very common operation performed in data management. When it comes to deletion of files it is always recommended to have file check logic in place before you attempt to delete files. You can delete files using the FDELETE() function. But before that you must verify if a file exists or not using … Read more
DELETE vs DROP In SAS As a general concept DELETE keyword delete rows from the SAS dataset. It means it only removes observations from the dataset and structure or metadata of that dataset remains intact. Whereas DROP keyword delete entire dataset by physically deleting data files, metadata files and index files if it exists. There … Read more
It’s always the best practice followed that beforeing creating or loading SAS dataset you should first check if it already exists and delete SAS data sets. It’s a standard procedure. There are multiple ways you can delete SAS data sets. You can either delete or drop the dataset. It works more or like the same. … Read more
_N_ Automatic Variable In SAS: The value for _N_ is initially set to 1. Each time the DATA step loops past the DATA statement, the variable _N_ increments by 1. The value of _N_ represents the number of times the DATA step has iterated. The following sample dataset will be used to demonstrate how to … Read more
The END= option used in the data step is very powerful to identify the last observation from the SAS dataset. The end= option to tell SAS to create a temporary numeric value whose value is used to detect the last observation. The following sample dataset will be used to show how to use end=last option … Read more