CALL SYMPUT in SAS – Explained
CALL SYMPUT and CALL SYMPUTX CALL 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… (0 comment)

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… (0 comment)

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… (0 comment)

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.… (3 comments)