Here is an example of using the TITLE Statement in Proc DATASETS, changing the title with each iteration within the single proc.  The RUN; Statement following each title insures that the execution is tied to the statement before it, not after it, thus removing some ambiguity. proc datasets library=sashelp nolist ;   contents data=burrows short ;     title burrows ;   run ;   contents data=cars short ;     title cars ;   run ; quit ; ... View more

About your observation that "The TITLE statement does not need a run; correct ?"   While that is correct, there may be problems with step boundaries (to which the previous reply alluded).    It is best to always use a RUN; statement following a TITLE statement to insure that the TITLE statement actually executes where you think it will execute.  This is especially important when -- as you do here -- you are using "TITLE ; " to clear all previous titles.   While this may not be the exact issue you have here (i.e., step boundary control), it is a good habit to have.   Steve ... View more

Whoops!  Thanks for the catch.  My assumption above was quite wrong viz-a-viz M3 and M5. ... View more

That leaves me at a loss.    For some reason, you seem to be getting a "sheet_interval='now' " after the third Proc Report (keeping the same sheet name, so Excel is giving you the suffix "2" to the name).  There is nothing in the code that I see could cause that.   It really -- REALLY -- should not be because Excel is seeing the sheet as filled (max number of rows is over a million; columns go out to something like xva, over 16,000).  That is why I believe you are actually getting the command through SAS.   Just so you can see what is happening here, I am attaching the Program -- 99+% yours -- and Excel output.   Steve ... View more

Hi Marta 27,    The versions of SAS are essentially identical, yet we get different results (mine being the ones you want), so something else is different besides the capabilities of the SAS Software (assuming no major changes between M3 and M5).   First, be sure that the example you posted is the exactly the same as what you ran (I made no changes except to change the libref for the input datasets).  My datasets are probably much different from yours, but given the output that should be no issue.   Second, I cannot imagine anything in MS-Excel that would fail here, but what are the names of your worksheets?  You want one worksheet named "tables1_2" and a second one named "tables3_4" and you are getting a third one, too.   Steve ... View more

Hi Marta27,    If I understand you correctly, you want Proc Report output for datasets 1 and 2 on the first worksheet and for datasets 3 and 4 on the second worksheet?  That is exactly what I just got when I roughed-out four data files as input and ran your program, colors, font, everything.   I am running 9.4, TS1 M5   Steve ... View more

One way, I'm sure not the only way, is  use ODS and set the output destination to html and from there you can read the file into MS-Word, MS-Excel, and a lot of other things.  It's two steps, but I do not seem to recall ever seeing .docx as an ODS destination. ... View more

try setting the macro variable (first three lines of your program) as follows:   %let <macro_variable_name> = <macro_variable_argument> ;   The datastep data _null_ is ok but irrelevant (%let can be used in open code).   The %str() function seems to be the problem: I ran it without that and the code worked. ... View more