Data Validation Doubt

Reply
Frequent Contributor
Posts: 90

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

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

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
  • 155 views
  • 0 likes
  • 3 in conversation