Array 2.0: matrix-friendly array in Proc Fcmp

Array is probably the only number-indexed data type in SAS. SAS programmers adopt it mainly for multiple-variable batch-processing. For example, longitudinal summation can be achieved by specifying a one-dimensional array and then adding all array elem…

Star Schema Options in OLAP Cubes

In the past couple months, this scenario has occurred twice. So thought I’d share a quick remedy ~ and save for my future reference when this occurs again :).
In Star Schemas, there are sometimes occasions where the data quality isn’t exactly perfec…

Star Schema Options in OLAP Cubes

In the past couple months, this scenario has occurred twice. So thought I’d share a quick remedy ~ and save for my future reference when this occurs again :). In Star Schemas, there are sometimes occasions where the data quality isn’t exactly perfec…