topic Re: CODE HELP in SAS Programming

CODE HELP

Ahsan — Fri, 29 Dec 2017 16:52:25 GMT

Hello,

I need some help to validate oracle code which is implemented in the database. I am validating in SAS.

Here is the business logics which I have to tested

1)Derive True Original TCN on the CLAIM_HEADER_ALL table based on the TCN found on a table for that 'replaced TCN number'.

If the 'replaced TCN number' field is a null or ‘~’ value, then the fetched TCN becomes the True Original TCN.

2) Derive True Original TCN on the CLAIM_HEADER_ALL table based on the TCN found on a table for that 'replaced TCN number'.

If the 'replaced TCN number' field is a null or ‘~’ value, then the fetched TCN becomes the True Original TCN.

3)Derive True Original TCN on the CLAIM_HEADER_ALL table based on the TCN found on a table for that 'replaced TCN number'.

If there is a value in the 'replaced TCN number' field, then fetch the row where the TCN matches that value, up the chain, until the original TCN is found.

4)Derive True Original TCN on the CLAIM_HEADER_ALL table based on the TCN found on a table for that 'replaced TCN number'.

If the original TCN is not found, the default value of <NULL> will be assigned.

I appreciate all the help.

Thank You

Re: CODE HELP

Kurt_Bremser — Fri, 29 Dec 2017 17:24:09 GMT

You should post the SAS code you need help with. Use the "little running man" icon for posting code.

Re: CODE HELP

LinusH — Fri, 29 Dec 2017 22:45:12 GMT

So you want to mimic the logic from an Oracle application and compare the results?
Well there is no real silver bullet, you probably need to code this in SAS. Can you be more specific on what you need help with?

Re: CODE HELP

Ahsan — Fri, 29 Dec 2017 23:04:30 GMT

Yes i would like to compare the results. I need to code this in SAS. I need help to right a code to verify the business logic.

Thank You

Re: CODE HELP

Patrick — Sat, 30 Dec 2017 03:07:02 GMT

@Ahsan

If you want to verify if the business logic has been correctly implemented in Oracle, wouldn't you rather run the logic either against factored test cases or then analyse the data - source and result - and verify that the cases where data gets changed/not changed comply with the business logic? And of course: You can use SAS for this sort of analysis.

Re: CODE HELP

Ahsan — Fri, 29 Dec 2017 23:51:34 GMT

Thank you I did verify the business logic which was implemented in oracle.

Thank You

Re: CODE HELP

ChrisNZ — Sat, 30 Dec 2017 05:27:50 GMT

Please be a lot more specific in your title next time.

Any question here could have the same title, and that would be a huge pain.

Useful titles also trigger faster, better help.