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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.