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
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
QA (Quick Response) codes are a popular type of two-dimensional representing information such as geographical coordinates, contact details, URL, text message, or even poem. QR Codes store up to 4,296 alphanumeric characters of arbitrary text. They are also known as hardlinks or physical world hyperlinks. QR codes can be read by any appropriate software such … 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
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