Okay How about proc freq nlevels   data ds1; input kon $ age ss; cards; M 20 1 K 22 2 M 24 2 M . . K . . . . . ; run; ods output nlevels=want; proc freq data=ds1 nlevels; tables age ss / noprint; run; ... View more

@Biniie wrote: I need to generate a new variabel that horizontally count the number of variabels out of a total of 9 variabels that contains a none missing value. I've figured out to do so with a missing value, but how can I change the code, so instead of '.' it will be any value "not equal" to a missing value?    data have; set want; countvar = countc(catt(of var1 - var9), '.'); run;   (I still haven't worked with arrays, so I would appreciate a very simple code, ex based on the code above)   Thanks... Use the CMISS() function.  It can handle both numeric and character variables. number_missing=cmiss(of var1-var9); number_not_missing=9 - number_missing; ... View more

@Biniie wrote: Thank you very much for your respons. I tried it out, and it would have worked perfectly, but there is a twist.    5 out of the 70 variabels is actually numeric variabels. I can't explain why some of my variables is numeric and why some are defined as character variables. So when I try the procedure you surgested, I get the error "All variables in array list must be the same type, i.e., all numeric or character" which makes perfectly sense.    Any surgestion how to deal with this? If the variables are expected to be character but are numeric I would guess that someone is using Proc Import to bring data into SAS and not understanding the "guessing based on values" nature of Proc Import, and by default only a few rows of data are examined to guess the variable type, informat and length. OR a program reading data has the wrong read instructions. It may be that if you want numeric values you should go back to the steps where the data is read and address the issue earlier in the process. ... View more