Time to show 1) some data and 2) the result for that data.   @sasiscool wrote: So i can't just create a dataset with the most recent year descending, save it as a format with cntlin. And apply that to the proc report?   i have to create a dataset with each year? and don't create a format?   thank you for responding   It sounds like you are attempting to have a different sort order for a second variable for every year. If that is the case then you likely can't use Year as an across variable. If you absolutely must have a different order for every year than you really need to show what you expect that result to look like as you obviously cannot have a single row label involved.   For your first question about maintaining order you might try using the PRELOADFMT option in define block for the variable involved, which will require the use of the Order=data or Exclusive option. The format may require building with the NOTSORTED option. You also should show your proc report code as you may have been setting some option(s) that affect order of appearance that you haven't mentioned in this thread yet. ... View more

The reason concerns how an %IF condition interprets a dash.  Remember, %EVAL is applied to all %IF conditions.  Thus if a dash is present, it triggers the attempt to subtract.   Consider a simple case:   %let club = 4-H; %if &club = 4-H %then %do;   Assuming these statements are contained within a macro definition (so %IF is legal), the first statement always works.  And the second statement always generates an error.  The dash triggers %EVAL to perform subtraction.  However, this comparison would work:   %if "&club" = "4-H" %then %do;   By adding the double quotes, %EVAL now figures out it should perform a character comparison and not attempt to subtract.   This post was in response to  your post #3.  Regarding your post #4, try inserting some diagnostics.  After assigning a value to &error, display the value with a %PUT statement.  Better yet, turn on debugging options such as MLOGIC and SYMBOLGEN. ... View more

Hi,   I do not observe the same behavior as you report. When I have wide text, my row heights adjust automatically based on the width of the cell, without needing to use any tagattr for wrapping. See the examples below -- the code is very simple.   cynthia   and, for no wrapping at all, just adjust the widths... (using ODS EXCEL as the wrapper code):   ... View more

Here is one example. Note that where I have %put you would put your report code. %macro dummy(parm); %if &parm = a %then %do; %put Parm= &parm; %end; %else %if &parm=b %then %do; %put Parm= &parm; %end; %else %if &parm=c %then %do; %put Parm= &parm; %end; %else %if &parm=d %then %do; %put Parm= &parm; %end; %put Done; %mend; %dummy(a); %dummy(b); %dummy(c); %dummy(d);   Also recommend against using "a" with macros unless there is an extremely good reason. ... View more

Realizing that your actual report may be more complex a limited example of this is possible with a multilabel format and Proc tabulate. I suspect that this does not match your existing data layout as it sounds like you have done some summary to create your "group 1" ahead of time and appended data.   The following approach might be able to avoid that presumed summary step. proc format library=work; value grp (multilabel notsorted) 1,2 = "Group 1" 1 = "Group 2" 2 = "Group 3" ; run; data example; do year= 2012,2013; do i = 1 to (ceil(20*Ranuni(123))); group = rand('table',1/3,2/3); output; end; end; run; proc tabulate data=example; class group / mlf preloadfmt order=data; format group grp.; class year; table group='' all , year=''*n=''; run; Caveats: Only a few procedures support multilabel formats and I'm not sure Report does. Also Tabulate is somewhat more limited on calculations than Report as you can't calculate with the summaries and "breaks" aren't really available though All does summaries.     Another way would be to repeat the ALL for the group variable with different labels   proc format library=work; value grpx (multilabel notsorted) 1 = "Group 2" 2 = "Group 3" ; run; proc tabulate data=example; class group ; format group grpx.; class year; table all='Group 1' group='' all='Total' , year=''*n=''; run;     ... View more

hey thanks man for the the tips. I wasn't aware of the page function. ... View more

You'd better post it at ODS and Base Reporting and better offer some sample data ,so we can  test it . ... View more