Hello RW9,   Actually, this is a sample data , the original version of the data is 4000 columns. What are the part you think ate extra or missing? I am putting the code below again and i will be writing what i do and what i need to do . The question has got a bit long in the forum 😞 Iwill put below the images that i want to be created.     /*in these three steps, the values in the Want table overwrite the values the Main_sql table.*/ proc sql noprint; select Variable into : list separated by ' ' from Change; quit; %put &list; %macro soru(var); proc sql; update Main set &var=(select Want from Change where Variable="&var") where &var=(select Current from Change where Variable="&var"); quit; %mend; %macro loop; %let i=1; %do %while(%scan(&list.,&i.,%STR( ))~=); %soru(%scan(&list.,&i.,%STR( ))); %let i=&i.+1; %end; %mend; %loop;       /* I do the scoring from here to main3 but i have done this process for only Question2 Column. I also would like to see the Question2 column next to the score rows. In the end, i want all these scores to be seen as Score1 in main. The actual problem is uniting the values in the Question1 in the main_sql table and Main the Question1 after want table overwritin the main table in the same table. */   PROC SORT DATA=Main; BY Question2; RUN; proc sql; create table Main2 as SELECT NT.*, SUM(NT.ObservationNumber) AS TotalObservationNumber, (NT.ObservationNumber/Calculated TotalObservationNumber) AS NumericRate, (NT.DefaultNumber/NT.ObservationNumber) as DefaultRate from ( select Question2 as Category, COUNT(Question2) AS ObservationNumber, Sum(Default) AS DefaultNumber from Main group by Question2) AS NT; quit; proc sql; Create table Main3 as Select *, sqrt((2500/sum((N.YDSum**2)*N.NumericRate))) AS F, (N.DefaultRate-N.Y) * Calculated F AS Score FROM(SELECT NumericRate, DefaultRate, (NumericRate*DefaultRate) AS YRow, SUM(NumericRate*DefaultRate) AS Y, (SUM(NumericRate*DefaultRate)-DefaultRate) AS YDSum from Main2) as N; QUIT;   This is the order of the scores. I would like the final image of the table like this. (Score Columns result is not correct)   ... View more

I would be happy if someone could help in this case.   Thank you. ... View more