topic Re: Help creating a new category with info from two other columns in New SAS User

Help creating a new category with info from two other columns

careypafford — Fri, 28 May 2021 22:09:34 GMT

I have a data set that has a total score from an assessment and gender. I need to create a new category of, 'risk level' that will use gender and a total score range to give me a risk level. How would I set this up?

Example: if 'gender' = M (options here are M or F) and 'total score' = 8 (I need this to be able to use a range, i.e. 0-7, 8-10,11-15, 16+) then 'risk level' (the newly created category) = Med-Low (options here are Low, Med-Low, Med-High, High)

Any help is appreciated.

Re: Help creating a new category with info from two other columns

PaigeMiller — Fri, 28 May 2021 23:31:42 GMT

@careypafford wrote:

I have a data set that has a total score from an assessment and gender. I need to create a new category of, 'risk level' that will use gender and a total score range to give me a risk level. How would I set this up?

Example: if 'gender' = M (options here are M or F) and 'total score' = 8 (I need this to be able to use a range, i.e. 0-7, 8-10,11-15, 16+) then 'risk level' (the newly created category) = Med-Low (options here are Low, Med-Low, Med-High, High)

Any help is appreciated.

You have given us one possible outcome, but there are many other possibilities and you haven't told us what risk score would result. You haven't told us what would happen if gender='F', and you haven't told us what would happen if total_score=9, and so on. We need to see the full set of possibilities in order to provide code to compute the risk level for you.

Re: Help creating a new category with info from two other columns

Sajid01 — Sat, 29 May 2021 01:36:29 GMT

Hello @careypafford
While there are multiple approaches to solving your problem, with the information you have given I have the following sample code. Modify it to suit your needs

proc sql;
select Name, Sex, age,
case
when Sex="M" and Age between 0 and 7 then 'LOW'
when Sex="M" and Age between 8 and 10 then 'MID-LOW'
when Sex="M" and Age between 10 and 15 then 'MID-HIGH'
when Sex="M" and Age> 16 then 'MID-HIGH'
 else 'NONE'
end as risk_level
from sashelp.class;
quit;

Re: Help creating a new category with info from two other columns

careypafford — Tue, 01 Jun 2021 13:51:49 GMT

The assessment breaks down as follows:

Low: Male: 0-7; Female: 0-10

Med-Low: Male: 8-10; Female: 11-13

Med-High: Male: 11-15; Female: 14-18

High: Male: 16+; Female: 19+

Re: Help creating a new category with info from two other columns

PaigeMiller — Tue, 01 Jun 2021 13:59:05 GMT

Partial example:

data want;
    set have;
    length category $ 8;
    if gender='M' and total_score<=7 then category='Low';
    else if gender='M' and 8<=total_score<=10 then category='Med-Low';
    /* You type the rest */
run;