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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.