Assuming you're able to read the Excel data into SAS tables here how to combine the data (the bit for the 4th table for you to add). data tbl1; input Student_no $ Mark; datalines; d5476 87 d7389 46 d1276 58 ; data tbl2; input Student_no $ Mark; datalines; d5476 67 d7389 52 d1276 96 ; data tbl3; input Student_no $ Mark; datalines; d5476 67 d9999 99 d1276 96 ; proc sort data=tbl1; by student_no; run; proc sort data=tbl2; by student_no; run; proc sort data=tbl3; by student_no; run; data want; merge tbl1(rename=(mark=mark1)) tbl2(rename=(mark=mark2)) tbl3(rename=(mark=mark3)) ; by student_no; run; proc print data=want; run; ... View more

@Mil00 wrote: I am trying to calculate total percent of each student horizontally (green arrow) using proc freq procedure, but the result I am getting is calculated vertically (orange arrow). Any help will be appreciated. If you need the Percent of values that are 1 on each row then the MEAN function is what you want: You don't show valid SAS variable names for the week variables but data want; set have; percent = mean(of week:); run; or explicitly list the variables of interest. The mean will be between 0 and 1, so 0.5 = 50%. If you want to display percentage values then use a format like Percent8.2 , or do the multiply by 100 to shift the decimal.   Counting would be something different   n (of week: ) would give the number of variables that have a value. But you did not describe what you might actually be counting.     ... View more