Yes, you are missing any actual data.
Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the </> icon or attached as text to show exactly what you have and that we can test code against.
Probably the example data should include about 15 of the "date" columns.
First your shown transpose is throwing away every variable that does not start with _. So if you actually have any of those in FinalOutput there is more code you haven't shared. Second, does XLTrans have Any Col2, Col3 (or higher numbered).
I suggest, if you haven't already, printing the first 3 rows of the XLFile data set. You may be surprised to find a lot of missing values. This could happen from people entering 2.3% as strings instead of 0.023 and assigning a percent display in Excel. The other thing to check with your 0 values is what Format is currently assigned. If the format is something like f3.0 then values less than 0.05 (less than 5%) will display as 0.
Run this code a look in the log for the result as one example.
data _null_;
x=0.023;
put 'F3.0 format: ' x= f3.0 'with Percent8.1 format: ' x= percent8.1;
run;
... View more
