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
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
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
In SAS you can import data from flat files, and also extract data from various other databases such as sql, oracle, db2, and so on. Sometimes you extract what is not necessary for you. The best example is blank rows coming from source. The empty rows are of no use hence it is important to … Read more
In this article you’ll learn how to use the proc sort procedure in detail with 10+ examples. The proc sort procedure in SAS used to order the observations based on one or more variables. Furthermore, the proc sort can be used to remove duplicate observations from SAS dataset. The SORT procedure either replaces the original … Read more
You can easily create maps in SAS with the PROC GMAP procedure. In SAS studio you can create 2D maps, block maps, prism maps, surface maps, and so on. If you’re not technical or don’t want to write a code then SAS offers user-friendly interfaces like SAS Visual Analytics, which allow you to create maps … Read more
Formats are used to display variable values or written as output in SAS using the PROC FORMAT statement. The CNTLOUT= and CNTLIN=(options) are often used with the PROC FORMAT procedure in SAS when dealing with the user-defined formats. PROC FORMAT Syntax PROC FORMAT options; VALUE format_name specifications; INVALUE informat_name specifications; PICTURE format_name specifications; RUN; PROC … Read more
The formats are used in the SAS (statistical analysis system) to determine how variable values to be displayed or written as output. There are plenty of built-in formats available in SAS such as date9., w10., comma10.2, MMDDYYw., etc. It is also allowed to create your own user-defined formats in SAS. You can set your own … Read more
SAS has different ways to rename or change the dataset names but in this article you’ll learn 3 ways to rename variables in SAS. You can use the RENAME function to rename one or more variables in the SAS dataset using either Data step or PROC DATASETS procedure. It’s also possible to rename and add … Read more
This is a very common use case where we need to write code to check if a substring is present on a character variable in SAS. That substring can be a character string, a character, or any special character. Depending on the outcomes you can perform your specific operations. You can achieve this by using … Read more