Thanks ballardw your answer was correct but is there any other way to do it without transposing it because in actual problem i have 25 variables and 1 lakh observations so when i will transpose it. then i will have 25 Lakh observation so will you suggest me to do the same way for my problem. ... View more

Thanks stat@sas your answer was correct but is there any other way to do it without transposing it because in actual problem i have 25 variables and 1 lakh observations so when i will transpose it. then i will have 25 Lakh observation so will you suggest me to do the same way for my problem. ... View more

Yes ebills , I want my output to show all the numbers which are in every column. ... View more

I want ALL the values which are present in ALL the variables. I do want how many matches are there. For Example: var1 var2 var3 var4 var5 23    87    94      59   54 36    23    19      23   57 87    63     87    51    99       35    38     87    87     23 68    49     23    78     87 like in this example 23 and 87 are present in all the variable so i want output as 23 87. I think it's clear now if not you can ask me again and thanks for the reply ballardw. ... View more