I will do that now. Sorry about that. ... View more

Do not worry about the Warnings and errors as they have all been fixed. The only issue is with the excel reporting. When you run the code for Halifax you will have these tables  in my excel library which then sends the data to excel for reporting. Here excel is not producing graphs and cover pages. On the other hand the same code but the parameters are different(BIS) has produced graphs and cover in excel.                                                                                                                      /////////////////(Halifax)////////////////////////////////                                                     1  A     DATA    TABLE                                                         2  A$    DATA    SYSTEM TABLE                                                     3  Bn    DATA    TABLE                                                         4  Bn$   DATA    SYSTEM TABLE                                                     5  IFn   DATA    TABLE                                                         6  IFn$  DATA    SYSTEM TABLE                                                     7  INn   DATA    TABLE                                                         8  INn$  DATA    SYSTEM TABLE                                                     9  TFn   DATA    TABLE                                                        10  TFn$  DATA    SYSTEM TABLE                                                    11  TNn   DATA    TABLE                                                        12  TNn$  DATA    SYSTEM TABLE                                                    13  TSn   DATA    TABLE                                                        14  TSn$  DATA    SYSTEM TABLE                                                    15  Tn    DATA    TABLE                                                        16  Tn$   DATA    SYSTEM TABLE                                                                                 //////////////(BIS)//////////////////////                                         #  Name                          Type    Type                                         1  'Agg Graphs$'                 DATA    TABLE                                             2  'Agg Graphs$'Print_Area       DATA    TABLE                                             3  'DI Graphs$'                  DATA    TABLE                                             4  'DI Graphs$'Print_Area        DATA    TABLE                                             5  'Direct Internet$'            DATA    TABLE                                             6  'Direct Internet$'Print_Area  DATA    TABLE                                             7  'Price Change List$'          DATA    TABLE                                             8  'Tele Graphs$'                DATA    TABLE                                             9  'Tele Graphs$'Print_Area      DATA    TABLE                                            10  A                             DATA    TABLE                                            11  Aggregator$                   DATA    SYSTEM TABLE                                        12  Aggregator$Print_Area         DATA    TABLE                                            13  Changes                       DATA    TABLE                                            14  Contents$                     DATA    SYSTEM TABLE                                        15  Contents$Print_Area           DATA    TABLE                                            16  Cover$                        DATA    SYSTEM TABLE                                        17  Cover$Print_Area              DATA    TABLE                                            18  Flag                          DATA    TABLE                                            19  In                            DATA    TABLE                                            20  TSn                           DATA    TABLE                                            21  Telesales$                    DATA    SYSTEM TABLE                                        22  Telesales$Print_Area          DATA    TABLE                                            23  Tn                            DATA                                                    ... View more

I have replaced macro with the actual variable. the actual code is A = Compress("&brand"||'%');. Any suggestion for resolving the excel issue? I have just attached the reports BIS( Which has cover and graphs) Halifax(Graphs and cover not produced). ... View more

OK. Let's assume that Excel is refreshing data. Any suggestion of what resolves my issue? Note: Please see the attached two different reports for clear understanding. ... View more

Hi Chris. I don't think the graphs are already in the Excel. If you see my question above you will see two tables. Those are the tables present in a library called myexcel. Then a piece of the following code sends them to excel. Libname Myexcel pcfiles path="&output.\New Business Car\Monthly Pricing Pack - &Name..xls" Scan_Text = No; Proc Datasets Library = myexcel; Delete &Channel.n "&Channel.n.$"n; Run; quit ; Data myexcel.&Channel.n ; Set work.export_&Channel ;   Run ; My question is why the macros is not producing other tables like print area as you see it above in my question, with other parameters. I hope my explanation is not too complicated.     Libname Myexcel clear; ... View more

I am very new to this community. Anyway,I will keep that in mind Chris. ... View more

Hello SAS experts, need a bit of help. I am trying to run a macro that generates reports in excel. Having running the same code with two different macro variables. Why only one is producing reports with graphs and cover page and the other is not(just printing the data as it is in excel).Below you can find the difference in the output that is before the code sends them to excel. Please help me out. I have the examples of reports in case if you need it. Note: There see no code in the macros that creates the graphs and cover page.                                          #  Name                          Type    Type                                         1  'Agg Graphs$'                 DATA    TABLE                                              2  'Agg Graphs$'Print_Area       DATA    TABLE                                              3  'DI Graphs$'                  DATA    TABLE                                              4  'DI Graphs$'Print_Area        DATA    TABLE                                              5  'Direct Internet$'            DATA    TABLE                                              6  'Direct Internet$'Print_Area  DATA    TABLE                                              7  'Price Change List$'          DATA    TABLE                                              8  'Tele Graphs$'                DATA    TABLE                                              9  'Tele Graphs$'Print_Area      DATA    TABLE                                             10  A                             DATA    TABLE                                             11  Aggregator$                   DATA    SYSTEM TABLE                                        12  Aggregator$Print_Area         DATA    TABLE                                             13  Changes                       DATA    TABLE                                             14  Contents$                     DATA    SYSTEM TABLE                                        15  Contents$Print_Area           DATA    TABLE                                             16  Cover$                        DATA    SYSTEM TABLE                                        17  Cover$Print_Area              DATA    TABLE                                             18  Flag                          DATA    TABLE                                             19  In                            DATA    TABLE                                             20  TSn                           DATA    TABLE                                             21  Telesales$                    DATA    SYSTEM TABLE                                        22  Telesales$Print_Area          DATA    TABLE                                             23  Tn                            DATA                                                                                                         1  A     DATA    TABLE                                                          2  A$    DATA    SYSTEM TABLE                                                     3  Bn    DATA    TABLE                                                          4  Bn$   DATA    SYSTEM TABLE                                                     5  IFn   DATA    TABLE                                                          6  IFn$  DATA    SYSTEM TABLE                                                     7  INn   DATA    TABLE                                                          8  INn$  DATA    SYSTEM TABLE                                                     9  TFn   DATA    TABLE                                                         10  TFn$  DATA    SYSTEM TABLE                                                    11  TNn   DATA    TABLE                                                         12  TNn$  DATA    SYSTEM TABLE                                                    13  TSn   DATA    TABLE                                                         14  TSn$  DATA    SYSTEM TABLE                                                    15  Tn    DATA    TABLE                                                         16  Tn$   DATA    SYSTEM TABLE ... View more

Thanks guys for your help and apologies for the late reply ... View more