create new var conditionally

Sultana — Thu, 03 Jan 2019 15:31:06 GMT

I want to add a new var as Guarantor Dependent at origination (85) or after origination (95), How do I write the code.

select
b.mktDesc,
a.acctno,
a.acctSName,
a.balToday,
a.commitment,
a.restructFlg,
GuarantorDep = '',
a.PD,

Re: create new var conditionally

r_behata — Thu, 03 Jan 2019 16:04:37 GMT

Not exactly sure what you are looking for . But, If you want the New Var to have a different value depending on the values in origination, you may use a case statement.

case when 
	origination=85
	then  'A'
	when
	origination=95
	then 'B'
End as GuarantorDep

Replace the values 'A' and 'B' as per your requirement.

topic Re: create new var conditionally in SAS Enterprise Guide

create new var conditionally

Re: create new var conditionally