Thank you all ! That additional statement works! ... View more

That certainly works. Thank you very much for your help. ... View more

WOW...Thanks a lot, Arthur. That was really helpful. I just have another quick question. How can I combine TestD and TestE and make a column name "Test_Var" and then I need to do the same thing with the data variables as: ID $ TestA TestB TestC Test_Var Thank you very much. ... View more

Thanks Arthur for your patience. Yes, it can be assigned to more than one test. for eg: for one of the IDs it can be: MJ376 0 1 1  0 1 Also, in some cases all the values can be zero. ... View more

I apologize for being not clear. This is the dataset: ID $ TestA TestB TestC TestD TestE AB348 0 0 0 0 1 SB876 0 1 0 0 0 VB912 0 0 1 0 0 SK623 1 0 0 0 0 and so on-------- I want a new variable "Test" on which I should be able to perform the PROC FREQ: and the output should look like Test          Frequency   Percent Cumulative_Frequency Cumulative Percent ----------------------------------------------------------------------------------------------------- TestA TestB TestC TestD TestE Hopefully, I am clear now. Thanks for helping me out. ... View more

Thanks for your reply. This is what I am looking for: AB348 0 0 0 0 1 0 SB876 0 1 0 0 0 0 VB912 0 0 1 0 0 So, I want to name a new variable which consists of the last five variable in the above data set. Then, I want to do the PROC FREQ on the new variable so that I can get the individual freq of each of the five variables. I hope I am clear this time. Thanks. ... View more