Setting Table Properties

SAS program

In order to complete your new table, you must define the following properties:

General Properties

Property

Description

Description The preferred display name of the new table.
Refresh with warehouse The refresh status of table data. If this item is checked, the information contained within your table will be automatically updated when the warehouse tables are updated. If you want the data that is within your document to remain in its original state, do not check.
Last run at The date and time the information was last refreshed, either by a warehouse refresh, or manually. This field is populated automatically.

Content Properties

Property

Description

Source Entries Populated automatically with information you provided on the previous screen.
Output Table Name Populated automatically with information you provided on the previous screen.
Update column attributes from physical table when refreshed? Column attribute refresh status. If checked, the column metadata will be rewritten from the output table data when the warehouse is refreshed.
Delete table before refreshing? Status of table deletion. A failure of the code to build your table can result in an old (original) version of the table or a deletion of the table, depending on whether you check the box. Certain source programs add to existing tables, so in these cases, you would not want to delete before refreshing.

Column Properties

Property

Description

Column Selection Column from your table that can be set with various attributes such as order and security. You can also designate the column as a key column.
Description Contents of the column.
Order Order in which you want the column to appear in the table (e.g. 1,2,3, etc.).
Format Automatically populated with the valid SAS format that corresponds to your column data.
Informat Automatically populated with the valid SAS informat that corresponds to your column data.
Length Automatically populated with the length of your column data.
Type Type of data displayed in the column: Date, Numeric, Character, Currency, Time, or Date-Time.
Column Security Level of security required for your column.
Key Key field designation. If you want to designate the column as a key field, select Primary or Secondary. Otherwise, select None.
Parent The column name you want at the highest level of the hierarchy
Grouping Column? Parent column grouping. Check this option if you want the ability to group data by the selected parent column.
Extended Column Description A more extensive description of your column that can be displayed as hover text in your table, depending on the options that your administrator sets.

Advanced Properties

Property

Description

Security Code Level of security you required by query.
Metric Dataset? Availability of table. When this checkbox is selected, the table will be available to use when creating a metric. When deselected the table will not be available.
Disable copying of this table? The option to create copies of the table. Check this option if you do not want to other users to be able to create copies of the table.
Allow column attributes to be propagated to this table? Propagation of column attributes. If you enable this option, any changes made to tables in the warehouse will be propagated to this table. If this option is not enabled, changes made to warehouse tables will not affect this table.
Hide from end users? Ability to view query. Select this option if you do not want end users to be able to view this query.
Apply Security Subsets? Security subset required by your data. Security subsets determine the groups of security preferences that a user can be assigned to. Refer to Managing Security Subsets for more information.
Metadata Key Populated automatically with the metadata key of the table. The key can be used in the event that you want to use the table in a SAS code macro.
Build Order Order the table is built when the warehouse is refreshed. Keep in mind that your table may depend on information from other tables, and this should be reflected in the build order.
Topics Category in which you want this analysis to reside.
Extended description Description of your analysis.
Presubmit Code Any SAS code that you want HR Vision to run.

After you complete the required information, click OK to save your table. To view your report, refer to Viewing Tables.