Generating Multiple Rows for Overlapping Categories in Proc SQL- power of the union all
6:42
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
9:24
Generating Multiple Rows for Overlapping Categories in SAS power of the output statement
When to store your data as datetime value vs date value
2:33
When to store your data as datetime value vs date value
Why Deduplication Isn’t Always Right - think in context of Business process
3:34
Why Deduplication Isn’t Always Right - think in context of Business process
SAS Formats: Why Numbers Aren't Always What They Seem
4:15
SAS Formats: Why Numbers Aren't Always What They Seem
Using appropriate datatype matters, a US Zipcode case study
5:54
Using appropriate datatype matters, a US Zipcode case study
What are Problems in assigning Zero to missing values
4:43
What are Problems in assigning Zero to missing values
How to avoid data Truncation while using Proc import
3:22
How to avoid data Truncation while using Proc import
Pitfalls of Using New Variables with Same Names as Existing Ones in PROC SQL GROUP BY
8:22
Pitfalls of 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
16:16
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
3:29
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.
6:10
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
5:41
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
2:24
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
10:27
Compare 2 datasets and flag new records, updated records and unchanged records in SAS
Two important free SAS resources for beginners
1:49
Two important free SAS resources for beginners
How to count number of consecutive visit days for each subject in SAS
14:06
How to count number of consecutive visit days for each subject in SAS
Major advantage of a lookup table over hard coded values
10:15
Major advantage of a lookup table over hard coded values
Understanding length while using cat functions and taking appropriate action
2:48
Understanding length while using cat functions and taking appropriate action
WARNING: Variable id has already been defined as numeric.
5:08
WARNING: Variable id has already been defined as numeric.
How to capture warnings from your SAS Log
8:05
How to capture warnings from your SAS Log
Understanding Macro variable resolution.
0:49
Understanding Macro variable resolution.
How to run SAS code Dynamically depending on the day of a month
4:43
How to run SAS code Dynamically depending on the day of a month
Avoid redundant code in multiple SAS programs
3:57
Avoid redundant code in multiple SAS programs
Strategies to test and resolve data issues with case When Statements
12:12
Strategies to test and resolve data issues with case When Statements
Look into your SAS logs and debug your code
5:17
Look into your SAS logs and debug your code
Create directory/folder if does not exist while using libname statement
1:52
Create directory/folder if does not exist while using libname statement
Convert a character variable with month and year to end of the month as date in SAS
4:21
Convert a character variable with month and year to end of the month as date in SAS
Solving a problem and Validating/testing your results in SAS.
20:28
Solving a problem and Validating/testing your results in SAS.
How to Avoid: WARNING: Length of character variable Name has already been set.
3:19
How to Avoid: WARNING: Length of character variable Name has already been set.