Table Action Set: Syntax
Provides actions for accessing and managing data
view Action
Creates a view from files or tables.
| Tip: | The keys parameter must be specified if you use the action with more than one table. |
|---|---|
| Example: | Create a View with Two Tables |
Parameter Descriptions
caslib="string"
specifies the target caslib for the view.
| Alias | targetLib |
|---|
leftJoin=TRUE | FALSE
when set to True, missing values are produced for columns in a dimension table that do not match the keys in the fact table. When False, the default, no result row is produced when a dimension table's keys do not match the fact table.
| Default | FALSE |
|---|
* name="string"
specifies the name for the view to create.
promote=TRUE | FALSE
when set to True, the view is added with a global scope. This enables other sessions to access the table, subject to access controls. The target caslib must also have a global scope.
| Default | FALSE |
|---|
replace=TRUE | FALSE
specifies whether to overwrite an existing view with the same name.
| Default | FALSE |
|---|
tables={{casview-1} <, {casview-2}, ...>}
specifies the input tables to use for the view.
| Minimum items | 1 |
|---|
The casview value can be one or more of the following:
as="string"
specifies a table alias for the table. By default, this table alias and an underscore are used as a column name prefix for the columns contributed by this table. Use the prefixColumnNames parameter to disable the default behavior.
caslib="string"
specifies the caslib that is used by the input table.
computedVars={{casinvardesc-1} <, {casinvardesc-2}, ...>}
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.
For more information about specifying the computedVars parameter, see Basic Syntax in SAS Cloud Analytic Services: CASL Programmer’s Guide.
computedVarsProgram="string"
specifies an expression for each computed variable that you include in the computedVars parameter.
| Alias | compPgm |
|---|
importOptions={fileType="ANY" | "AUDIO" | "AUTO" | "BASESAS" | "CSV" | "DOCUMENT" | "DTA" | "ESP" | "EXCEL" | "FMT" | "HDAT" | "IMAGE" | "JMP" | "LASR" | "PARQUET" | "SPSS" | "VIDEO" | "XLS", fileType-specific-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.
keys={"string-1" <, "string-2", ...>}
specifies the relationship between tables. The keys are checked to make sure they are valid when you run the action. The format is "table1-column=table2-column". Specify this parameter for dimension tables (table1) only. It does not apply to fact tables (table2).
| Alias | joinkey |
|---|
* name="table-name"
specifies the name for the view to create.
prefixColumnNames=TRUE | FALSE
when set to False, the column names from the contributing table are used as-is. By default, the column names are prefixed with either tn_ or the value specified in the as parameter and an underscore. This behavior is applied only to the table that plays the role of the fact table.
| Default | TRUE |
|---|
varList={"variable-name-1" <, "variable-name-2", ...>}
specifies the variables to use in the action.
vars={{casinvardesc-1} <, {casinvardesc-2}, ...>}
specifies the variables to use in the action.
For more information about specifying the vars parameter, see the common casinvardesc parameter.
where="where-expression"
specifies an expression for subsetting the input data.
Result Descriptions
caslib
The result is a string. You can access the value from results.caslib.
viewName
The result is a string. You can access the value from results.viewName.
view Action
Creates a view from files or tables.
| Tip: | The keys parameter must be specified if you use the action with more than one table. |
|---|---|
| Example: | Create a View with Two Tables |
Parameter Descriptions
caslib="string"
specifies the target caslib for the view.
| Alias | targetLib |
|---|
leftJoin=true | false
when set to True, missing values are produced for columns in a dimension table that do not match the keys in the fact table. When False, the default, no result row is produced when a dimension table's keys do not match the fact table.
| Default | false |
|---|
* name="string"
specifies the name for the view to create.
promote=true | false
when set to True, the view is added with a global scope. This enables other sessions to access the table, subject to access controls. The target caslib must also have a global scope.
| Default | false |
|---|
replace=true | false
specifies whether to overwrite an existing view with the same name.
| Default | false |
|---|
tables={{casview-1} <, {casview-2}, ...>}
specifies the input tables to use for the view.
| Minimum items | 1 |
|---|
The casview value can be one or more of the following:
as="string"
specifies a table alias for the table. By default, this table alias and an underscore are used as a column name prefix for the columns contributed by this table. Use the prefixColumnNames parameter to disable the default behavior.
caslib="string"
specifies the caslib that is used by the input table.
computedVars={{casinvardesc-1} <, {casinvardesc-2}, ...>}
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.
For more information about specifying the computedVars parameter, see Basic Syntax in SAS Cloud Analytic Services: CASL Programmer’s Guide.
computedVarsProgram="string"
specifies an expression for each computed variable that you include in the computedVars parameter.
| Alias | compPgm |
|---|
importOptions={fileType="ANY" | "AUDIO" | "AUTO" | "BASESAS" | "CSV" | "DOCUMENT" | "DTA" | "ESP" | "EXCEL" | "FMT" | "HDAT" | "IMAGE" | "JMP" | "LASR" | "PARQUET" | "SPSS" | "VIDEO" | "XLS", fileType-specific-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.
keys={"string-1" <, "string-2", ...>}
specifies the relationship between tables. The keys are checked to make sure they are valid when you run the action. The format is "table1-column=table2-column". Specify this parameter for dimension tables (table1) only. It does not apply to fact tables (table2).
| Alias | joinkey |
|---|
* name="table-name"
specifies the name for the view to create.
prefixColumnNames=true | false
when set to False, the column names from the contributing table are used as-is. By default, the column names are prefixed with either tn_ or the value specified in the as parameter and an underscore. This behavior is applied only to the table that plays the role of the fact table.
| Default | true |
|---|
varList={"variable-name-1" <, "variable-name-2", ...>}
specifies the variables to use in the action.
vars={{casinvardesc-1} <, {casinvardesc-2}, ...>}
specifies the variables to use in the action.
For more information about specifying the vars parameter, see the common casinvardesc parameter.
where="where-expression"
specifies an expression for subsetting the input data.
Result Descriptions
caslib
The result is a string. You can access the value from results.caslib.
viewName
The result is a string. You can access the value from results.viewName.
view Action
Creates a view from files or tables.
| Tip: | The keys parameter must be specified if you use the action with more than one table. |
|---|---|
| Example: | Create a View with Two Tables |
Parameter Descriptions
caslib="string"
specifies the target caslib for the view.
| Alias | targetLib |
|---|
leftJoin=True | False
when set to True, missing values are produced for columns in a dimension table that do not match the keys in the fact table. When False, the default, no result row is produced when a dimension table's keys do not match the fact table.
| Default | False |
|---|
* name="string"
specifies the name for the view to create.
promote=True | False
when set to True, the view is added with a global scope. This enables other sessions to access the table, subject to access controls. The target caslib must also have a global scope.
| Default | False |
|---|
replace=True | False
specifies whether to overwrite an existing view with the same name.
| Default | False |
|---|
tables=[{casview-1} <, {casview-2}, ...>]
specifies the input tables to use for the view.
| Minimum items | 1 |
|---|
The casview value can be one or more of the following:
"as_":"string"
specifies a table alias for the table. By default, this table alias and an underscore are used as a column name prefix for the columns contributed by this table. Use the prefixColumnNames parameter to disable the default behavior.
"caslib":"string"
specifies the caslib that is used by the input table.
"computedVars":[{casinvardesc-1} <, {casinvardesc-2}, ...>]
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.
For more information about specifying the computedVars parameter, see Basic Syntax in SAS Cloud Analytic Services: CASL Programmer’s Guide.
"computedVarsProgram":"string"
specifies an expression for each computed variable that you include in the computedVars parameter.
| Alias | compPgm |
|---|
"importOptions":{"fileType":"ANY" | "AUDIO" | "AUTO" | "BASESAS" | "CSV" | "DOCUMENT" | "DTA" | "ESP" | "EXCEL" | "FMT" | "HDAT" | "IMAGE" | "JMP" | "LASR" | "PARQUET" | "SPSS" | "VIDEO" | "XLS", fileType-specific-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.
"keys":["string-1" <, "string-2", ...>]
specifies the relationship between tables. The keys are checked to make sure they are valid when you run the action. The format is "table1-column=table2-column". Specify this parameter for dimension tables (table1) only. It does not apply to fact tables (table2).
| Alias | joinkey |
|---|
* "name":"table-name"
specifies the name for the view to create.
"prefixColumnNames":True | False
when set to False, the column names from the contributing table are used as-is. By default, the column names are prefixed with either tn_ or the value specified in the as parameter and an underscore. This behavior is applied only to the table that plays the role of the fact table.
| Default | True |
|---|
"varList":["variable-name-1" <, "variable-name-2", ...>]
specifies the variables to use in the action.
"vars":[{casinvardesc-1} <, {casinvardesc-2}, ...>]
specifies the variables to use in the action.
For more information about specifying the vars parameter, see the common casinvardesc parameter.
"where":"where-expression"
specifies an expression for subsetting the input data.
Result Descriptions
caslib
The result is a string. You can access the value from results.caslib.
viewName
The result is a string. You can access the value from results.viewName.
view Action
Creates a view from files or tables.
| Tip: | The keys parameter must be specified if you use the action with more than one table. |
|---|---|
| Example: | Create a View with Two Tables |
Parameter Descriptions
caslib="string"
specifies the target caslib for the view.
| Alias | targetLib |
|---|
leftJoin=TRUE | FALSE
when set to True, missing values are produced for columns in a dimension table that do not match the keys in the fact table. When False, the default, no result row is produced when a dimension table's keys do not match the fact table.
| Default | FALSE |
|---|
* name="string"
specifies the name for the view to create.
promote=TRUE | FALSE
when set to True, the view is added with a global scope. This enables other sessions to access the table, subject to access controls. The target caslib must also have a global scope.
| Default | FALSE |
|---|
replace=TRUE | FALSE
specifies whether to overwrite an existing view with the same name.
| Default | FALSE |
|---|
tables=list( list(casview-1) <, list(casview-2), ...>)
specifies the input tables to use for the view.
| Minimum items | 1 |
|---|
The casview value can be one or more of the following:
as="string"
specifies a table alias for the table. By default, this table alias and an underscore are used as a column name prefix for the columns contributed by this table. Use the prefixColumnNames parameter to disable the default behavior.
caslib="string"
specifies the caslib that is used by the input table.
computedVars=list( list(casinvardesc-1) <, list(casinvardesc-2), ...>)
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.
For more information about specifying the computedVars parameter, see Basic Syntax in SAS Cloud Analytic Services: CASL Programmer’s Guide.
computedVarsProgram="string"
specifies an expression for each computed variable that you include in the computedVars parameter.
| Alias | compPgm |
|---|
importOptions=list(fileType="ANY" | "AUDIO" | "AUTO" | "BASESAS" | "CSV" | "DOCUMENT" | "DTA" | "ESP" | "EXCEL" | "FMT" | "HDAT" | "IMAGE" | "JMP" | "LASR" | "PARQUET" | "SPSS" | "VIDEO" | "XLS", fileType-specific-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.
keys=list("string-1" <, "string-2", ...>)
specifies the relationship between tables. The keys are checked to make sure they are valid when you run the action. The format is "table1-column=table2-column". Specify this parameter for dimension tables (table1) only. It does not apply to fact tables (table2).
| Alias | joinkey |
|---|
* name="table-name"
specifies the name for the view to create.
prefixColumnNames=TRUE | FALSE
when set to False, the column names from the contributing table are used as-is. By default, the column names are prefixed with either tn_ or the value specified in the as parameter and an underscore. This behavior is applied only to the table that plays the role of the fact table.
| Default | TRUE |
|---|
varList=list("variable-name-1" <, "variable-name-2", ...>)
specifies the variables to use in the action.
vars=list( list(casinvardesc-1) <, list(casinvardesc-2), ...>)
specifies the variables to use in the action.
For more information about specifying the vars parameter, see the common casinvardesc parameter.
where="where-expression"
specifies an expression for subsetting the input data.
Result Descriptions
caslib
The result is a string. You can access the value from results.caslib.
viewName
The result is a string. You can access the value from results.viewName.