About bk8

bk8 · ‎09-03-2020

Thank you so much @Astounding. This logic works well and able to tweek my code and got the result.

bk8 · ‎08-28-2020

Yes, the first dataset always has 4 rows and second dataset has 1 row. For the above example, I need new dataset to be created, say 'final' and the output should look like a_out b_out c_out 11 11 11 And the message should be like, 'c_out is matching with a_out and b_out'. If the results are different then we can give error message as for e.g., 'c_out is matching with b_out but is off by $3 with a_out' (its just sample). Please let me know if it is not clear yet. Thank you in advance.

bk8 · ‎08-28-2020

Hi experts, I have two datasets say, first and second. They can generate any values every month. The values of same column needs to be add and substract in first dataset (as shown in Result below). The result (a_out and b_out) needs to be compared with value from second dataset (c_out). Compare c_out with a_out Also compare c_out with b_out Display 'matching' or 'not matching'. The validation needs to be sent to the users. data first; input a b; datalines; 22 25 44 0 33 14 22 0 ; run; Result: a_out = (22 + 44) - (33 + 22) b_out = ( 25 + 0) - (14 + 0) I have c_out from other table. data second; input c_out; datalines; 11 ; run; The same calculation needed for several LOBs and I want to write macro for the same. Please reply with the above solution at least. Thank you in advance.

Online Status	Offline
Date Last Visited	‎09-03-2020 08:17 AM

Re: Add and substract row values in same column

Re: Add and substract row values in same column

Add and substract row values in same column

Re: Add and substract row values in same column

Re: Add and substract row values in same column

Re: Add and substract row values in same column

Add and substract row values in same column