Exploring SAS Macro functions – eval and sysevalf

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 …

Read moreExploring SAS Macro functions – eval and sysevalf

Creating multiple observations from single observation in SAS

multiple_observation_to_single_observation

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

Single Observation from Multiple Records

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 Opertors

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

PROC RANK

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.

6 Sas Picture Format Tips You Need To Learn Now

SAS Picture format

SAS picture format creates templates in which you’ll be able to define how the numbers are displayed. With the use of PICTURE FORMAT, you will get over a number of display problems with numbers like:- Decimal and Comma Placement Embedding Characters with Numbers Prefixes PICTURE statement in PROC FORMAT allows you to leverage the facility …

Read more6 Sas Picture Format Tips You Need To Learn Now