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
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.
You should post the SAS code you need help with. Use the "little running man" icon for posting code.
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.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.