Please be explicit about which part(s) "is not looking how the report looks".
Without actual data it will be next to impossible to say what may be needed to generate your report. If you provide some data please make in in the form of a data step which reads datalines. If we have to "import" an excel file the results may be different.
Also anything appearing in the body of a report is likely to need a variable of some sort. So the parenthetical elements such as (a1) may be difficult to incorporate.
Also does the final result have to be in Excel? There can be major headaches getting some strickly appearance options such as the dot leaders ( ......... ) to appear as desired.
And a not about repeated processes:
First: Import data using the import wizard
1. Save file to be imported as a CSV(MS-DOS) file.
2. In SAS, click on File, Import Data...
3. From the drop down menu, click on Comma Separated Values (*.csv).
4. Choose the file destination and click next.
5. Choose library and name the new sas file and click next.
6. Click finish.
7. Proc print data= XX.XXX (obs=5) *This will confirm you successfully uploaded the file**;
If you are going to do this with multiple files, either different data sources or over time, with the same layout do 1 through 5 one time.
The log will have data step code that you can extract and save as a program file and then you only have to change the source file, output set and possible the library. You control informats and especially length of character variables and whether a variable is numeric or character as well as setting variable labels formats, add some data checking for ranges or such and possibly calculating additional needed variables. If you keep using proc import I am willing to make a small wager that eventually something doesn't come in as expected because one of your data sources provides unexpected values an a variable that was defaulting to numeric suddenly becomes character. Which may mean a failure later on.
Whether you could hope to make such tables in a single pass through Proc tabulate depends on your data and many definitions. I've had multiple go-arounds with CDC over what the appropriate numerator and denominators may be for percentages. Often they lead to serious preprocessing before getting to actually preparing the tables.
