I am trying to create a subset of data of “high intermediate risk” group of entries as defined by a criteria based on age and number of risk factors.

It is:

Age over 70 plus at least 1 risk factor

Age 50-70 plus at least 2 risk factors

Age under 50 plus all three risk factors

The risk factors are:

1. Having a “Grade” of 2-3

2. Presence of invasion

3. Tumor extension is more than 50%

Age (variable: “AGE”; code 001 = age 1, etc)

Grade (variable: “GRADE”; code 2 = grade 2, 3 = grade 3)

Invasive (variable: “INVASION” where code 1 = invasion is present)

Tumor Extension more than 50% (variable: CS_EXTENSION where codes 130, 133, and 135 all mean more than 50% tumor extension criteria is met)

Can anyone help to create a subset that would "capture" all of these entries in a data set? I have not been having any luck so far.

Thanks so much,

kungfupanda