BookmarkSubscribeRSS Feed
Helannivas
Quartz | Level 8

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.

2 REPLIES 2
Keith
Obsidian | Level 7

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
PROC Star

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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 389 views
  • 0 likes
  • 3 in conversation