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
Selection of the first and last observations from the dataset could be a little tricky. You can use the first. and last. variable but it only works with the grouping of the data. It doesn’t work on the entire dataset. But the following options are available in SAS that helps you identify and extract last … Read more
In this article you’ll learn 8 different ways with examples on how to select the first N rows in SAS. Sometimes you may want to extract the first 5 observations or just a specific row, let’s say 5th observation, or you may want to extract observations within the specified range. Everything can be achieved using … Read more
The FIRST. And LAST. functions can be used to identify first or last observations by group in the SAS dataset. First.Variable : It assigns value 1 to the first observation and 0 to the rest of the observations within the group in a SAS dataset. Last.Variable: It assigns value 1 to the last observation and … Read more
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
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
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