Hi
I have the below data,
cl_No lineno Servive_code
1 01 120
2 01 D373
2 02 373
2 03 D440
3 01 270
3 02 D20
3 03 D4567
3 04 D567
3 05 F679
The service_code should include a 3 digit service_code and a 4 digit service_code.
The four digit servie_code should begin with the letter "D" and is the last of the
cl_no.
The output should be like this:
cl_No lineno Servive_code
1 01 120
2 02 373
2 03 D440
3 01 270
3 02 D20
3 04 D567
Thanks in advance
Are you looking to keep records:
when the service code is exactly 3 characters they are all digits or any exactly 3 character code?
or
when the service code is exactly 4 characters the first first character is "D"?
I'm not sure what you mean by "and is the last of the cl_no" since your have multiple cl_No values in your output example.
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.