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

yes, suppose, a patient had five operation with the types being the one u stated:
1->2->1->3->2

 

Then it should come out as an option 1->2->1->3->2, as Im interested in all changes

PaigeMiller
Diamond | Level 26
data want;
    set have;
    length group $ 256;
    array lead lead:;
    group=cats(lead(1));
    do i=2 to dim(lead);
        if lead(i)^=lead(i-1) then do;
            group=cats(group,'->',lead(i));
        end;
    end;
    drop i;
run;
--
Paige Miller
rookie21
Obsidian | Level 7

This did help. 

Thank you so much ! 

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

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.

SAS Training: Just a Click Away

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

Browse our catalog!

Discussion stats
  • 17 replies
  • 3211 views
  • 0 likes
  • 3 in conversation