How to sort an array in SAS?
While working on arrays in SAS, we may need to sort the array in ascending or descending order. In this post, I will demonstrate different methods and techniques you can use to sort an array in SAS.
ADVANCED SAS
Symdel in SAS
CALL SYMDEL is a data step call routine which is used to delete macro variables from the global symbol table.
CALL SYMPUT in SAS – Explained
CALL SYMPUT and CALL SYMPUTXCALL SYMPUT and CALL SYMPUTX in SAS are the most commonly used DATA Step call routines to interact with the Macro Facility in SAS. Both are used to assign a value of DATA step to a macro variable.In this article, I will demonstrate some of the uses and important facts of …
How to use the IN operator in SAS macro?
IN operator is used in the data step to replace multiple OR conditions. However, if you try to use IN Operator in SAS Macro then you will find that the IN operator is not available
Exploring SAS Macro functions – eval and sysevalf
EVAL and SYSEVALF are the two macro functions that evaluate arithmetic expressions and logical expressions. %EVAL The %EVAL function is used to evaluate integer arithmetic or logical expressions. The argument passed in the %EVAL function is converted from character to numeric and the results are converted back to character. All parts of the macro language …
Creating multiple observations from single observation in SAS
On the previous post, I have discussed on Creating a single record from multiple records in SAS. What if you want to go the other approach, that is creating a data set with multiple observations from single observation per ID? The process is simple and I have taken the output from the previous example as …
Read moreCreating multiple observations from single observation in SAS
Creating a single record from multiple records in SAS
Creating a single record from multiple records in SAS is to take transform a data set having one observation per subject and converting it to a data set with many observations per subject. Why is this required? It is easier to perform analysis when all the information per subject is in a single observation. For, …
Read moreCreating a single record from multiple records in SAS
Everything You Need To Know About SQL SET Operators
SQL Set operators are conceptually derived from the mathematical set principle. The three fundamental set operators are UNION, INTERSECT, and EXCEPT. All three, with variations (in particular, OUTER UNION) and options, could be carried out in PROC SQL for combining data from a number of tables in the SQL procedure. JOINS VS SQL SET OPERATORS …
Read moreEverything You Need To Know About SQL SET Operators
Using PROC RANK for ranking variables
Ranking of variables is often necessary to analyze the performance or gain an insight on which are the values are on top or at the bottom and by using PROC RANK procedure, there is no need to write complex code using PROC SORT, MACRO calls and DATA STEPS to rank or decile these scores or values.