I have 4 excel files to merge into one output (proc print will be enough). Each file has a table with two variables: 'Student_no' and 'Mark'. Student_no always stays the same, but marks for each file is different, e.g. File 1: Student_no Mark1 d5476 87 d7389 46 d1276 58 File2: Student_no Mark2 d5476 67 d7389 52 d1276 96 etc. I need to create one table as an output which should look like this: Student_no Mark1 Mark2 Mark3 Mark4 d5476 67 67 74 45 d7389 52 56 89 57 d1276 96 67 57 93 Thank you in advance.
... View more