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

Good afternoon:

I am trying to concatenate characters from different rows as per example below:

Starting table:

Patient_ID         Diagnoses

123456             463.0

123456             472.9

123456             V10.0                       

Finishing table:

Patient ID          Concatenation_Of_Diagnoses

123456              463.0; 472.9; V10.0

I have been splitting tables and using CATX, but if there are a lot of different diagnoses, writing the CATX function can take a long time and it doesn't seem to be an efficient process. Is there a better way to do that or a function in EG that allows to do that?

Many thanks,
Chantal

1 ACCEPTED SOLUTION

Accepted Solutions
RichardinOz
Quartz | Level 8

CATX is the right function to use but you do not need to split the tables.

Try this in a code segment (might need tweaking because I can't test it).

Data needs to be pre-sorted by Patient_Id.

Data Combined_Diagnoses  (Drop = Diagnoses) ;

    Set Individual_Diagnoses ;

    By  Patient_Id ;

    *   Length needs to be 8x max number of diagnoses ;

    *   Or even longer in case of unexpected number ;

    Length Concatenation_Of_Diagnoses $ 200 ;

    Retain Concatenation_Of_Diagnoses ;

    *   Set initial value per patient to blank ;

    If  First.Patient_Id

      Then Concatenation_Of_Diagnoses = ' ' ;

  Concatenation_Of_Diagnoses = CATX ('; ',

                               Concatenation_Of_Diagnoses, Diagnoses) ;

    If  Last.Patient_Id

      Then Output ;

Run ;

View solution in original post

2 REPLIES 2
RichardinOz
Quartz | Level 8

CATX is the right function to use but you do not need to split the tables.

Try this in a code segment (might need tweaking because I can't test it).

Data needs to be pre-sorted by Patient_Id.

Data Combined_Diagnoses  (Drop = Diagnoses) ;

    Set Individual_Diagnoses ;

    By  Patient_Id ;

    *   Length needs to be 8x max number of diagnoses ;

    *   Or even longer in case of unexpected number ;

    Length Concatenation_Of_Diagnoses $ 200 ;

    Retain Concatenation_Of_Diagnoses ;

    *   Set initial value per patient to blank ;

    If  First.Patient_Id

      Then Concatenation_Of_Diagnoses = ' ' ;

  Concatenation_Of_Diagnoses = CATX ('; ',

                               Concatenation_Of_Diagnoses, Diagnoses) ;

    If  Last.Patient_Id

      Then Output ;

Run ;

choly1
Calcite | Level 5

Thank you so much, it worked!

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

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
  • 2 replies
  • 4674 views
  • 0 likes
  • 2 in conversation