topic Re: Ordered differences combined data table - Outline Box in Discussions

Ordered differences combined data table - Outline Box

Georgios_Tsim — Mon, 22 Jul 2024 13:45:33 GMT

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

Re: Ordered differences combined data table - Outline Box

jthi — Mon, 22 Jul 2024 13:51:00 GMT

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

Re: Ordered differences combined data table - Outline Box

Georgios_Tsim — Mon, 22 Jul 2024 14:05:11 GMT

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?

Re: Ordered differences combined data table - Outline Box

jthi — Mon, 22 Jul 2024 14:18:50 GMT

What type of filtering you want to do?

Re: Ordered differences combined data table - Outline Box

Georgios_Tsim — Mon, 22 Jul 2024 14:31:12 GMT

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?

Re: Ordered differences combined data table - Outline Box

jthi — Mon, 22 Jul 2024 14:44:43 GMT

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