Description Another example of imputation of missing values but in this case using the information located in the same data table, for the same MID but in other periods. This was used on demograph...

Description This script is designed to split a combined field containing a pattern that is used to separate the information. In this example, the field ‘Practice…NPI’ is compounded. The primary ob...

Description Script: Matrix Counter using Melt DCast (equivalent to Pivot tables) Example: Enrollment Member-Months This script computes the count of months each patient was enrolled in during th...

Description When dealing with situations where a common transformation needs to be applied to multiple fields, the following script applies a method, often referred to as Batch Transformation. In...

Description Financial data often arrives in a text-based format, with dollar signs and commas incorporated for ease of reading. However, numerical analyses and computations are more effective when...

Description This script provides an example of working with relational data tables and demonstrates a method for imputing values. Unlike previous cases where data was hardcoded within the script, ...

Description There are situations when certain fields require updates using information gathered from another table. Similar to Excel’s Match & Index feature, data is extracted from another tab...

Description The present example shows a comparison between two periods: ‘previous’ and ‘current’. In an enrolled population, there can be new patients (present in the current period but not in the...

Description This post depicts situations when data is collected in separate fragments, such as different time periods, places, or other subsets, and needs to be consolidated into a unified table f...

Description This post depicts situations when data is collected in separate fragments, such as different time periods, places, or other subsets, and needs to be consolidated into a unified table f...