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; } } }

Ordered differences combined data table - Outline Box

Georgios_Tsim

After running a least squares model by some variables we can have at the output window the ordered differences as the screenshot below illustrates.

Is it possible to take only the differences with the REF characterization in the level name.

Note that I have the name of the Reference assigned to the "batchRefChoice" variable. So is it possible to take a combined Data table having all the differences with the REFERENCE in the form:

Level - Level

A1 REF

A2 REF

A3 REF

Accepted answers

jthi

So perform the selection twice / utilize two conditions (-Level contains REF and Level doesn't contain REF)? You can also do the filtering in the table box but that is more limited and you would have to use JSL expression to have two conditions

All comments

jthi

Make the combined data table, select rows from the -Level column which have _REF_, invert selection and delete rows (or pick rows which don't have _REF_ and delete rows). Select Where platform should be able to build the comparison

Use contains for the comparison

Georgios_Tsim

Nice! It is a solution as I have to do the same for the column "Level" and "- Level" and select the appropriate lines. But the problem is that the REF indicator is not only located at the -Level column. Is there any way to do also this?

jthi

What type of filtering you want to do?

Georgios_Tsim

I would like to take the Combined Data Table having only the differences with the REF. But I want them in the form:

Level - Level

A1 REF

A2 REF

A3 REF

As you can see in the screenshot that I provided in my first question above, at the end of the table there is the REF indicator at the "Level" Column and not at the "- Level".

But to explain wat I am asking:

In SAS you can do that providing the following line in the mixed process:

lsmeans condition/ diffs=control("REF") alpha=0.1;

and you get the following table:

is it possible that in jsl?