Thank you for your replies. I was hoping to get frequencies of all the variables (a1 and a2) in the same table without having to join them. As you suggested, Proc Freq will ouput different table for each avriable. For this reason I am trying to use proc tabulate. My dataset looks like: ID     a1     a2 1      0     1 2     1     1 3      0     0 4     1    1 The output I am looking for is:           0   1 a1      2    2 a2      1    3 along with the percentages of 0 and 1 in each variable. I am trying using this code: proc tabulate data=in    out=out; class a1 a2; table  a1*(n) a2*(n); run; ... View more

See this example: data t1; input id d1 d2 d3 d4; cards; 111 2 4 6 7 222 4 5 6 7 111 3 2 5 8 222 5 6 3 2 ; run; proc sql;       create table t2 as select       id,       max(d1) as d1,       max(d2) as d2,       max(d3) as d3,       max(d4) as d4       from t1       group by id       order by id ; quit; This will give the output: 111 3 4 6 8 222 5 6 6 7 It will involve writing all your variable names in the proc sql step. There are ways to get those in SAS. However, you can also do that in Excel or Word. ... View more

Perhaps not an ideal solution but you could try OPTIONS ORIENTATION=LANDSCAPE to check if it works. ... View more

To reduce the white space and to get two tables on a single page (if they can fit) use STARTPAGE=NO in the ods rtf statement. ODS rtf has two options to control the table split: KEEPN (no split until necessary) and NOKEEPN (allows split). ... View more

I think your set fun statement should be before the do loop. ... View more

It will be helpful to see an example of your dataset. ... View more

You could also use proc contents or proc sql to get the variable names: proc contents data=have out=want ; run; OR proc sql; describe table have; quit; Check the log for the variable names. ... View more