Using JMP > JMP Technical Details > Conventions for Mapping JMP Attributes to SAS Extended Attributes
Publication date: 08/13/2020

Conventions for Mapping JMP Attributes to SAS Extended Attributes

SAS extended attributes are metadata that you define in SAS code to import information such as table scripts, labels, length, and type. You associate the extended attributes with a data set or variable and define them in name-value pairs, such as _JMP_TABLESCRIPTNAME_2="OnOpen".

This section provides information about SAS extended attributes and their corresponding JMP attributes.

Table B.1 Table Attributes

JMP Table Attribute

SAS Attribute Name

SAS Attribute Type and Default Value

Description

Table Variable Count

_JMP_TABLEVARCOUNT

Numeric, 0

Count of table variables

Table Variable Name 1

_JMP_TABLEVARNAME_1

String

Name of the first table variable

Table Variable Value 1

_JMP_TABLEVARVALUE_1

String

Value of the first table variable

Table Variable Name 2

_JMP_TABLEVARNAME_2

String

Name of the second table variable

Table Variable Value 2

_JMP_TABLEVARVALUE_2

String

Value of the second table variable

Table Variable Name n

_JMP_TABLEVARNAME_n

String

Name of the nth table variable

Table Variable Value n

_JMP_TABLEVARVALUE_n

String

Value of the nth table variable

Table Script Count

_JMP_TABLESCRIPTCOUNT

Numeric

Count of table scripts

Table Script Name 1

_JMP_TABLESCRIPTNAME_1

String

Name of the first table scripts

Table Script Value 1

_JMP_TABLESCRIPTVALUE_1

String

Value of the first table scripts

Table Script Name 2

_JMP_TABLESCRIPTNAME_2

String

Name of the second table script

Table Script Value 2

_JMP_TABLESCRIPTVALUE_2

String

Value of the second table script

Table Script Name n

_JMP_TABLESCRIPTNAME_n

String

Name of the table script n

Table Script Value n

_JMP_TABLESCRIPTVALUE_n

String

Value of table script n

Lock Data Table

_JMP_ISLOCKED

Boolean, 0

Locked table

Suppress Formula Eval

_JMP_SUPPRESSEVAL

Boolean, 0

Suppressed formula evaluation

Column Group Count

_JMP_COLGRPCOUNT

Numeric, 0

Number of column groups

Column Group Name 1

_JMP_COLGRPNAME_1

String

Name of column group 1

Column Group Start Col 1

_JMP_COLGRPSTARTCOL_1

String

Name of first column in group 1

Column Group NCols 1

_JMP_COLGRPNCOLS_1

Numeric

Number of columns in group 1

Column Group Name 2

_JMP_COLGRPNAME_2

String

Name of column group 2

Column Group Start Col 2

_JMP_COLGRPSTARTCOL_2

String

Name of first column in group 2

Column Group NCols 2

_JMP_COLGRPNCOLS_2

Numeric

Number of columns in group 2

Column Group Name n

_JMP_COLGRPNAME_n

String

Name of column group n

Column Group Start Col n

_JMP_COLGRPSTARTCOL_n

String

Name of first column in group n

Column Group NCols n

_JMP_COLGRPNCOLS_n

Numeric

Number of columns in group n

Table B.2 Column Attributes

JMP Column Attribute

SAS Attribute Name

SAS Attribute Type and Default Value

Description

Column Name

_JMP_COLNAME

String

Original column name in JMP

Data Length

_JMP_DATALENGTH

Numeric, 0

Length of the data. For numeric types, the value can be 1, 2, 4, or 8. For character types, 0 (or negative) means variable length, positive values mean fixed-length.

Row State column

_JMP_ISROWSTATE

Numeric, 0

0 = not row state, 1 = default row state for table, 2 = row state column

Label

_JMP_ISLABEL

Boolean, 0

Label column. 1 for yes. 0 for no.

Scroll Lock

_JMP_ISSCROLLLOCK

Boolean, 0

Scroll locked column. 1 for yes. 0 for no.

Hidden

_JMP_ISHIDDEN

Boolean, 0

Hidden column. 1 for yes. 0 for no

Excluded

_JMP_ISEXCLUDED

Boolean, 0

Excluded column. 1 for yes. 0 for no

Notes

_SAS_NOTES

String

Notes about the column

Modeling Type

_SAS_LEVEL

String

Valid values are Binary, Interval, Ordinal, Nominal, Unary. JMP maps Binary and Unary to Nominal and Interval to Continuous.

Preselect Role

_SAS_MININGROLE

String

Valid values are Assessment, Censor, Classification, Cost, Cross ID, Decision, Frequency, ID, Input, Key, Label, Prediction, Referrer, Rejected, Residual, Segment, Sequence, Target, Text, Text Location, Time ID, Treatment, Web Address, Weight. JMP maps Y to Target, X to Input, Freq to Frequency, and Weight to Weight.

Distribution

_SAS_DISTRIBUTION

String

Distribution type to fit for this column

Format Name

_JMP_FORMATNAME

String

Format of the column (such as Fixed Dec or Percent)

Format Width

_JMP_FORMATWIDTH

Numeric

Width of the column

Format Decimals

_JMP_FORMATDECIMALS

Numeric

Number of decimal places

Format Code

_JMP_FORMATCODE

String

Typically the currency code for currency formats

Use Thousands Separator

_JMP_USETHOUSANDSSEP

Boolean, 0

Include thousands separator. 1 for yes. 0 for no.

Input Format

_JMP_INFORMAT

String

Input format (for date, time, or duration-formatted columns)

Formula

_JMP_FORMULA

String

Column formula

Suppress Formula Eval

_JMP_SUPPRESSEVAL

Boolean, 0

Suppressed formula evaluation. 1 for yes. 0 for no.

Lock

_JMP_ISLOCKED

Boolean, 0

Locked column. 1 for yes. 0 for no.

Range Check Code

_JMP_RANGECHECK_CODE

String

A code that identifies the type of range check. Examples are LE, LT, LTLT, !LT, and !LELE.

Range Check Low

_JMP_RANGECHECK_LOW

Numeric

First argument to range check

Range Check High

_JMP_RANGECHECK_HIGH

Numeric

Second optional argument to range check

List Check

_JMP_LISTCHECK

String

List check

Missing Value Codes

_JMP_MISSINGCODES

String

Values to be treated as missing

Value Label Count

_JMP_VALUELABEL_COUNT

Numeric

Count of value labels

Value Label Code

_JMP_VALUELABELCODE_1

String

Code for the value label (such as EQ, LT, LE, LTLT, and LELT.). Always EQ for character variables.

Value Label Lower Bound

_JMP_VALUELABELLOW_1

Varies

The lower bound of a numeric range, or the only bound if the ranges is unbounded on one side. A string for character columns. Numeric for numeric columns.

Value Label Upper Bound

_JMP_VALUELABELHIGH_1

Numeric

The upper bound of a numeric range. Not used for character value labels.

Value Label Display

_JMP_VALUELABELDISPLAY_1

String

The display string for this value label

Use Value Labels

_JMP_USEVALUELABELS

Boolean, 0

Uses value labels when displaying this column. 1 for yes. 0 for no.

Value Scores

_JMP_VALUESCORES

String

Associates data values with numerical scores

Value Order

_JMP_VALUEORDER

String

The order of values for the column

Value Colors

_JMP_VALUECOLORS

String

Maps values to colors.

Color Gradient

_JMP_COLORGRADIENT

String

Maps values to a color gradient.

Color Cells

_JMP_COLORCELLS

Boolean, 0

Color cells of this column using the specified value colors or color gradient. 1 for yes. 0 for no.

Axis

_JMP_AXIS

String

Axis definition

Coding

_JMP_CODING

String

Code a range of values to -1, 1 for modeling purposes

Mixture

_JMP_MIXTURE

String

Participation in a mixture of columns adding up to a value. The Mixture column property has numeric values (limits) and string values (L Pseudo Component and U Pseudo Component).

Row Order Levels

_JMP_ROWORDER

Boolean, 0

Sort the column by occurrence rather than value. 1 for yes. 0 for no.

Spec Limits

_JMP_SPECLIMITS

String

Target value and upper and lower spec limits

Control Limits

_JMP_CONTROLLIMITS

String

Control limits for control chart type

Response Limits

_JMP_RESPONSELIMITS

String

Bounds on response’s acceptable range, used by profilers

Design Role

_JMP_DESIGNROLE

String

Role in a designed experiment

Factor Changes

_JMP_FACTORCHANGES

String

Difficulty of changing a factor, for DOE. Value values: Easy, Hard, Very Hard

Sigma

_JMP_SIGMA

String

Sigma for Control Charts

Units

_JMP_UNITS

String

Units for this variable; can be any string

Time Frequency

_JMP_TIMEFREQ

String

Numeric, Annual, Quarterly, Monthly, Weekly, Daily, Hourly, By Minutes, By Seconds

Map Role

_JMP_MAPROLE

String

Role in a map data set

Multiple Response Separator

_JMP_MRSEP

String, ","

Separator for a multiple-response column.

Label Column

_JMP_LABELCOLUMN

Boolean, 0

Is this column a label column? 1 for yes. 0 for no.

Expression Column

_JMP_ISEXPRESSIONCOLUMN

Boolean, 0

Is this column an expression column? 1 for yes. 0 for no.

Table B.3 Custom Column Properties

JMP Column Attribute

SAS Attribute Name

SAS Attribute Type and Default Value

Description

Custom Property Count

_JMP_CUSTCOLPROPCOUNT

Numeric, 0

Count of custom column property

Custom Property Name 1

_JMP_CUSTCOLPROPNAME_1

String

Name of the custom column property 1

Custom Property Value 1

_JMP_CUSTCOLPROPVALUE_1

String

Value of the custom column property 1

Custom Property Name 2

_JMP_CUSTCOLPROPNAME_2

String

Name of the custom column property 2

Custom Property Value 2

_JMP_CUSTCOLPROPVALUE_2

String

Value of the custom column property 2

Custom Property Name n

_JMP_CUSTCOLPROPNAME_n

String

Name of the custom column property n

Custom Property Value n

_JMP_CUSTCOLPROPVALUE_n

String

Value of the custom column property n

Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).
.