Knowledge Base

Welcome to The Carlisle Group's Knowledge Base.

Search or Ask a Question

This is a keyword search that looks for matching articles that contain one or more words specifically by a user in articles’ tags, title and content. Admin writes brief intro content here via admin end. If you are unable to find an answer to your issue, please submit an issue here.

Back to Articles List

Including Specific records in a random sample | CAS

Added: 06/01/2020; Last Modified: 06/01/2020; Visits:63

The Sampling Object allows users to target a balance and create a random pool of a specific balance. 

Clients often want to include a specified portion of locked loans into this sample. 

Assuming we want to create a $20m Pool, AND we have the loans to be included flagged in a field called "LOCKED"

1. Find the LOCKED Balance. Subtract that Balance from $20m.

2. Select the not LOCKED loans (not LOCKED = 1). 

 

3. Open the sampling Object and set the Target Balance to be the Difference between $20m and the LOCKED Balance.

 

4. Run and create a field called NEWSAMPLE

 

5. The final Pool will be both the LOCKED Loans and NEWSAMPLE, so use the "or" operator in your final Selection Criteria. (LOCKED = 1) or (NEWSAMPLE = 1)

 

Keywords: Sampling sample target