topic Re: How to write the code to remove loans that have payment Center that ends in 30 or 35 in SAS Programming

How to write the code to remove loans that have payment Center that ends in 30 or 35

QAMARSULTANA — Thu, 17 Jan 2019 01:33:29 GMT

How to write the code to remove loans that have payment Center that ends in 30 or 35 in SAS EG and also in SAS VA

Re: How to write the code to remove loans that have payment Center that ends in 30 or 35

ChrisNZ — Thu, 17 Jan 2019 20:32:45 GMT

This entry enters the competition for shortest question.

One way:

where reverse(catt(CENTER)) not in: ('53','03')

[Edited] colon added. Thanks @Astounding.

Re: How to write the code to remove loans that have payment Center that ends in 30 or 35

Reeza — Thu, 17 Jan 2019 01:49:30 GMT

Is Payment Centre numeric or character? Are you programming or using the GUI.

Re: How to write the code to remove loans that have payment Center that ends in 30 or 35

Astounding — Thu, 17 Jan 2019 03:49:40 GMT

This looks promising, but should add a colon:

where reverse(catt(CENTER)) not in : ('53','03')

Re: How to write the code to remove loans that have payment Center that ends in 30 or 35

ChrisNZ — Thu, 17 Jan 2019 06:15:10 GMT

Indeed I forgot the colon. Thank you.

Re: How to write the code to remove loans that have payment Center that ends in 30 or 35

Oligolas — Thu, 17 Jan 2019 07:27:43 GMT

Challenge accepted

where prxmatch("m/^.*(35|30)\s*$/",CENTER)=0;

or even

if prxmatch("m/^.*(35|30)\s*$/",CENTER)=0;

Re: How to write the code to remove loans that have payment Center that ends in 30 or 35

ChrisNZ — Thu, 17 Jan 2019 09:51:09 GMT

prxmatch("/3[50] *$/",CENTER)=0;

Re: How to write the code to remove loans that have payment Center that ends in 30 or 35

QAMARSULTANA — Thu, 17 Jan 2019 15:20:15 GMT

It is numeric,
The code that I wrote was,
proc sql;
create table Sample as

select distinct
b.mktDesc,
a.acctno as Loan_Number ,
a.acctSName ,
a.balToday,
a.commitment,
a.TDR,
d.SICD ,
a.PD,
a.LGD,
a.pastDue,
a.user1 ,
c.offcrname,
a.timeid,
a.costCenter
from everest.loans a
left join everest.loanMaster b
on a.acctno = b.acctno
left join everest.loanOfficer c
on a.offcrCde = c.offcrid
left join WORK.sic d
on a.acctno=d.acctno
where a.timeid = "&CM."
and a.restructFlg = 'Y'

and a.commitment not in (0)
Order by a.commitment desc, a.baltoday desc;

quit;

But now I have too remove loans that have costCenter that ends in 20 or
25.

Help me out with this.

Re: How to write the code to remove loans that have payment Center that ends in 30 or 35

ballardw — Thu, 17 Jan 2019 15:43:37 GMT

When the value is numeric you would want

mod(variable,100) in (30 35)

the MOD function returns the remainder when dividing the variable by the second parameter

Re: How to write the code to remove loans that have payment Center that ends in 30 or 35

Reeza — Thu, 17 Jan 2019 16:15:28 GMT

Use PUT(varNAME, 8. -l) to convert it to a character.

Re: How to write the code to remove loans that have payment Center that ends in 30 or 35

ChrisNZ — Thu, 17 Jan 2019 20:30:12 GMT

The very first reply you got works for both numbers and strings.

Have you tried?

Re: How to write the code to remove loans that have payment Center that ends in 30 or 35

QAMARSULTANA — Fri, 18 Jan 2019 03:15:15 GMT

I get this error message

53 left join WORK.sic d
54 on a.acctno=d.acctno
55 where prxmatch("m/^.*(35|30)\s*$/",costCenter)=0
2 The SAS
System 20:56 Thursday, January 17, 2019
56
57 and a.timeid = "&CM."
58 and a.restructFlg = 'Y'
59
60
61 and a.commitment not in (0)
62 Order by a.commitment desc, a.baltoday desc;
ERROR: Function PRXMATCH requires a character expression as argument 2.
ERROR: Expression using equals (=) has components that are of different
data types.

Re: How to write the code to remove loans that have payment Center that ends in 30 or 35

ChrisNZ — Sat, 19 Jan 2019 05:56:12 GMT

Your variable is numeric. Use the cat function.

Re: How to write the code to remove loans that have payment Center that ends in 30 or 35

Oligolas — Fri, 18 Jan 2019 08:07:40 GMT

if ^prxmatch("/3[50] *$/",CENTER);

considering the new requirements:

^prxmatch("/2[50]$/",catt(CENTER));