SMARTTECH

Understanding How SAS Stores Date & Datetime and Their Impact

SMARTTECH

Find Non-Matching Rows From Joining Tables Using PROC SQL Joins

SMARTTECH

Outer Union Corr vs Union Corr in Proc SQL

SMARTTECH

Problems with usage of macro variable in PROC SQL like operator and how to resolve in a simple way

SMARTTECH

Why TRIM is needed in Identifying Non-Letter Characters in Character Variables

SMARTTECH

Be careful while using numbers as Macrovariables and comparing them

SMARTTECH

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

SMARTTECH

Generating Multiple Rows for Overlapping Categories in SAS power of the output statement

SMARTTECH

When to store your data as datetime value vs date value

SMARTTECH

Why Deduplication Isn’t Always Right - think in context of Business process

SMARTTECH

SAS Formats Why Numbers Aren't Always What They Seem

SMARTTECH

Using appropriate datatype matters, a US Zipcode case study

SMARTTECH

What are Problems in assigning Zero to missing values

SMARTTECH

How to avoid data Truncation while using Proc import

SMARTTECH

Issues with Using New Variables with Same Names as Existing Ones in PROC SQL GROUP BY

SMARTTECH

Three Unexpected ways you might be doing many-to-many joins in PROC SQL

SMARTTECH

Unexpected results when doing joins based on the INDEX function or the LIKE operator

SMARTTECH

Problems with Joining and doing aggregation in same query in Proc SQL.

SMARTTECH

What are the problems with Missing values in joining columncolumns in PROC SQL

SMARTTECH

Difference between functions and call routines in SAS through simple examples

SMARTTECH

Compare 2 datasets and flag new records, updated records and unchanged records in SAS

SMARTTECH

Two important free SAS resources for beginners

SMARTTECH

How to count number of consecutive visit days for each subject in SAS

SMARTTECH

Major advantage of a lookup table over hard coded values

SMARTTECH

Understanding length while using cat functions and taking appropriate action

SMARTTECH

WARNING Variable id has already been defined as numeric.

SMARTTECH

How to capture warnings from your SAS Log

SMARTTECH

Understanding Macro variable resolution.

SMARTTECH

How to run SAS code Dynamically depending on the day of a month

SMARTTECH

Avoid redundant code in multiple SAS programs

SMARTTECH