<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
Dear all,
I an not find some pretty basic feature, and I am assuming I am just being blind....
Is there some easy-to-use way to get a report on all variables I have in a JMP data set and their attributes - something like proc contents in SAS. I do not want to do it via calling a SAS function because in the long run my scripts should work independent from a SAS installation. Is there something implementent (I am using JMP 10)?
Regards,
Ursula
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />"You can see column properties one by one if you right click on a column and select Column Info."
It may be worth mentioning that if you select all or some of the columns in a data set and right click on one of the selected columns and choose Column Info you will get a scrollable window containing info for all of the selected columns. Less compact than then PMroz' script and not all the info in David's script/add in but maybe useful as well.
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />I don't think there is an equivalent to PROC CONTENTS in JMP. You can see column properties one by one if you right click on a column and select Column Info. There are many column properties that could be listed; here's a short program that lists some of the major ones in the Log window. It uses Big Class as an example.
dt = open("$sample_data\Big Class.jmp");
col_list = dt << get column names();
col_names = dt << get column names(string);
for (i = 1, i <= nitems(col_list), i++,
one_col = col_list[i];
col_data_type = one_col << get data type;
col_modeling_type = one_col << get modeling type;
col_format = char(one_col << get format);
col_role = one_col << get role;
col_formula = char(one_col << get formula);
print("Column Name: " || col_names[i]);
print(" Data Type: " || col_data_type);
print(" Modeling Type: " || col_modeling_type);
print(" Format: " || col_format);
print(" Role: " || col_role);
print(" Formula: " || col_formula);
);
Here's the output from log window:
"Column Name: name"
" Data Type: Character"
" Modeling Type: Nominal"
" Format: Format(\!"Best\!", 9)"
" Role: None"
" Formula: Empty()"
"Column Name: age"
" Data Type: Numeric"
" Modeling Type: Ordinal"
" Format: Format(\!"Fixed Dec\!", 5, 0)"
" Role: None"
" Formula: Empty()"
"Column Name: sex"
" Data Type: Character"
" Modeling Type: Nominal"
" Format: Format(\!"Best\!", 1)"
" Role: None"
" Formula: Empty()"
"Column Name: height"
" Data Type: Numeric"
" Modeling Type: Continuous"
" Format: Format(\!"Fixed Dec\!", 5, 0)"
" Role: None"
" Formula: Empty()"
"Column Name: weight"
" Data Type: Numeric"
" Modeling Type: Continuous"
" Format: Format(\!"Fixed Dec\!", 5, 0)"
" Role: None"
" Formula: Empty()"
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />Dear mpd,
thanks for your answer :>). Basically what I need is mostly for scripting and automising analyses - and there Davids tool is perfect, and the PMroz script is a good starting point for generating a report -when directing the output not to the log but to a journal.
Regards,
Ursula
