Solved: Nested case when stmts.

SASnewbie2 · Posted 12-21-2018 01:09 AM

learsaas · Posted 12-21-2018 01:57 AM

CASE
WHEN t1.Acc_No4 IN (" ") THEN t1.Acc_No3
WHEN t1.Nmp_Subclass IN ("HRN","FRB", "HOC", "HON", "HHH") AND (t1.Acc_No3 ^? "3040820") AND (t1.Acc_No3 ^? "9040172") THEN CATS(t1.Acc_No3,"PCL")
else t1.Acc_No3

View solution in original post

learsaas · Posted 12-21-2018 01:57 AM

CASE
WHEN t1.Acc_No4 IN (" ") THEN t1.Acc_No3
WHEN t1.Nmp_Subclass IN ("HRN","FRB", "HOC", "HON", "HHH") AND (t1.Acc_No3 ^? "3040820") AND (t1.Acc_No3 ^? "9040172") THEN CATS(t1.Acc_No3,"PCL")
else t1.Acc_No3

SASnewbie2 · Posted 12-21-2018 02:01 AM

Thanks Learsaas,

does it means the formula only work in one line ?

Nested case when stmts.

Re: Nested case when stmts.

Re: Nested case when stmts.

Re: Nested case when stmts.

Nested case when stmts.

Re: Nested case when stmts.

Re: Nested case when stmts.

Re: Nested case when stmts.

The 2025 SAS Hackathon has begun!

SAS Training: Just a Click Away