topic QC Syntax question, mulitples of ten in SAS Programming

QC Syntax question, mulitples of ten

Steelers_In_DC — Thu, 25 Aug 2016 14:56:59 GMT

I am trying to find multiples of ten between two variables. The way the edit is written is:

CommittedBalance should not be multiple of 10 from prior quarter. For example, the prior quarter was 10 and the current quarter was 100. 100 / 10 = 10.

I'm not sure how to check this. Is there a way to manipulate the mod(current,prior) function for this?

Cheers,

Mark

Re: QC Syntax question, mulitples of ten

Haikuo — Thu, 25 Aug 2016 15:12:04 GMT

Not sure I have fully understand your questions, is it like this?

if mod(current/prior,10)=0;

Re: QC Syntax question, mulitples of ten

ballardw — Thu, 25 Aug 2016 15:13:05 GMT

The mod function with a result of 0 only would tell you that the value was A multiple of the prior, could be any .

If you have the values easily to compare then

if current = 10* prior then <what ever>;

would work.

Re: QC Syntax question, mulitples of ten

PGStats — Thu, 25 Aug 2016 15:21:06 GMT

I guess something like:

flag = CommittedBalance ne lag(CommittedBalance) and
	(mod(CommittedBalance / lag(CommittedBalance), 10) = 0 or 
	 mod(lag(CommittedBalance) / CommittedBalance, 10) = 0);