%let indconn = user=youruserid password=yourpwd dsn=yourdsn;
specifies the Aster user name (also called the user ID) that is used to connect to the database.
specifies the password that is associated with your Aster user ID.
Tip | You can use only PASSWORD=, PASS=, or PW= for the password argument. PWD= is not supported and causes an error. |
specifies the configured Aster data source to which you want to connect.
Requirement | You must specify either the DSN= argument alone, or the SERVER= and DATABASE= arguments in the INDCONN macro variable. |
specifies the Aster database that contains the tables and views that you want to access.
Requirement | You must specify either the DSN= argument alone, or the SERVER= and DATABASE= arguments in the INDCONN macro variable. |
specifies the Aster server name or the IP address of the server host.
Requirement | You must specify either the DSN= argument alone, or the SERVER= and DATABASE= arguments in the INDCONN macro variable. |
specifies the schema name for the database.
Default | Your default schema. To determine your default schema name, use the show search_path command from the Aster Client Tool (ACT). |
Restriction | The SCHEMA argument is valid only for Aster 4.6. For Aster 4.5, the format XML files are published to the PUBLIC schema. |
Requirement | Any schema that is used must be in the search path. |
specifies the name of an Aster database to which the format files are published to either the NC_INSTALLED_FILES table (Aster 4.5) or the NC_USER_INSTALLED_FILES table (Aster 4.6). This argument lets you publish the sasput_type_fmtname.xml format files to a shared database where other users can access them.
Restriction | If you specify DSN= in the INDCONN macro variable, do not use the DATABASE argument. For more information, see Running the %INDAC_PUBLISH_FORMATS Macro. |
Tip | It is not necessary that the format definitions and the SAS_PUT( ) function reside in the same database as the one that contains the data that you want to format. You can use the SQLMAPPUTO= system option to specify the database where the format definitions and the SAS_PUT( ) function have been published. |
specifies the name of the format catalog file that contains all user-defined formats that were created with the FORMAT procedure and are made available in Aster.
Default | If you do not specify a value for FMTCAT= and you have created user-defined formats in your SAS session, the default is WORK.FORMATS. If you do not specify a value for FMTCAT= and you have not created any user-defined formats in your SAS session, only the formats that SAS supplies are available in Aster. |
Interaction | If the format definitions that you want to publish exist in multiple catalogs, you must copy them into a single catalog for publishing. If you specify more than one format catalog using the FMTCAT argument, only the last catalog that you specify is published. |
See | Considerations and Limitations with User-Defined Formats |
specifies a list of formats that are created, replaced, or dropped.
Default | ALL |
Requirements | Format names must be separated with a space. |
Character format names must begin with a dollar sign ($); for example, $EMPNAME. | |
Interaction | When ACTION=CREATE or REPLACE, the list of formats that are in the specified format catalog (FMTCAT=) are added to either the NC_INSTALLED_FILES table (Aster 4.5) or the NC_USER_INSTALLED_FILES table (Aster 4.6). When ACTION=DROP and FMTCAT=ALL, all the formats listed in FMTLIST are dropped. If ACTION=DROP and FMTCAT=format-catalog-filename, only those listed formats that exist in the format catalog are dropped. |
specifies that the macro performs one of these actions:
creates a sasput_type_fmtname.xml file for each user-defined format in the format catalog.
Tip | If a format file already exists, an error occurs. |
overwrites the current sasput_type_fmtname.xml file if it is already registered or creates a new sasput_type_fmtname.xml file, if one is not registered.
causes the sasput_type_fmtname.xml files to be dropped from either the NC_INSTALLED_FILES table (Aster 4.5) or the NC_USER_INSTALLED_FILES table (Aster 4.6) in the database.
Interaction | If FMTCAT=ALL, all user-defined format files are dropped. |
Default | CREATE |
Tip | If the format files was defined previously and you specify ACTION=CREATE, you receive warning messages from Aster. If the format files were defined previously and you specify ACTION=REPLACE, a message is written to the SAS log indicating that the format file has been replaced. |
specifies a directory that contains diagnostic files.
See | Special Characters in Directory Names |
%let indconn = server=acbase user=user1 password=open1 dsn=ncluster;
%indac_publish_formats(fmtcat= fmtlib.formats);