Data Step
Fedsql
Guide SAS VIYA
SAS9
When "Hash Objects" Save a Complex SQL Join
In the world of SAS programming, a debate persists: which is more performant, PROC SQL or the DATA step? The classic answer is "it depends." However, there are specific scenario...
How to extract a "substring" from a numeric variable?
When starting with SAS and the SQL procedure (PROC SQL), a common mistake is to try to manipulate numeric variables as if they were character strings.A classic case is an identi...
How to filter a table from a list of identifiers with PROC SQL
It is very common when manipulating data in SAS to have to extract information from a main table (source dataset) based on a specific list of identifiers contained in another ta...
The "Many-to-Many" Trap (MERGE vs. SQL)
A common belief is that the MERGE statement in a DATA step is the exact equivalent of a SQL join (LEFT JOIN or FULL JOIN). While this is true for simple relationships (1-to-1 or...