Hi, All

I have a dataset with the structure like this:

pid var1 var2 var3 var4 var5 --------------------------------------- 111 aaa bbb 222 ccc ddd 333 444 aaa 555 eee 666

I want to pick up the subjects with any of var1-var5 have value. Like this

pid ---- 111 222 444 555

How can I do this in some simple way, since I actually have 20 var. If I use if... then... that is really a lot work to do. Thanks

Jane