Business Context
The Marketing department is preparing a niche campaign. They have a massive 'EnterpriseMaster' format library containing thousands of codes (Product, HR, Finance, etc.) and a 'CampaignSpecific' library. To optimize session memory and performance for the scoring job, they want to create a lightweight 'TargetingFmts' library containing *only* the relevant customer segment formats from the master library and the new campaign codes.
About the Set : sessionProp
Configuration of session properties.
Discover all actions of sessionProp Data Preparation
Create a massive master library with multiple formats and a small campaign library.
Copied!
| 1 | PROC FORMAT casfmtlib='EntMaster'; |
| 2 | value $custSeg 'GOLD'='High Value' 'SLVR'='Mid Value' 'BRNZ'='Low Value'; |
| 3 | value $hrCode 'A'='Active' 'T'='Terminated'; |
| 4 | value $finCode 'GL1'='Credit' 'GL2'='Debit'; |
| 5 | RUN; |
| 6 | PROC FORMAT casfmtlib='CampSpec'; |
| 7 | value $campSt 'P'='Pending' 'S'='Sent'; |
| 8 | RUN; |
Étapes de réalisation
1
Combine libraries while filtering only for Customer Segment and Campaign Status formats.
Copied!
| 1 | PROC CAS; |
| 2 | sessionProp.combineFmtLibs / |
| 3 | fmtLibsIn={"EntMaster", "CampSpec"}, |
| 4 | fmtLibOut="TargetingFmts", |
| 5 | formatNames={"$custSeg", "$campSt"}; |
| 6 | RUN; |
Expected Result
The 'TargetingFmts' library is created containing ONLY '$custSeg' and '$campSt'. The '$hrCode' and '$finCode' formats are excluded, demonstrating the filtering capability.