jmp-l
[Top] [All Lists]

Re: How to generate a Matrix from an Excel file by JSL

To: jmp-l@lists.biostat.wustl.edu
Subject: Re: How to generate a Matrix from an Excel file by JSL
From: Mark Bailey <mark4flies@aol.com>
Date: Sun, 8 Feb 2009 20:40:04 -0500
In-reply-to: <25e89e790902081452w5591ca42nb0e401e02d68b277@mail.gmail.com>
References: <25e89e790902071631w2df2c3faya6df98c2a92cb02@mail.gmail.com> <EFE76F0C-80A7-4C8A-BC09-E0C149D86452@aol.com> <25e89e790902080727u4400f4am2866f419bf4bc1ca@mail.gmail.com> <563A7B71-7A47-4363-BE13-D1A4B620676D@aol.com> <25e89e790902081452w5591ca42nb0e401e02d68b277@mail.gmail.com>
So you data already reside in a JMP data table, not in a database table. I could not tell that much from your previous posts.

The numeric columns will be included in the matrix. Character data columns will automatically be excluded. The modeling type (nominal, ordinal, continuous), however, will not matter. Only the data type matters for the Get As Matrix message when it is sent to a data table. So if you have a numeric nominal or numeric ordinal column, then it will be included.

You could always manually select the columns that you want, subset them, then use the subset data table for use with the Get As Matrix message. The Table menu commands usually result in a data table with a Source table property that saves the script to make the resulting data table. You can copy this script and use it in  your own larger script.

On Feb 8, 2009, at 5:52 PM, Fred Zhang wrote:

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?

Mark

They hate you if you're clever, and they despise a fool ("Working Class Hero" - John Lennon)

=
<Prev in Thread] Current Thread [Next in Thread>