The SAS Merchandise Data Integration mdi_loaddm_merch_hierarchy job creates an output data set SASDATA.LV10MERCH from the prepare_lv10merch macro. The data set contains both the existing LV10MAST_IDs as well as the LV10MAST_IDs that are being loaded. Having both results in a larger SASDATA.LV10MERCH data set which subsequently leads to slower data set processing.

To address this performance issue, modify the prepare_lv10merch macro to include only the LV10MAST_IDs that are being loaded in the SASDATA.LV10MERCH output data set. Contact SAS Technical Support to get a replacement prepare_lv10merch.sas file that contains the modification.

To implement the modification, follow these steps:

1. Make a backup copy of $MDI_ROOT/code/sasmacro/prepare_lv10merch.sas.
2. Save the replacement prepare_lv10merch.sas file in $MDI_ROOT/code/sasmacro.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Merchandise Data Integration	64-bit Enabled Solaris	6.1.3 M6	6.4	9.1 TS1M3 SP4	9.4 TS1M0
		Microsoft® Windows® for x64	6.1.3 M6	6.4	9.1 TS1M3 SP4	9.4 TS1M0
		64-bit Enabled AIX	6.1.3 M6	6.4	9.1 TS1M3 SP4	9.4 TS1M0

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

sasdata.lv10merch data set has both existing and new SKUs

Type:	Problem Note
Priority:	high

Date Modified:	2013-10-29 16:27:19
Date Created:	2013-05-03 14:46:59