This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
how to select only those samples that meet two or more criteria
Created:
Sep 22, 2022 11:56 AM
| Last Modified: Jun 9, 2023 11:58 AM(610 views)
i want to create a new column using Day1_Orig values wherein there are both Day1_Orig and Day1_Repeat values for the same SUBJID. So for instance, lines 113 and 114 have same SUBJID, so the new column would record the value of the Day1_Orig value in line 113 (834), but as there is no corresponding Day1_Repeat value for line 107 (641), this Day1_Orig value would not be included in the new column.
Names Default To Here(1);
dt = New Table("Untitled 3",
Add Rows(6),
New Column("S", Numeric, "Continuous", Format("Best", 12), Set Values([89, 89, 96, 96, 96, 96])),
New Column("O", Numeric, "Continuous", Format("Best", 12), Set Values([641, ., 834, ., ., .])),
New Column("R", Numeric, "Continuous", Format("Best", 12), Set Values([., ., ., 230, ., .]))
);
dt << New Column("Test", Numeric, Continuous, Formula(
If(Col Number(:O, :S) != 0 & Col Number(:R, :S), /*check if both and :R have value for this :S*/
If(Col Cumulative Sum(!IsMissing(:O), :S) == 1, /* Check if row is first found value for for this :S*/
:O
)
);
));