BookmarkSubscribeRSS Feed
raveena
Obsidian | Level 7

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

1 REPLY 1
ballardw
Super User

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.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

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
  • 1 reply
  • 376 views
  • 0 likes
  • 2 in conversation