Data Validation Doubt

Reply
Frequent Contributor
Posts: 101

Data Validation Doubt

I have one source table(SRC_EMP).For Eg.

Emp_id      MICR_No
123             456854778

456             785594145

786             41256257

345             45875

785             748487544

I have one Validation.MICR should be 9 digits.

I want the error records in one table and all the records in another table.(i.e)

ERR_EMP                                                                       TRGT_EMP

Emp_id    MICR_No                                                    Emp_id    MICR_No                                                       

786             41256257                                                123             456854778

345             45875                                                      456             785594145

                                                                                 786             41256257

                                                                                 345             45875

                                                                                 785             748487544

I have used data validation transformation and but i cant able to achieve my results.

I am getting the o/p as

ERR_EMP                                                                       TRGT_EMP

Emp_id    MICR_No                                                    Emp_id    MICR_No                                                        

786             41256257                                                123             456854778

345             45875                                                      456             785594145

                                                                                 785             748487544

How to achieve my result?

Kindly help me on this.

Regular Contributor
Posts: 151

Re: Data Validation Doubt

Posted in reply to Helannivas

I'm assuming you're using DI Studio, in which case you should tag the question as such in order to avoid irrelevant answers

Super Contributor
Posts: 282

Re: Data Validation Doubt

Posted in reply to Helannivas

Hi,

How about the following untested code:

data err_emp trgt_emp;

  set src_emp;

  output trgt_emp;

  if length(strip(micr_no)) ne 9 then

    output err_emp;

run;

Regards,

Amir.

Ask a Question
Discussion stats
  • 2 replies
  • 156 views
  • 0 likes
  • 3 in conversation