nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

write selected rows to a new file

awalts12

I have a script where I select rows from a table based on certain criteria:

dt << Select Where( :gender == "female" & :dx == "ild" );

How can I write these "selected rows" to a new file?

Thanks

Accepted answers

DaveLee

awalts12,

Sounds like you have column A selected. In that case JMP will subset the selected column and selected rows.

dt << Select Where( :gender == "female" & :dx == "ild" );

dt << Clear Column Selection();

sub=dt<<Subset(output table name(<Your Table Name>), Selected Rows(1));

All comments

DaveLee

Awalts12,

You should be able to do the following:

dt << Select Where( :gender == "female" & :dx == "ild" );

sub=dt<<Subset(output table name(<Your Table Name>), Selected Rows(1));

Dave

awalts12

This looks good ...

But it outputs only the first column (call it Column A) in each row. Is there a way to write the entire row (Columns A - Column R).

Thanks again

DaveLee

awalts12,

Sounds like you have column A selected. In that case JMP will subset the selected column and selected rows.

dt << Select Where( :gender == "female" & :dx == "ild" );

dt << Clear Column Selection();

sub=dt<<Subset(output table name(<Your Table Name>), Selected Rows(1));

The first column may have been selected. Try this to override any column selection:

sub = dt << Subset(output table name("my_sub"), Selected Rows(1), Selected Columns(0));

awalts12

Thanks for the help - this works nicely.

One other question as I am new to JMP's syntax. How can I include a wild card in the "select Where" command.

For example

dt << Select Where( :name == "A*")

doesn't seem to work - I'd like to be able to select all names starting with an A.

Thanks again.