@ballardwThank you for your reply. I think you are right. My data set looks something like this. Where i have 32 character variables, who have values A,Z,E,D and so on. They are joined using the ID no. of each individual. The values do consist of a single character The code that you provided above gives me the number of Sequence Id who have A or Z. How do I put in the code for the number who dont have it. I used this- data caries; set nh.ohxden_i; if index( cats(OHX31CTC,OHX30CTC,OHX29CTC,OHX28CTC,OHX27CTC,OHX26CTC,OHX25CTC,OHX24CTC,OHX23CTC ,OHX22CTC,OHX21CTC,OHX20CTC,OHX19CTC,OHX18CTC,OHX15CTC,OHX14CTC,OHX13CTC,OHX12CTC ,OHX11CTC,OHX10CTC,OHX09CTC,OHX08CTC,OHX07CTC,OHX06CTC,OHX05CTC,OHX04CTC,OHX03CTC,OHX02CTC),'F')>0 then caries =1; if index( cats(OHX31CTC,OHX30CTC,OHX29CTC,OHX28CTC,OHX27CTC,OHX26CTC,OHX25CTC,OHX24CTC,OHX23CTC ,OHX22CTC,OHX21CTC,OHX20CTC,OHX19CTC,OHX18CTC,OHX15CTC,OHX14CTC,OHX13CTC,OHX12CTC ,OHX11CTC,OHX10CTC,OHX09CTC,OHX08CTC,OHX07CTC,OHX06CTC,OHX05CTC,OHX04CTC,OHX03CTC,OHX02CTC),'Z')>0 then caries =1; if index( cats(OHX31CTC,OHX30CTC,OHX29CTC,OHX28CTC,OHX27CTC,OHX26CTC,OHX25CTC,OHX24CTC,OHX23CTC ,OHX22CTC,OHX21CTC,OHX20CTC,OHX19CTC,OHX18CTC,OHX15CTC,OHX14CTC,OHX13CTC,OHX12CTC ,OHX11CTC,OHX10CTC,OHX09CTC,OHX08CTC,OHX07CTC,OHX06CTC,OHX05CTC,OHX04CTC,OHX03CTC,OHX02CTC),'A')>0 then caries =1; RUN; Can I just put else caries = 0 at the end of the code, to obtain the no. of individuals who do not have Z,F or A as their value
... View more