I'm not aware of the context of your question, but adding a column to a table should always require working from source to top, adding first this column to the previous tables/files in the process. Still, would a piece of code that you could run from DIS (say in a source editor window or pre-process) and automatically will refresh the layout of a specified table base on metadata, suit you? Cheers from Portugal. Daniel Santos @ www.cgd.pt ... View more

Ah, I see what you want. It always helps to have the specs. Then, I think that PROC TABULATE would be better than PROC REPORT. Given the same data as above for 12 hours, use TABULATE with VALUE and VALUE2 in the row dimension and then HOUR in the column dimension. cynthia   ods listing close; ods html file='c:\temp\two_val_tab_across.html'; proc tabulate data=hours f=comma6.0;   title 'Tabulate Example';   class hour;   var value value2;   table value='Value' value2='Value2',         hour / row=float;   keylabel sum=' '; run; ods html close; ... View more

This solution uses the array suggested by ArtT, but loops through the array rather than sorting the array, which would be more elegant. data have; input date date9. corr1_2 corr1_3 corr2_3; datalines; 16oct2012 .1 .9 .2 17oct2012 .5 .7 .3 run; data want;*(keep=date meancorr umean lmean);    set have;    array allcorr {*} corr:;    meancorr = mean(of corr:);    lower=pctl(5,of corr:);    upper=pctl(95,of corr:);        lmean=0; lcnt=0; umean=0; ucnt=0;    do i = 1 to dim(allcorr);       if allcorr{i} le lower then do;          lmean + allcorr{i};          lcnt + 1;       end;       if allcorr{i} ge upper then do;          umean + allcorr{i};          ucnt + 1;       end;     end;     lmean=lmean/lcnt;     umean=umean/ucnt;     output want;    run; proc print data=want; run; ... View more

Hi, Karun You're doing a great job of reading through papers and picking up SAS. Here's a couple of methods that I like to use when I'm trying to figure out code. Try it yourself, and see what you think. First, from looking at the code, it looks like there's a dataset a that contains a variable Id that is some kind of "key", and a variable Var that is continuous, and it gets treated differently if it's missing. So I created the following SAS program: data a(drop=I); do i = 1 to 50;   Id = floor(rand('uniform')*10);   Var = rand('uniform') * 100;   if rand('uniform') < .1 then    call missing(Var);   output; end; run; proc sort; by Id; run; You should be familiar with most of it. In terms of the unusual bits, the do...end will loop 50 times, and the output before the end writes a record, so it'll write 50 records to SAS dataset a; The rand('uniform') function will generate a random number uniformly distributed between 0 and 1. Multiplying it by 10 will uniformly distribute it between 0 and 10 (actually 9.9...), and the floor function will remove the decimal places, so Id will be a random integer between 0 and 9. Same idea for Var, but we'll make it between 0 and 100, and we won't remove the decimal places. The if statement will set Var to missing 10% of the time. And because there's a "by" statement in the code to be examined, we need to sort our data by the variable in the "by" statement. Here's the code under examination, with the changes I made: Data B ( Keep = Id Prod Sum Count Mean) ;   putlog 'After Data statement ' _all_;   Prod = 1 ;    Do Count = 1 By 1 Until ( Last.Id ) ;    putlog 'After Do statement ' _all_;    Set A ;     By Id ;        putlog 'After Set statement ' _all_;        If Missing (Var) Then Continue ;        Mcount = Sum (Mcount, 1) ;        Prod = Prod * Var ;        Sum = Sum (Sum, Var) ;        putlog 'Before End statement ' _all_;        End ;        Mean = Sum / Mcount ;        putlog 'Before Run statement ' _all_; Run ; The only thing I did was to add five "putlog" statements in. These will print out the comment of where in the code we are, and then the _all_ clause prints out the values of all of the variables in the program. As a result, you get a log listing that pretty much lets you track the logic of the program. Play with it, and see what you think. Tom ... View more