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
There might be scenarios where you’re dealing with data from multiple languages. If you are working with a multinational client but their entire system uses the English language then you don’t need to worry about SAS Env LOCAL language. But if you have data sources coming from different countries and data prepared in their own … Read more
SAS reads and writes external files using the current session encoding. SAS assumes that the external file has the same encoding as the session encoding. But sometimes you get some weird characters because of the encoding mismatch of the systems. UTF-8 is part of the Unicode coded character set. UTF-8 is the preferred and most-used … 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
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
Changing the dataset names or creating backup of existing data sets are kind of basic tasks you do as a developer. It’s often used when you do investigation on finding data errors or making changes in the existing solutions. SAS has different ways to rename the variables and its labels but here in this article … 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
When you’re setting up a new SAS environment or making integration with other source systems, encoding issues are very common. That is because of the mismatch between the encoding set on the systems. In this article we will see how you can check the encoding set in SAS and how you can change the encoding … Read more
The wrong encoding can produce errors or warnings like “transcode failed” or “data was lost during transcoding”, and so on! Whenever you see errors like these the first step would be to check the encoding set in the SAS. There are three places where you have encoding specified and you must check it in SAS … 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