| I think if you follow Mark's advice, dt << Get as Matrix _expression_ will simply ignore the character columns.
Did you try that?
If it doesn't work - you could always import the spreadsheet into JMP - then loop through the columns looking at the Column Types and delete those that are not numeric.
JSL is a journey! :)
Wayne
On 8-Feb-09, at 5:52 PM, Fred Zhang wrote: Thanks, Mark. But in my data table, there are some attribute and character columns, so I need to extract the subset (some columns and rows) of the table to produce a pure numeric matrx. In your scheme, I need to do the above in "SOL string" by selecting the columns? Also, what is "DNS string"? Best regards, Fred
On Sun, Feb 8, 2009 at 11:58 AM, Mark Bailey <mark4flies@aol.com> wrote: Schematically:
dt = Open Database( "DNS string", "SQL string" );
m = dt << Get As Matrix;
That's about it. Well, at least as far as you have described the problem!
Best of luck.
Mark
On Feb 8, 2009, at 10:27 AM, Fred Zhang wrote: All these operations can be done by JMP Script language? Any example to demonstrate this function? Mark
They hate you if you're clever, and they despise a fool ("Working Class Hero" - John Lennon)
|