In this article we have seen 3 different ways to rename a sas dataset but they aren’t efficient when it comes to bulk renaming SAS Data sets. Here you’ll learn how you can rename all the SAS datasets from a library ones for all without creating multiple copies of datasets. It means without making data … Read more
The PROC MEANS procedure summarises data in descriptive statistics for variables across all the observations as well as within the groups of observations. You can compute statistics like calculating mean, standard deviation, minimum and maximum values, and many more statistical calculations. For example, PROC MEANS does the following: calculates descriptive statistics estimates quantiles, which includes … 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
The FIND function in SAS searches for a specific substring in a given string or character variable and returns the position of its first occurrence. The FIND function is mostly used where any specific character, keyword, or phrase you want to identify, and/or extract. It is especially helpful when you read raw, scattered, and long … Read more
The index function searches the specified string, from left to right in the given string and returns the position of the first character in the string. If there are multiple occurrences of a specified string, the index function returns the first position of the first occurrence and ignores the rest of the occurrences. The index … Read more
In this article we have already seen how you can convert char variable to numeric and numeric variable to character variable. When it comes to DATE in SAS, it’s a bit different because SAS has its own date format and informats. You can use the INPUT() function to convert a character date to a numeric … Read more
The Datalines statement along with the INPUT statement is used to create a data set from scratch by entering data directly in the program, rather than data stored in an external file. You can use only one DATALINES statement in a DATA step. Use separate DATA steps to enter multiple sets of data. Basic Syntax … Read more
The ALTER TABLE statement is used to add new variables, delete existing variables, or modify format of variables. This method gives you more flexibility while adding new variables or modifying existing ones. It is also possible to add values on those newly added columns with UPDATE TABLE statement. The following example demonstrates that two new … Read more