Export SAS (R)
Export in SAS or SAS Transport format in Opal file system.
opal export-r-sas <CREDENTIALS> <OPTIONS> [EXTRAS]
Options
Option |
Description |
---|---|
|
Datasource name |
|
The list of tables to be exported |
|
Incremental export |
|
Entity ID mapping name |
|
ID column name (optional) |
|
Output SAS or SAS Transport file name on the Opal file system |
Credentials
Authentication can be done by username/password credentials OR by personal access token OR by certificate/private key pair (two-way SSL authentication).
Option |
Description |
---|---|
|
Opal server base url |
|
Credentials auth: user name (requires a password) |
|
Credentials auth: user password (requires a user name) |
|
Token auth: user’s personal access token |
|
Two-way SSL auth: certificate/public key file (requires a private key) |
|
Two-way SSL auth: private key file (requires a certificate) |
Extras
Option |
Description |
---|---|
|
Show the command help’s message. |
|
Verbose output. |
|
Output pretty-print JSON |
Example
Export table from opal-data to a SAS file:
opal export-r-sas --opal https://opal-demo.obiba.org --user administrator --password password --datasource opal-data --tables StandingHeight --output /tmp/sh.sas7bdat