thanks for your reply. This is the result when I run the code. Because we do a sort(In the code you wrote: call sortc(of col{*}); ) in the code.   I solved my problem with your help.   I made some changes in the code you wrote 1. I changed the sort function because the data is numeric;   call sortc(of col{*}) --> call sortn(of col{*}) 2. I changed the control function because the data are numeric; curr_val="--" --> curr_val=1      When I changed this part, the condition(if curr_val ne col{i} then do;)  started to work correctly   Thank you very much for your interest. ... View more

hi @RW9  Thank you again for your help. Your code was very useful.But when the numbers in the cells changed, I started to have problems. When the number of digits of the numbers is growing and all of them are numerical, it does not give the right result.   for example;   data have; input ID Col1-Col4; datalines; 1 1234567890 1234567890 14 14 2 32 33 33 12345678978 3 45 67 . 45 4 1234567898 13 1234567898 13 5 . . . 44 ; run;   The output is visible below. Values are repeating.   If you can help me very much. ... View more

Hi, @ballardw and  @RW9 ;   I could not find any solution to my problem.I found a code that was written in this forum before.But it only calculates one the maximum value.It does not calculate the frequencies of the others. Does not calculate if there is more than one maximum. I copy down to give you an idea.   data have; input id 1 x1 $ 4-5 x2 $ 7-8 x3 $ 10-11 x4 $ 13-14 x5 $ 16-17; cards; 1 07 04 07 07 07 2 04 05 04 04 05 3 02 02 03 4 01 01 02 02 5 01 ; run; data want; set have; length MostFreq $2; array x x:; array _t[10] _temporary_; call missing(of _t[*]); do _n_=1 to dim(x); if x[_n_] ne ' ' then _t[input(x[_n_],2.)]+1; end; Count=max(of _t[*]); MostFreq=put(whichn(Count, of _t[*]),z2.); run;   How can I get the output of my example as below.. I ask for your help   data have; informat id v1-v12 $8.; input id v1-v12; /* Add a row identifier */ id=_n_; cards; 1 1 1 1 3 a b . 4 x . 2 2 2 4 5 h k L L A a 4 6 7 c 3 3 4 5 6 7 3 6 8 8 a w d 4 6 7 2 1 1 2 3 4 5 6 7 s ; run;   id v1 v2 v3 v4 v5 v6 v7 v8 v9 v10 v11 v12 concat_compare same_variables Distinct_Values Cnt_of_Distinct_Values dist_1 cnt_of_1 dist_2 cnt_of_2 dist_3 cnt_of_3 dist_4 cnt_of_4 dist_5 cnt_of_5 … 1 1 1 1 3 a b   4     2 2 0;0;1;1;1;1;1;1;0;1;0 v1_v2;v2_v3;v9_v10;v11_v12 1;3;a;b;4;2;missing 7 1 3 2 2 missing 2 3;a;b;4 1     … 2 4 5 h k L L A a 4 6 7 c 1;1;1;1;0;1;1;1;1;1;1 v5_v6 4;5;h;k;L;A;a;6;7;c 10 4 2 L 2 5;h;k;A;a;6;7;c 1         … 3 3 4 5 6 7 3 6 8 8 a w d 1;1;1;1;1;1;1;0;1;1;1 v8_v9 3;4;5;6;7;8;a;w;d 9 3 2 6 2 8 2 4;5;7;a;w;d 1     … 4 6 7 2 1 1 2 3 4 5 6 7 s 1;1;1;0;1;1;1;1;1;1;1 v4_v5 6;7;2;1;3;4;5;s 8 1 2 2 2 6 2 7 2 3;4;5;s 1 … best regards ... View more

Do we have a chance to find repeat records and repeat times? like as best regards.. ... View more

thanks for your reply.   Result when I run the code you wrote for unique_values   But the necessary values are as follows   best regards.   ... View more

Hi, I'm copying it down.I also add it as excel.   id v1 v2 v3 v4 v5 v6 v7 v8 v9 v10 v11 v12 concat_compare same_variables Distinct_Values Cnt_of_Distinct_Values dist_1 cnt_of_1 dist_2 cnt_of_2 dist_3 cnt_of_3 dist_4 cnt_of_4 dist_5 cnt_of_5 … 1 1 1 1 3 a b   4     2 2 0;0;1;1;1;1;1;1;0;1;0 v1_v2;v2_v3;v9_v10;v11_v12 1;3;a;b;4;2;missing 6 1 3 2 2 missing 2 3;a;b;4 1     … 2 4 5 h k L L A a 4 6 7 c 1;1;1;1;0;1;1;1;1;1;1 v5_v6 4;5;h;k;L;A;a;6;7;c 10 4 2 L 2 5;h;k;A;a;6;7;c 1         … 3 3 4 5 6 7 3 6 8 8 a w d 1;1;1;1;1;1;1;0;1;1;1 v8_v9 3;4;5;6;7;8;a;w;d 9 3 2 6 2 8 2 4;5;7;a;w;d 1     … 4 6 7 2 1 1 2 3 4 5 6 7 s 1;1;1;0;1;1;1;1;1;1;1 v4_v5 6;7;2;1;3;4;5;s 8 1 2 2 2 6 2 7 2 3;4;5;s 1 … ... View more

Hi RW9; I made the mistake of including id in my first post.   thanks for your reply.I will try to explain the other four variables.    mean of  same_values :It is a list of multiple recurring values when we accept each record as an array. so for id=1 , The same_values will be "1;2; . " same_values="1;2; . " (missing is include)   mean of not_same_values:A list of values that do not repeat more than once when we accept each record as an array. so for id=1 , The not_same_values will be "3;a;b;4;x"    not_same_values="3;a;b;4;x"   same_count:The number of times that multiple repeating values are repeated. It is the sum of the number of repeats for example ; for id = 1 , Repeated 1 to 3 times,Repeated missing value(.) to 2 times  Repeated 2 to 2 times and Their sum is 7 (3+2+2) same_count=7   not_same_count:The number of variables that do not repeat more than once for id = 1,  Repeated 3 to 1 times,                  Repeated a to 1 times,                  Repeated b to 1 times,                 Repeated 4 to 1 times,                 Repeated x to 1 times  and Their sum is 5 (1+1+1+1+1)  not_same_count=5   I hope,It is more descriptive. Best regards ... View more

Yes, Yes, I made a mistake.Just like you wrote it.   0;0;1;1;1;1;1;1;1;1;0 thanks ... View more