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.
I'm assuming you're using DI Studio, in which case you should tag the question as such in order to avoid irrelevant answers
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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: