DATA Step, Macro, Functions and more

CODE HELP

Accepted Solution Solved
Reply
Contributor
Posts: 60
Accepted Solution

CODE HELP

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


Accepted Solutions
Solution
‎12-29-2017 06:51 PM
Respected Advisor
Posts: 4,562

Re: CODE HELP

[ Edited ]

@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.

View solution in original post


All Replies
Super User
Posts: 9,611

Re: CODE HELP

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Super User
Posts: 5,829

Re: CODE HELP

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?
Data never sleeps
Contributor
Posts: 60

Re: CODE HELP

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
Solution
‎12-29-2017 06:51 PM
Respected Advisor
Posts: 4,562

Re: CODE HELP

[ Edited ]

@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.

Contributor
Posts: 60

Re: CODE HELP

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

Thank You
PROC Star
Posts: 2,231

Re: CODE HELP

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.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 251 views
  • 0 likes
  • 5 in conversation