Contents SAS Publisher Previous Next
 

Adding a SAS Data Set to a Package

If you specify SAS Data Set as the item type on the Specify Item to Insert window, additional fields and an additional button appear on the Specify Item to Insert window.

  1. Specify the format for the SAS data set by clicking the appropriate Packaging Format for Dataset button:

    Native SAS Dataset
    maintains SAS data in a proprietary format that is necessary for continued data processing in a SAS environment.
    Comma Separated Value
    specifies a delimiter character that is used to separate data columns, which is useful when exporting SAS data to an external application such as a third-party spreadsheet. A comma is the default delimiter.

    If you choose a comma-separated list format, you can accept the default delimiter (a comma) or enter an alternative delimiter in the Separator to Use for CSV field. Also, you can specify whether to exclude variable names or labels or both from the file by clicking the appropriate check boxes.

    Specify data set item to insert

  2. Identify the instance of the item to be included in the package.

    Clicking the Select Data Set to Publish button displays the Select a Member window, which functions much like an Explorer window, that enables you to navigate a directory structure so that you can locate and select the item to be included in the package.

    Select a data set and click OK.

    Control is returned to the Specify Item to Insert window where the name of the data set appears automatically in the Select Data Set to Publish field.

  3. Optionally specify a description and a name/value pair. For details, see Describing an Instance of the Item.

  4. Click the Advanced Settings button to display the Specify Data Set Options window.

    Advanced data set settings

    In the Data Set Options field, specify options as a text string in the following form:

    option1=value option2=value ...

    Example:

    pw='born2run' keep=empno

    Surround string values, such as a password, with single quotation marks.

    You can specify a value for data set options that apply to a data set that is opened for input.

    Examples of options that you can specify on this window are

    • GENNUM=
    • LABEL=
    • OUTREP=
    • SORTEDBY=
    • TOBSNO=
    • TRANTAB=
    • PW=
    • READ=
    • WRITE=
    • ALTER=
    • FIRSTOBS=
    • OBS=
    • WHERE=
    • IDXNAME=
    • IDXWHERE=
    • DROP=
    • KEEP=
    • RENAME=

    For a complete list of data set options, see the SAS Data Set Options topic in either the SAS Online Help, Release 8.2 or the SAS Version 8 online documentation.

  5. In order to include either a read-protected or a password-protected data set in the package, check the Allow Read Protected Data Sets to be Published check box.

  6. If the data set that you specified is read-protected, you must also assign a password value to the data set PW= option.

    This is the same password that the consumer must supply in order to access the read-protected data set at package retrieval time.

    Publishing fails if either the check box is not checked or a valid password is not specified. In the former case, the SAS log displays the following message:

    Publish of package failed - ERROR: Unable to publish read protected data set

  7. After you finish specifying data set options, click OK to return to the Specify Item to Insert window.

  8. From the Specify Item to Insert window, click OK again to return to the What to Publish tab to continue specifying the package.

Contents SAS Publisher Previous Next