SMARTTECH

Найти несовпадающие строки в объединенных таблицах с использованием SQL-соединений PROC

Найти несовпадающие строки в объединенных таблицах с использованием SQL-соединений PROC
Внешняя операция Union Corr против Union Corr в Proc SQL

Внешняя операция Union Corr против Union Corr в Proc SQL
Problems with usage of macro variable in PROC SQL like operator and how to resolve in a simple way

Problems with usage of macro variable in PROC SQL like operator and how to resolve in a simple way
Why TRIM is needed in Identifying Non-Letter Characters in Character Variables

Why TRIM is needed in Identifying Non-Letter Characters in Character Variables
Be careful while using numbers as Macrovariables and comparing them

Be careful while using numbers as Macrovariables and comparing them
Generating Multiple Rows for Overlapping Categories in Proc SQL- power of the union all

Generating Multiple Rows for Overlapping Categories in Proc SQL- power of the union all
Generating Multiple Rows for Overlapping Categories in SAS power of the output statement

Generating Multiple Rows for Overlapping Categories in SAS power of the output statement
When to store your data as datetime value vs date value

When to store your data as datetime value vs date value
Why Deduplication Isn’t Always Right - think in context of Business process

Why Deduplication Isn’t Always Right - think in context of Business process
SAS Formats: Why Numbers Aren't Always What They Seem

SAS Formats: Why Numbers Aren't Always What They Seem
Using appropriate datatype matters, a US Zipcode case study

Using appropriate datatype matters, a US Zipcode case study
What are Problems in assigning Zero to missing values

What are Problems in assigning Zero to missing values
How to avoid data Truncation while using Proc import

How to avoid data Truncation while using Proc import
Issues with Using New Variables with Same Names as Existing Ones in PROC SQL GROUP BY

Issues with Using New Variables with Same Names as Existing Ones in PROC SQL GROUP BY
Three Unexpected ways you might be doing many-to-many joins in PROC SQL

Three Unexpected ways you might be doing many-to-many joins in PROC SQL
Unexpected results when doing joins based on the INDEX function or the LIKE operator

Unexpected results when doing joins based on the INDEX function or the LIKE operator
Problems with Joining and doing aggregation in same query in Proc SQL.

Problems with Joining and doing aggregation in same query in Proc SQL.
What are the problems with Missing values in joining column/columns in PROC SQL

What are the problems with Missing values in joining column/columns in PROC SQL
Difference between functions and call routines in SAS through simple examples

Difference between functions and call routines in SAS through simple examples
Compare 2 datasets and flag new records, updated records and unchanged records in SAS

Compare 2 datasets and flag new records, updated records and unchanged records in SAS
Two important free SAS resources for beginners

Two important free SAS resources for beginners
How to count number of consecutive visit days for each subject in SAS

How to count number of consecutive visit days for each subject in SAS
Major advantage of a lookup table over hard coded values

Major advantage of a lookup table over hard coded values
Understanding length while using cat functions and taking appropriate action

Understanding length while using cat functions and taking appropriate action
WARNING: Variable id has already been defined as numeric.

WARNING: Variable id has already been defined as numeric.
How to capture warnings from your SAS Log

How to capture warnings from your SAS Log
How to run SAS code Dynamically depending on the day of a month

How to run SAS code Dynamically depending on the day of a month
Avoid redundant code in multiple SAS programs

Avoid redundant code in multiple SAS programs
Strategies to test and resolve data issues with case When Statements

Strategies to test and resolve data issues with case When Statements