Provides actions for processing audio data
Computes various features for audio files loaded into a CAS table.
If a row includes a subparameter, you can specify the name, caslib, and so on in the subparameter. Otherwise, you can specify the name, caslib, and so on in the parameter.
|
Parameter |
Subparameter |
Description |
|---|---|---|
|
required parametertable |
— |
specifies the settings for an input table. |
|
Parameter |
Subparameter |
Description |
|---|---|---|
|
required parametercasOut |
— |
specifies the settings for an output table. |
specifies the name of the column in the input table that contains the audio data.
specifies the settings for an output table.
For more information about specifying the casOut parameter, see the common casouttable (Form 1) parameter (Appendix A: Common Parameters).
specifies the list of variables to transfer from the input table to the output table.
| Requirement | The specified values must be unique. |
|---|
specifies the settings to use to determine how to perform the FBank feature computations.
The fbankOptions value can be one or more of the following:
specifies the linear floor on energy (absolute, not relative) for the FBank feature computations.
| Default | 0 |
|---|---|
| Minimum value | 0 |
when set to True, specifies that energy should be computed before preemphasis and windowing.
| Default | TRUE |
|---|
when set to True, specifies that an extra dimension containing the computed energy should be appended to each FBank feature frame.
| Default | FALSE |
|---|
when set to True, specifies that the output should contain log-filterbank values (otherwise, the output values are linear).
| Default | TRUE |
|---|
when set to True, specifies that power should be used in the FBank feature computations (otherwise, the magnitude is used).
| Default | TRUE |
|---|
specifies the feature scaling method to apply to the computed feature vectors.
| Default | NONE |
|---|
specifies the settings to use to determine how to break the audio file into frames.
The frameExtractionOptions value can be one or more of the following:
specifies the constant coefficient to use for the generalized Blackman window (this value is ignored for other window types).
| Default | 0.42 |
|---|
specifies the dithering constant (0.0 means no dithering).
| Default | 1 |
|---|---|
| Minimum value | 0 |
specifies the length of a frame (in milliseconds).
| Default | 25 |
|---|---|
| Minimum value (exclusive) | 0 |
specifies the time difference (in milliseconds) between the beginnings of consecutive frames.
| Default | 10 |
|---|---|
| Minimum value (exclusive) | 0 |
specifies the coefficient to use in performing signal preemphasis.
| Default | 0.97 |
|---|---|
| Range | 0–1 |
when set to True, specifies that the mean of the values in each frame should be subtracted from all values in that frame.
| Default | TRUE |
|---|
when set to True, specifies that the window size should be rounded to the next power of two.
| Default | TRUE |
|---|
when set to True, specifies that end effects should be handled by outputting only frames that completely fit the data.
| Default | TRUE |
|---|
specifies the type of window to apply to each frame upon extraction.
| Default | RECTANGULAR |
|---|
specifies the settings to use to determine the mel-frequency banks.
The melBanksOptions value can be one or more of the following:
specifies the high cutoff frequency for the mel-frequency bins (if negative, the value is added to the Nyquist frequency, which is determined from the sampling rate of the audio).
| Default | 0 |
|---|
specifies the low cutoff frequency for the mel-frequency bins.
| Default | 20 |
|---|
specifies the number of triangular mel-frequency bins.
| Default | 23 |
|---|---|
| Minimum value | 1 |
specifies the settings to use to determine how to perform the MFCC feature computations.
The mfccOptions value can be one or more of the following:
specifies the constant that controls the scaling of the MFCC feature values.
| Default | 22 |
|---|
specifies the linear floor on energy (absolute, not relative) for the MFCC feature computations.
| Default | 0 |
|---|---|
| Minimum value | 0 |
specifies the number of cepstral coefficients in each MFCC feature frame (including C0).
| Default | 13 |
|---|---|
| Minimum value | 1 |
when set to True, specifies that energy should be computed before preemphasis and windowing.
| Default | TRUE |
|---|
when set to True, specifies that energy (not C0) should be used in the MFCC feature computations.
| Default | TRUE |
|---|
specifies the number of context frames to append before and after the current audio frame.
| Default | 0 |
|---|---|
| Minimum value | 0 |
specifies the exact number of frames to include in the output table (extra frames are dropped and missing frames are padded with zeros).
| Minimum value | 1 |
|---|
specifies the settings for an input table.
| Long form | table={name="table-name"} |
|---|---|
| Shortcut form | table="table-name" |
The castable value can be one or more of the following:
specifies the caslib for the input table that you want to use with the action. By default, the active caslib is used. Specify a value only if you need to access a table from a different caslib.
when set to True, creates the computed variables when the table is loaded instead of when the action begins.
| Alias | compOnDemand |
|---|---|
| Default | FALSE |
specifies the names of the computed variables to create. Specify an expression for each variable in the computedVarsProgram parameter. If you do not specify this parameter, then all variables from computedVarsProgram are automatically included.
| Alias | compVars |
|---|
The casinvardesc value can be one or more of the following:
specifies the format to apply to the variable.
specifies the length of the format field plus the length of the format precision.
specifies the descriptive label for the variable.
specifies the name for the variable.
specifies the length of the format precision.
specifies the length of the format field.
specifies an expression for each computed variable that you include in the computedVars parameter.
| Alias | compPgm |
|---|
specifies data source options.
| Aliases | options |
|---|---|
| dataSource |
specifies the settings for reading a table from a data source.
| Alias | import |
|---|
For more information about specifying the importOptions parameter, see the common importOptions parameter (Appendix A: Common Parameters).
specifies the name of the input table.
when set to True, does not create a transient table on the server. Setting this parameter to True can be efficient, but the data might not have stable ordering upon repeated runs.
| Default | FALSE |
|---|
specifies the variables to use in the action.
The casinvardesc value can be one or more of the following:
specifies the format to apply to the variable.
specifies the length of the format field plus the length of the format precision.
specifies the descriptive label for the variable.
specifies the name for the variable.
specifies the length of the format precision.
specifies the length of the format field.
specifies an expression for subsetting the input data.
specifies an input table that contains rows to use as a WHERE filter. If the vars parameter is not specified, then all the variable names that are common to the input table and the filtering table are used to find matching rows. If the where parameter for the input table and this parameter are specified, then this filtering table is applied first.
The groupbytable value can be one or more of the following:
specifies the caslib for the filter table. By default, the active caslib is used.
specifies data source options.
| Aliases | options |
|---|---|
| dataSource |
For more information about specifying the dataSourceOptions parameter, see the common dataSourceOptions parameter (Appendix A: Common Parameters).
specifies the settings for reading a table from a data source.
| Alias | import |
|---|
For more information about specifying the importOptions parameter, see the common importOptions parameter (Appendix A: Common Parameters).
specifies the name of the filter table.
specifies the variable names to use from the filter table.
The casinvardesc value can be one or more of the following:
specifies the format to apply to the variable.
specifies the length of the format field plus the length of the format precision.
specifies the descriptive label for the variable.
specifies the name for the variable.
specifies the length of the format precision.
specifies the length of the format field.
specifies an expression for subsetting the data from the filter table.
Computes various features for audio files loaded into a CAS table.
If a row includes a subparameter, you can specify the name, caslib, and so on in the subparameter. Otherwise, you can specify the name, caslib, and so on in the parameter.
|
Parameter |
Subparameter |
Description |
|---|---|---|
|
required parametertable |
— |
specifies the settings for an input table. |
|
Parameter |
Subparameter |
Description |
|---|---|---|
|
required parametercasOut |
— |
specifies the settings for an output table. |
specifies the name of the column in the input table that contains the audio data.
specifies the settings for an output table.
For more information about specifying the casOut parameter, see the common casouttable (Form 1) parameter (Appendix A: Common Parameters).
specifies the list of variables to transfer from the input table to the output table.
| Requirement | The specified values must be unique. |
|---|
specifies the settings to use to determine how to perform the FBank feature computations.
The fbankOptions value can be one or more of the following:
specifies the linear floor on energy (absolute, not relative) for the FBank feature computations.
| Default | 0 |
|---|---|
| Minimum value | 0 |
when set to True, specifies that energy should be computed before preemphasis and windowing.
| Default | true |
|---|
when set to True, specifies that an extra dimension containing the computed energy should be appended to each FBank feature frame.
| Default | false |
|---|
when set to True, specifies that the output should contain log-filterbank values (otherwise, the output values are linear).
| Default | true |
|---|
when set to True, specifies that power should be used in the FBank feature computations (otherwise, the magnitude is used).
| Default | true |
|---|
specifies the feature scaling method to apply to the computed feature vectors.
| Default | NONE |
|---|
specifies the settings to use to determine how to break the audio file into frames.
The frameExtractionOptions value can be one or more of the following:
specifies the constant coefficient to use for the generalized Blackman window (this value is ignored for other window types).
| Default | 0.42 |
|---|
specifies the dithering constant (0.0 means no dithering).
| Default | 1 |
|---|---|
| Minimum value | 0 |
specifies the length of a frame (in milliseconds).
| Default | 25 |
|---|---|
| Minimum value (exclusive) | 0 |
specifies the time difference (in milliseconds) between the beginnings of consecutive frames.
| Default | 10 |
|---|---|
| Minimum value (exclusive) | 0 |
specifies the coefficient to use in performing signal preemphasis.
| Default | 0.97 |
|---|---|
| Range | 0–1 |
when set to True, specifies that the mean of the values in each frame should be subtracted from all values in that frame.
| Default | true |
|---|
when set to True, specifies that the window size should be rounded to the next power of two.
| Default | true |
|---|
when set to True, specifies that end effects should be handled by outputting only frames that completely fit the data.
| Default | true |
|---|
specifies the type of window to apply to each frame upon extraction.
| Default | RECTANGULAR |
|---|
specifies the settings to use to determine the mel-frequency banks.
The melBanksOptions value can be one or more of the following:
specifies the high cutoff frequency for the mel-frequency bins (if negative, the value is added to the Nyquist frequency, which is determined from the sampling rate of the audio).
| Default | 0 |
|---|
specifies the low cutoff frequency for the mel-frequency bins.
| Default | 20 |
|---|
specifies the number of triangular mel-frequency bins.
| Default | 23 |
|---|---|
| Minimum value | 1 |
specifies the settings to use to determine how to perform the MFCC feature computations.
The mfccOptions value can be one or more of the following:
specifies the constant that controls the scaling of the MFCC feature values.
| Default | 22 |
|---|
specifies the linear floor on energy (absolute, not relative) for the MFCC feature computations.
| Default | 0 |
|---|---|
| Minimum value | 0 |
specifies the number of cepstral coefficients in each MFCC feature frame (including C0).
| Default | 13 |
|---|---|
| Minimum value | 1 |
when set to True, specifies that energy should be computed before preemphasis and windowing.
| Default | true |
|---|
when set to True, specifies that energy (not C0) should be used in the MFCC feature computations.
| Default | true |
|---|
specifies the number of context frames to append before and after the current audio frame.
| Default | 0 |
|---|---|
| Minimum value | 0 |
specifies the exact number of frames to include in the output table (extra frames are dropped and missing frames are padded with zeros).
| Minimum value | 1 |
|---|
specifies the settings for an input table.
| Long form | table={name="table-name"} |
|---|---|
| Shortcut form | table="table-name" |
The castable value can be one or more of the following:
specifies the caslib for the input table that you want to use with the action. By default, the active caslib is used. Specify a value only if you need to access a table from a different caslib.
when set to True, creates the computed variables when the table is loaded instead of when the action begins.
| Alias | compOnDemand |
|---|---|
| Default | false |
specifies the names of the computed variables to create. Specify an expression for each variable in the computedVarsProgram parameter. If you do not specify this parameter, then all variables from computedVarsProgram are automatically included.
| Alias | compVars |
|---|
The casinvardesc value can be one or more of the following:
specifies the format to apply to the variable.
specifies the length of the format field plus the length of the format precision.
specifies the descriptive label for the variable.
specifies the name for the variable.
specifies the length of the format precision.
specifies the length of the format field.
specifies an expression for each computed variable that you include in the computedVars parameter.
| Alias | compPgm |
|---|
specifies data source options.
| Aliases | options |
|---|---|
| dataSource |
specifies the settings for reading a table from a data source.
| Alias | import |
|---|
For more information about specifying the importOptions parameter, see the common importOptions parameter (Appendix A: Common Parameters).
specifies the name of the input table.
when set to True, does not create a transient table on the server. Setting this parameter to True can be efficient, but the data might not have stable ordering upon repeated runs.
| Default | false |
|---|
specifies the variables to use in the action.
The casinvardesc value can be one or more of the following:
specifies the format to apply to the variable.
specifies the length of the format field plus the length of the format precision.
specifies the descriptive label for the variable.
specifies the name for the variable.
specifies the length of the format precision.
specifies the length of the format field.
specifies an expression for subsetting the input data.
specifies an input table that contains rows to use as a WHERE filter. If the vars parameter is not specified, then all the variable names that are common to the input table and the filtering table are used to find matching rows. If the where parameter for the input table and this parameter are specified, then this filtering table is applied first.
The groupbytable value can be one or more of the following:
specifies the caslib for the filter table. By default, the active caslib is used.
specifies data source options.
| Aliases | options |
|---|---|
| dataSource |
For more information about specifying the dataSourceOptions parameter, see the common dataSourceOptions parameter (Appendix A: Common Parameters).
specifies the settings for reading a table from a data source.
| Alias | import |
|---|
For more information about specifying the importOptions parameter, see the common importOptions parameter (Appendix A: Common Parameters).
specifies the name of the filter table.
specifies the variable names to use from the filter table.
The casinvardesc value can be one or more of the following:
specifies the format to apply to the variable.
specifies the length of the format field plus the length of the format precision.
specifies the descriptive label for the variable.
specifies the name for the variable.
specifies the length of the format precision.
specifies the length of the format field.
specifies an expression for subsetting the data from the filter table.
Computes various features for audio files loaded into a CAS table.
If a row includes a subparameter, you can specify the name, caslib, and so on in the subparameter. Otherwise, you can specify the name, caslib, and so on in the parameter.
|
Parameter |
Subparameter |
Description |
|---|---|---|
|
required parametertable |
— |
specifies the settings for an input table. |
|
Parameter |
Subparameter |
Description |
|---|---|---|
|
required parametercasOut |
— |
specifies the settings for an output table. |
specifies the name of the column in the input table that contains the audio data.
specifies the settings for an output table.
For more information about specifying the casOut parameter, see the common casouttable (Form 1) parameter (Appendix A: Common Parameters).
specifies the list of variables to transfer from the input table to the output table.
| Requirement | The specified values must be unique. |
|---|
specifies the settings to use to determine how to perform the FBank feature computations.
The fbankOptions value can be one or more of the following:
specifies the linear floor on energy (absolute, not relative) for the FBank feature computations.
| Default | 0 |
|---|---|
| Minimum value | 0 |
when set to True, specifies that energy should be computed before preemphasis and windowing.
| Default | True |
|---|
when set to True, specifies that an extra dimension containing the computed energy should be appended to each FBank feature frame.
| Default | False |
|---|
when set to True, specifies that the output should contain log-filterbank values (otherwise, the output values are linear).
| Default | True |
|---|
when set to True, specifies that power should be used in the FBank feature computations (otherwise, the magnitude is used).
| Default | True |
|---|
specifies the feature scaling method to apply to the computed feature vectors.
| Default | NONE |
|---|
specifies the settings to use to determine how to break the audio file into frames.
The frameExtractionOptions value can be one or more of the following:
specifies the constant coefficient to use for the generalized Blackman window (this value is ignored for other window types).
| Default | 0.42 |
|---|
specifies the dithering constant (0.0 means no dithering).
| Default | 1 |
|---|---|
| Minimum value | 0 |
specifies the length of a frame (in milliseconds).
| Default | 25 |
|---|---|
| Minimum value (exclusive) | 0 |
specifies the time difference (in milliseconds) between the beginnings of consecutive frames.
| Default | 10 |
|---|---|
| Minimum value (exclusive) | 0 |
specifies the coefficient to use in performing signal preemphasis.
| Default | 0.97 |
|---|---|
| Range | 0–1 |
when set to True, specifies that the mean of the values in each frame should be subtracted from all values in that frame.
| Default | True |
|---|
when set to True, specifies that the window size should be rounded to the next power of two.
| Default | True |
|---|
when set to True, specifies that end effects should be handled by outputting only frames that completely fit the data.
| Default | True |
|---|
specifies the type of window to apply to each frame upon extraction.
| Default | RECTANGULAR |
|---|
specifies the settings to use to determine the mel-frequency banks.
The melBanksOptions value can be one or more of the following:
specifies the high cutoff frequency for the mel-frequency bins (if negative, the value is added to the Nyquist frequency, which is determined from the sampling rate of the audio).
| Default | 0 |
|---|
specifies the low cutoff frequency for the mel-frequency bins.
| Default | 20 |
|---|
specifies the number of triangular mel-frequency bins.
| Default | 23 |
|---|---|
| Minimum value | 1 |
specifies the settings to use to determine how to perform the MFCC feature computations.
The mfccOptions value can be one or more of the following:
specifies the constant that controls the scaling of the MFCC feature values.
| Default | 22 |
|---|
specifies the linear floor on energy (absolute, not relative) for the MFCC feature computations.
| Default | 0 |
|---|---|
| Minimum value | 0 |
specifies the number of cepstral coefficients in each MFCC feature frame (including C0).
| Default | 13 |
|---|---|
| Minimum value | 1 |
when set to True, specifies that energy should be computed before preemphasis and windowing.
| Default | True |
|---|
when set to True, specifies that energy (not C0) should be used in the MFCC feature computations.
| Default | True |
|---|
specifies the number of context frames to append before and after the current audio frame.
| Default | 0 |
|---|---|
| Minimum value | 0 |
specifies the exact number of frames to include in the output table (extra frames are dropped and missing frames are padded with zeros).
| Minimum value | 1 |
|---|
specifies the settings for an input table.
| Long form | table={"name":"table-name"} |
|---|---|
| Shortcut form | table="table-name" |
The castable value can be one or more of the following:
specifies the caslib for the input table that you want to use with the action. By default, the active caslib is used. Specify a value only if you need to access a table from a different caslib.
when set to True, creates the computed variables when the table is loaded instead of when the action begins.
| Alias | compOnDemand |
|---|---|
| Default | False |
specifies the names of the computed variables to create. Specify an expression for each variable in the computedVarsProgram parameter. If you do not specify this parameter, then all variables from computedVarsProgram are automatically included.
| Alias | compVars |
|---|
The casinvardesc value can be one or more of the following:
specifies the format to apply to the variable.
specifies the length of the format field plus the length of the format precision.
specifies the descriptive label for the variable.
specifies the name for the variable.
specifies the length of the format precision.
specifies the length of the format field.
specifies an expression for each computed variable that you include in the computedVars parameter.
| Alias | compPgm |
|---|
specifies data source options.
| Aliases | options |
|---|---|
| dataSource |
specifies the settings for reading a table from a data source.
| Alias | import_ |
|---|
For more information about specifying the importOptions parameter, see the common importOptions parameter (Appendix A: Common Parameters).
specifies the name of the input table.
when set to True, does not create a transient table on the server. Setting this parameter to True can be efficient, but the data might not have stable ordering upon repeated runs.
| Default | False |
|---|
specifies the variables to use in the action.
The casinvardesc value can be one or more of the following:
specifies the format to apply to the variable.
specifies the length of the format field plus the length of the format precision.
specifies the descriptive label for the variable.
specifies the name for the variable.
specifies the length of the format precision.
specifies the length of the format field.
specifies an expression for subsetting the input data.
specifies an input table that contains rows to use as a WHERE filter. If the vars parameter is not specified, then all the variable names that are common to the input table and the filtering table are used to find matching rows. If the where parameter for the input table and this parameter are specified, then this filtering table is applied first.
The groupbytable value can be one or more of the following:
specifies the caslib for the filter table. By default, the active caslib is used.
specifies data source options.
| Aliases | options |
|---|---|
| dataSource |
For more information about specifying the dataSourceOptions parameter, see the common dataSourceOptions parameter (Appendix A: Common Parameters).
specifies the settings for reading a table from a data source.
| Alias | import_ |
|---|
For more information about specifying the importOptions parameter, see the common importOptions parameter (Appendix A: Common Parameters).
specifies the name of the filter table.
specifies the variable names to use from the filter table.
The casinvardesc value can be one or more of the following:
specifies the format to apply to the variable.
specifies the length of the format field plus the length of the format precision.
specifies the descriptive label for the variable.
specifies the name for the variable.
specifies the length of the format precision.
specifies the length of the format field.
specifies an expression for subsetting the data from the filter table.
Computes various features for audio files loaded into a CAS table.
If a row includes a subparameter, you can specify the name, caslib, and so on in the subparameter. Otherwise, you can specify the name, caslib, and so on in the parameter.
|
Parameter |
Subparameter |
Description |
|---|---|---|
|
required parametertable |
— |
specifies the settings for an input table. |
|
Parameter |
Subparameter |
Description |
|---|---|---|
|
required parametercasOut |
— |
specifies the settings for an output table. |
specifies the name of the column in the input table that contains the audio data.
specifies the settings for an output table.
For more information about specifying the casOut parameter, see the common casouttable (Form 1) parameter (Appendix A: Common Parameters).
specifies the list of variables to transfer from the input table to the output table.
| Requirement | The specified values must be unique. |
|---|
specifies the settings to use to determine how to perform the FBank feature computations.
The fbankOptions value can be one or more of the following:
specifies the linear floor on energy (absolute, not relative) for the FBank feature computations.
| Default | 0 |
|---|---|
| Minimum value | 0 |
when set to True, specifies that energy should be computed before preemphasis and windowing.
| Default | TRUE |
|---|
when set to True, specifies that an extra dimension containing the computed energy should be appended to each FBank feature frame.
| Default | FALSE |
|---|
when set to True, specifies that the output should contain log-filterbank values (otherwise, the output values are linear).
| Default | TRUE |
|---|
when set to True, specifies that power should be used in the FBank feature computations (otherwise, the magnitude is used).
| Default | TRUE |
|---|
specifies the feature scaling method to apply to the computed feature vectors.
| Default | NONE |
|---|
specifies the settings to use to determine how to break the audio file into frames.
The frameExtractionOptions value can be one or more of the following:
specifies the constant coefficient to use for the generalized Blackman window (this value is ignored for other window types).
| Default | 0.42 |
|---|
specifies the dithering constant (0.0 means no dithering).
| Default | 1 |
|---|---|
| Minimum value | 0 |
specifies the length of a frame (in milliseconds).
| Default | 25 |
|---|---|
| Minimum value (exclusive) | 0 |
specifies the time difference (in milliseconds) between the beginnings of consecutive frames.
| Default | 10 |
|---|---|
| Minimum value (exclusive) | 0 |
specifies the coefficient to use in performing signal preemphasis.
| Default | 0.97 |
|---|---|
| Range | 0–1 |
when set to True, specifies that the mean of the values in each frame should be subtracted from all values in that frame.
| Default | TRUE |
|---|
when set to True, specifies that the window size should be rounded to the next power of two.
| Default | TRUE |
|---|
when set to True, specifies that end effects should be handled by outputting only frames that completely fit the data.
| Default | TRUE |
|---|
specifies the type of window to apply to each frame upon extraction.
| Default | RECTANGULAR |
|---|
specifies the settings to use to determine the mel-frequency banks.
The melBanksOptions value can be one or more of the following:
specifies the high cutoff frequency for the mel-frequency bins (if negative, the value is added to the Nyquist frequency, which is determined from the sampling rate of the audio).
| Default | 0 |
|---|
specifies the low cutoff frequency for the mel-frequency bins.
| Default | 20 |
|---|
specifies the number of triangular mel-frequency bins.
| Default | 23 |
|---|---|
| Minimum value | 1 |
specifies the settings to use to determine how to perform the MFCC feature computations.
The mfccOptions value can be one or more of the following:
specifies the constant that controls the scaling of the MFCC feature values.
| Default | 22 |
|---|
specifies the linear floor on energy (absolute, not relative) for the MFCC feature computations.
| Default | 0 |
|---|---|
| Minimum value | 0 |
specifies the number of cepstral coefficients in each MFCC feature frame (including C0).
| Default | 13 |
|---|---|
| Minimum value | 1 |
when set to True, specifies that energy should be computed before preemphasis and windowing.
| Default | TRUE |
|---|
when set to True, specifies that energy (not C0) should be used in the MFCC feature computations.
| Default | TRUE |
|---|
specifies the number of context frames to append before and after the current audio frame.
| Default | 0 |
|---|---|
| Minimum value | 0 |
specifies the exact number of frames to include in the output table (extra frames are dropped and missing frames are padded with zeros).
| Minimum value | 1 |
|---|
specifies the settings for an input table.
| Long form | table=list(name="table-name") |
|---|---|
| Shortcut form | table="table-name" |
The castable value can be one or more of the following:
specifies the caslib for the input table that you want to use with the action. By default, the active caslib is used. Specify a value only if you need to access a table from a different caslib.
when set to True, creates the computed variables when the table is loaded instead of when the action begins.
| Alias | compOnDemand |
|---|---|
| Default | FALSE |
specifies the names of the computed variables to create. Specify an expression for each variable in the computedVarsProgram parameter. If you do not specify this parameter, then all variables from computedVarsProgram are automatically included.
| Alias | compVars |
|---|
The casinvardesc value can be one or more of the following:
specifies the format to apply to the variable.
specifies the length of the format field plus the length of the format precision.
specifies the descriptive label for the variable.
specifies the name for the variable.
specifies the length of the format precision.
specifies the length of the format field.
specifies an expression for each computed variable that you include in the computedVars parameter.
| Alias | compPgm |
|---|
specifies data source options.
| Aliases | options |
|---|---|
| dataSource |
specifies the settings for reading a table from a data source.
| Alias | import |
|---|
For more information about specifying the importOptions parameter, see the common importOptions parameter (Appendix A: Common Parameters).
specifies the name of the input table.
when set to True, does not create a transient table on the server. Setting this parameter to True can be efficient, but the data might not have stable ordering upon repeated runs.
| Default | FALSE |
|---|
specifies the variables to use in the action.
The casinvardesc value can be one or more of the following:
specifies the format to apply to the variable.
specifies the length of the format field plus the length of the format precision.
specifies the descriptive label for the variable.
specifies the name for the variable.
specifies the length of the format precision.
specifies the length of the format field.
specifies an expression for subsetting the input data.
specifies an input table that contains rows to use as a WHERE filter. If the vars parameter is not specified, then all the variable names that are common to the input table and the filtering table are used to find matching rows. If the where parameter for the input table and this parameter are specified, then this filtering table is applied first.
The groupbytable value can be one or more of the following:
specifies the caslib for the filter table. By default, the active caslib is used.
specifies data source options.
| Aliases | options |
|---|---|
| dataSource |
For more information about specifying the dataSourceOptions parameter, see the common dataSourceOptions parameter (Appendix A: Common Parameters).
specifies the settings for reading a table from a data source.
| Alias | import |
|---|
For more information about specifying the importOptions parameter, see the common importOptions parameter (Appendix A: Common Parameters).
specifies the name of the filter table.
specifies the variable names to use from the filter table.
The casinvardesc value can be one or more of the following:
specifies the format to apply to the variable.
specifies the length of the format field plus the length of the format precision.
specifies the descriptive label for the variable.
specifies the name for the variable.
specifies the length of the format precision.
specifies the length of the format field.
specifies an expression for subsetting the data from the filter table.