S
Stan
i have a table of data that contains follow-up information for a large number
of patients. a patient may have multiple rows of data corresponding to
different follow-up dates after treatment. each row of data contains a
distinct date and associated grades of toxicity for that date of interest.
there are multiple types of toxicity that a patient can have (e.g. bladder
obstruction, bladder bleeding, incontinence). how could i write a command to
return the maximum grade of toxicity across these 3 columns (in this example,
if a patient has a grade 1 obstruction, a grade 2 bleed, and grade 2
incontinence i would like to return '2'')? is there a simple comparison
function within the "build" option?
additionally... i would like to identify the earliest date for which a grade
2 toxicity is seen. i know how to do this in a way that is complicated - i
can make a query that filters for grade 2 toxicity, and then write another
query to return the minimum date from that set of data. however in this
example that would require making 6 queries to get the dates associated with
each of these 3 toxicities. is there an easier way to return the earliest
date of any grade 2 bladder toxicity?
many thanks!
of patients. a patient may have multiple rows of data corresponding to
different follow-up dates after treatment. each row of data contains a
distinct date and associated grades of toxicity for that date of interest.
there are multiple types of toxicity that a patient can have (e.g. bladder
obstruction, bladder bleeding, incontinence). how could i write a command to
return the maximum grade of toxicity across these 3 columns (in this example,
if a patient has a grade 1 obstruction, a grade 2 bleed, and grade 2
incontinence i would like to return '2'')? is there a simple comparison
function within the "build" option?
additionally... i would like to identify the earliest date for which a grade
2 toxicity is seen. i know how to do this in a way that is complicated - i
can make a query that filters for grade 2 toxicity, and then write another
query to return the minimum date from that set of data. however in this
example that would require making 6 queries to get the dates associated with
each of these 3 toxicities. is there an easier way to return the earliest
date of any grade 2 bladder toxicity?
many thanks!