Suggestion: Provide a couple of small datasets, or use SAS supplied data sets like SASHELP.CLASS, show the approach you are using to place two of these into your Excel.
Run the code and show us the LOG by copying the entire log for this effort and pasting the text into a text box opened on the forum with the </>.
Can't diagnose an illness without symptoms; can't diagnose code without data and code.
Also, are you trying to place this stuff into an existing Excel file or making a new file?
... View more