Creating a new array variable in a SAS data set

Question

I am attempting to create a variable that will store a list of strings related to other variables in a SAS data set. Here is a sample of the data set:

Patient  Therapy1  Therapy2 Therapy3 Therapy4
1001       X           X       X        X
1002       X                   X            
1003                   X                X

Basically I want to append a variable at the end of the list called "Summary" that will contain a string of the therapies for each patient. So Patient 1001 should say "Therapy1, Therapy2, Therapy3, Therapy4", Patient 1002 should say "Therapy1, Therapy3", and Patient 1003 should say "Therapy2, Therapy4".

The code for this data is stored in a table called tmp.

Edit: I'm going to write this out in R and then see if someone can do something similar in SAS.

for(i in 1:nrows(data)){
  if(data$Therapy1[i] == "X"){
    data$Summary[i] = data$Summary[i] + ", " + "Therapy1"
    }
    ....
   if(data$Therapy4[i] == "X"){
    data$Summary[i] = data$Summary[i] + " " + "Therapy4"
    }

What is your question? Do you have any existing code and directed questions about that code that we can help you with? — Jonathan Lam
– Jonathan Lam, Commented Aug 31, 2018 at 20:38
This almost exact question was asked on SAS Communities a few minutes ago. communities.sas.com/t5/SAS-Programming/… There's a working solution there as well. — Reeza
– Reeza, Commented Aug 31, 2018 at 20:58

Kiran · Accepted Answer · 2018-08-31 22:48:29Z

1

one way to do this is using array and vname as shown below

data want;
set have;
length summary $100.;
array new(*) therapy:;
do i = 1 to dim(new);
if new(i) ne ' '
then summary=catx(',',summary,vname(new(i)));
end;
drop i;
run;

answered Aug 31, 2018 at 22:48

Kiran

3,3153 gold badges16 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Creating a new array variable in a SAS data set

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related