The first step in creating a report in SAS is going to be creating a SAS data set.
Do you have your data in SAS? If so then you can provide a useable example of the data in the form of a data step.
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 {i} icon or attached as text to show exactly what you have and that we can test code against.
Reasons XLS (besides being old formats) are not good:
1) we do not know if some fields should be character or numeric, which becomes very important when combining multiple sources of data, or what the maximum length of a character variable should be
2) frequently spreadsheets will have mixed types of data in a single column which means that lots of work will need to be done to get a useable SAS data set
3) block data formats with columns meaning different things on different rows
4) values that need to be available for each record in a data set for processing occur on only one row or as a column heading
5) data in column headings such as dates or store names
6) characteristics of importance indicated with color, comments or font and border appearance, not the actual values.
7) summary values, and sometimes not even indicated as such, in rows and/or columns
That is just for starters.
... View more