In SAS^® High Performance Markdown Optimization 4.3 M2, a new feature was added to remove dangling nodes from the attribute hierarchy. This addresses the issue documented in SAS Note 44371. The first time the attr_hier_job is run in an environment that has been migrated from an earlier release attr_hier_job might run a long time depending on the number of dangling nodes.

A new macro, %di_purge_dangling_nodes_attr allows you to clean up the dangling nodes before you run the attr_hier_job for the first time.

The usage for this new macro follows:

 
%di_purge_dangling_nodes_attr(libref=DI_DM,scope_sk=1,hier_type=1,update_model_group=1);

libref = The library where the attribute hierarchy is located. By default this is DI_DM.

scope_sk = The product_hier_sk under which the dangling nodes will be removed. By default this is 1, which will remove all dangling nodes in the hierarchy. If set to 0, no dangling nodes will be deleted.

hier_type = REQUIRED. Set to 1 to clean up the PRODUCT attribute hierarchy. Set to 2 to cleanup the GEOGRAPHY attribute hierarchy. There is no default value.

update_model_group = Disable the model groups that are tied to dangling nodes. The default value is 1. If set to 0, you might have model groups based on the dangling nodes that no longer have any geo-prods associated with them. You will need to clean up these model groups.

Follow the steps below to execute this macro. This should be done with the userid you usually use for running batch %TKMI_JOB_RO tasks. Typically this is mietlusr.

1. Backup the DI_DM.ATTR_PROD_HIER_ASSOC_DM, DI_DM.ATTR_PROD_DM, DI_DM.ATTR_GEO_HIER_ASSOC_DM, DI_DM.ATTR_GEO_DM and DI_DM.MODEL_GROUP tables.
2. Open an interactive SAS session with autoexec_batch.sas in order to load the catalogs and define the libraries.
3. Include the new macro into your SAS session:
   %include "<SASROOT>\misc\hpdi\sasmisc\di_purge_dangling_nodes_attr.sas";
   Where <SASROOT> is your SAS installation directory.
4. Run the macro for the product hierarchy:
   %di_purge_dangling_nodes_attr(libref=di_data,scope_sk=1,hier_type=1,update_model_group=1);
5. Run the macro for the geography hierarchy:
   %di_purge_dangling_nodes_attr(libref=di_data,scope_sk=1,hier_type=2,update_model_group=1);

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS High-Performance Markdown Optimization 4.3_M2 is available at: