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