DBTable.SubsetStratifiedRandomSampling

Creates a new spreadsheet containing the specified subset of the current spreadsheet using selection conditions and Stratified Random Sampling.

This property is read only.

Syntax Parameters Return Value
ReadOnly Property DBTable.SubsetStratifiedRandomSampling( _
    Variables As Variant, _
    selectionIncludeExpression As String, _
    selectionIncludeList As String, _
    selectionExcludeExpression As String, _
    selectionExcludeList As String, _
    sVar As Variant, _
    sCode As Variant, _
    sProb As Variant, _
    Optional bQuickRand As Boolean = True, _
    Optional bSampleNumberOfCases As Boolean = False, _
    Optional bUseSpreadsheetCaseWeights As Boolean = False, _
    Optional bUseSpreadsheetSelCond As Boolean = False) As Spreadsheet
  • Variables [in]

    Type: Variant

  • selectionIncludeExpression [in]

    Type: String

  • selectionIncludeList [in]

    Type: String

  • selectionExcludeExpression [in]

    Type: String

  • selectionExcludeList [in]

    Type: String

  • sVar [in]

    Type: Variant

  • sCode [in]

    Type: Variant

  • sProb [in]

    Type: Variant

  • bQuickRand [in, optional]

    Type: Boolean

    Default value: True

  • bSampleNumberOfCases [in, optional]

    Type: Boolean

    Default value: False

  • bUseSpreadsheetCaseWeights [in, optional]

    Type: Boolean

    Default value: False

  • bUseSpreadsheetSelCond [in, optional]

    Type: Boolean

    Default value: False

Spreadsheet