topic Re: Nested case when stmts. in SAS Enterprise Guide

Nested case when stmts.

SASnewbie2 — Mon, 24 Dec 2018 03:41:21 GMT

Re: Nested case when stmts.

learsaas — Fri, 21 Dec 2018 06:57:32 GMT

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

Re: Nested case when stmts.

SASnewbie2 — Fri, 21 Dec 2018 07:01:55 GMT

Thanks Learsaas,

does it means the formula only work in one line ?