BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
superbug
Quartz | Level 8

I have an ID variable $10.. In this variable, some candidates' ID is 9 numbers, while some other candidates' ID is 7 numbers.  Picture below is an example. How can I separate the candidates into two groups, i.e. one group with 9 number ID, and the other group with 7 number ID. Thanks much for the help!

 

superbug_0-1639109727239.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
japelin
Rhodochrosite | Level 12

For example, the following code will store the length of the id in the group variable, allowing you to group them.

 

data want;
  set have;
  group=length(id);
end;

View solution in original post

2 REPLIES 2
japelin
Rhodochrosite | Level 12

For example, the following code will store the length of the id in the group variable, allowing you to group them.

 

data want;
  set have;
  group=length(id);
end;
superbug
Quartz | Level 8

@japelin 

Thanks much for the help!!

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 718 views
  • 4 likes
  • 2 in conversation