Hello, I am currently having trouble figuring out how to combine multiple variables into one large grouped variables while still maintaining the values of the variables constant. Another issue I have is that I need to conduct a total sum of all the variables grouped by an identifier number but only have scores summed if it more than 5 out of 9 variables have data. For the first question, I want to combine 9 variables called SCNS1, SCNS2, etc.. into one grouped variable so that I can, in the future, compare that grouped variable with another grouped variable. For the second issue, I want to get the sum of SCNS1-9 grouped by identifier number only if 5 of the 9 variables have been filled. A code that I thought would help me for the second issue is: if n(of scns1-scns9)>=5 then sum=sum(of scns1-scns9);
... View more
