Data Validation Doubt

[Helannivas]

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.

[Keith]

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

[Amir]

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.