One of the most common activities and issues in data management is to deal with the duplicate rows. Your well established ETL processes might be executing for weeks or months but at some point it may fail due to duplicates. It can either be generated due to fault at source end or wrong logic written … Read more
The both nodupkey and nodup (noduprecs) options can be used in the proc sort procedure. The function of these two options seems similar but it isn’t. In general they remove duplicate rows but in a bit different manner. It’s very important know the difference before you try to delete duplicate rows. With nodupkey option SAS … 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
In this article you’ll learn how to create country-level maps in SAS Studio using BASE SAS code. You’ll learn how to draw country maps highlighting their states, regions or counties. There is a common structure to follow to create any country-level maps without much hustle. The coordinates and all the required information is already available … Read more
The Google maps where we usually see the maps and details about the country, city, or any place. What if you could create the similar maps in SAS itself in the SAS Studio using BASE SAS code? It’s pretty easy to create maps in SAS using the proc gmap procedure. It becomes even more simpler … 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
The SAS picture formats are a kind of template which is being used to display data in a particular format. For example phone numbers written with space after each digits and country code, commas and dashes in the digits, etc. Similarly you can picture format dates, big amounts with spaces and commas, currency sign, and … Read more
The formats in SAS are a very underrated feature among the SAS programmers. Especially when it comes to user defined formats. It has been seen that people happily use join or complex look-up logic but don’t want to create user defined formats. This is probably because not everyone is aware of the real power of … Read more
You have already learned how to create user defined formats in SAS using the proc format procedure. This article is an extended version of that comprehensive guide. In this article you’ll learn how to create user defined formats using the proc format procedure in the permanent SAS library. SAS formats created in the WORK library … Read more