CAS 6


randpct
- Relational

Summary

Generate a random percentage of records

Description

Note: This user function should not be executed in CAS scripting objects.

Examples

randpct 10
randpct 10 CURBAL
Select 10% of Virginia records
Select 10% worth of Virginia loans
randpct 10 STATE
randpct 10 CURBAL STATE

Syntax

randpct Propotion (Weight) (SelectionStatement∣Grouping)

Right Arguments

Name Data Type Input Type Description Optional Default
Propotion Numeric Constant Proportion of records No
Weight Numeric Field, Constant Proportion of records Yes
SelectionStatement Boolean Field Expression to select records that will be applied to the calculation. Yes 1
Grouping Text Field, Constant Grouping Field No

Result

Type: Boolean

Randomly Selected Records



Build 6.0.624