Conditions and index variables in array processing

This section will continue to demonstrate how array processing is used in SAS warehousing when performing data steps as part of ETL. First, a conditional array will be demonstrated, and the reasoning behind adding conditions to array processing will be explained. This will be followed by a discussion on creating and serving up index variables from variables that are output by the array. Finally, this section will touch on the topic of documenting and standardizing array processing in a SAS data warehouse.

Adding a condition to array processing

In the previous section, we took all 11 co-morbidity variables as an input array and generated a set of 11 flags as part of an output array. Even though the DIABETE3 variable was coded slightly differently than the other input variables, the data step that created the flags was based on common coding among all 11 variables, which was where 1 = Yes. Let's imagine that this time, we...