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 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

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 Count	_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 Ordering	_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.

Custom Column Properties
JMP Column Attribute	SAS Attribute Name	SAS Attribute Type and Default Value	Number of custom column properties
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