topic Re: Return max value from a row in SAS Customer Intelligence

Return max value from a row

keiwo — Tue, 03 May 2022 20:05:41 GMT

Greetings,

Hope everyone is doing well.

Below is an example of an output from SAS MA export node

CUSTOMER_ID	Scoring_Var1	Scoring_Var2	Scoring_Var3
CUST0000001	0.98765	0.01234	0.99999

Question: is there a way to create a calculated field that will return the max(Scoring_Var) for each row.

Thanks in advance 😁

Re: Return max value from a row

mklangley — Tue, 03 May 2022 21:03:19 GMT

Here's one way, using an array, that is suitable for any number of scoring_var# columns you have.

data have;
    input customer_id $12. scoring_var1 scoring_var2 scoring_var3;
    datalines;
CUST0000001 0.98765 0.01234 0.99999
CUST0000002 0.87654 0.76543 0.54321
    ;
run;

data want;
    set have;
    array scoring_columns scoring_var:;
    max = max(of scoring_columns[*]);
run;

For more details, or to see a few other methods, see this link.

Re: Return max value from a row

JamesAnderson — Wed, 04 May 2022 05:09:41 GMT

Perhaps LARGEST() is the SQL function that would do this for you (although you will need to confirm its available in CI Studio). In a calculated item create an expression like: LARGEST(1, Scoring_Var1, Scoring_Var2, Scoring_Var3)

Regards

James