SAS should be able to read in the Excel file using PROC IMPORT or XLSX libname engine.
Since it looks like you just have numeric variables your code to transform it could be as simple as:
proc transpose data=HAVE out=WANT;
by date;
run;
since by default it will transpose all of the numeric variables.
You will then get a dataset with DATE, _NAME_ and COL1. You might also have _LABEL_ if the any of the variables had a label attached.
... View more
