Label | Explanation | Data Type |
Input Table | The input table. | Table View |
Output SAS Dataset (libref.tablename)
| The output SAS dataset. Provide the dataset in the form libref.table in which libref is the name of a SAS library and table is the name of the SAS table. | String |
Replace SAS Dataset
(Optional) | Specifies whether an existing SAS dataset will be overwritten by the output.
| Boolean |
Use Domain and Subtype Descriptions
(Optional) | Specifies whether domain and subtype descriptions will be included in the output SAS dataset.
| Boolean |
Upload SAS Dataset to SAS Cloud Analytic Services (CAS)
(Optional) | Specifies whether the output SAS dataset will be uploaded to CAS or saved in a local SAS library.
| Boolean |
CAS Hostname URL
(Optional) | The URL of the CAS host. | String |
Port
(Optional) | The port of the CAS connection. | Long |
CAS Username
(Optional) | The user name for the CAS connection. | String |
Password
(Optional) | The password for the CAS connection. This password is hidden and not accessible after running the tool. | String Hidden |
Custom Session Configuration File
(Optional) | The file specifying custom configurations for the SAS session. The file is only required for customized local or remote SAS deployments. | File |
Summary
Converts a table to a SAS dataset.
Usage
This tool supports connection to SAS Desktop installed on a local computer or connection to SAS Cloud Analytic Services (CAS). If you're using CAS, the order of the records may change during conversion.
The Custom Session Configuration File parameter must be used for remote deployments of SAS, such as Workspace Server, UNIX, and Mainframe. If SAS is installed on the same machine as ArcGIS Pro, the configuration file is not required.
Provide the SAS dataset in the form libref.tablename in which libref is the name of a SAS or CAS library and tablename is the name of the SAS dataset. For example, SASUSER.MYTABLE references a SAS dataset named MYTABLE in the SASUSER library.
SAS libraries, dataset names, and column names are not case sensitive. For example, SASUSER.MYTABLE is treated the same as sasuser.mytable and SASUser.MyTable.
The number of records that can be converted depends on the available memory of your computer.
For a local SAS deployment, the SASUSER, WORK, SASHELP, MAPS, MAPSSAS, and MAPSGFK libraries are available by default. To use a custom library, the libref must be defined in your SAS Autoexec file.
Parameters
arcpy.conversion.TableToSAS(in_table, out_sas_dataset, {replace_sas_dataset}, {use_domain_and_subtype_description}, {use_cas_connection}, {hostname}, {port}, {username}, {password}, {custom_cfg_file})
Name | Explanation | Data Type |
in_table | The input table. | Table View |
out_sas_dataset | The output SAS dataset. Provide the dataset in the form libref.table in which libref is the name of a SAS library and table is the name of the SAS table. | String |
replace_sas_dataset (Optional) | Specifies whether an existing SAS dataset will be overwritten in the output.
| Boolean |
use_domain_and_subtype_description (Optional) | Specifies whether domain and subtype descriptions will be included in the output SAS dataset.
| Boolean |
use_cas_connection (Optional) | Specifies whether the output SAS dataset will be uploaded to CAS or saved in a local SAS library.
| Boolean |
hostname (Optional) | The URL of the CAS host. | String |
port (Optional) | The port of the CAS connection. | Long |
username (Optional) | The user name for the CAS connection. | String |
password (Optional) | The password for the CAS connection. This password is hidden and not accessible after running the tool. | String Hidden |
custom_cfg_file (Optional) | The file specifying custom configurations for the SAS session. The file is only required for customized local or remote SAS deployments. | File |
Code sample
The following Python window script demonstrates how to use the TableToSAS function with a local SAS installation.
import arcpy
arcpy.conversion.TableToSAS("MyData", "sasuser.MySASData", "OVERWRITE",
"USE_DOMAIN", "LOCAL_SAS")
The following stand-alone Python script demonstrates how to use the TableToSAS function using a connection to CAS.
# Import system modules
import arcpy
import getpass
# Provide tool parameters
in_table = "MyData"
out_SASDS = "casuser.MySASData"
replace_output = "OVERWRITE"
field_domains = "USE_DOMAIN"
connection = "USE_CAS"
hosturl = https://XXX.vdp.sas.com/XXX-XXXXX-default-http/
port = 100
username = "CAS_user"
# Provide password securely
password = getpass.getpass()
try:
# Set the workspace and run the tool.
arcpy.env.workspace = r"C:\\TableToSAS\\MyData.gdb"
arcpy.conversion.TableToSAS(in_table, out_SASDS, replace_output,
field_domains, connection, hosturl, port,
username, password)
except arcpy.ExecuteError:
# If an error occurred when running the tool, print the error message.
print(arcpy.GetMessages())
Environments
Licensing information
- Basic: Yes
- Standard: Yes
- Advanced: Yes