ORDER A B
First 10 55
Second 12 34
Third 14 42
Trying to get an Excel output with three tabs: First, Second and Third. I need two proc reports on each tab. First report should display variable A and second report should display variable B. I get six tabs: First, Second, Third, First2, Second2, Third2 with one report on each. What am I doing wrong?
ods excel file="C:\TEST_EXAMPLE.xlsx" options(sheet_interval='bygroup' sheet_name="#byval1") ;
proc report data=test; by ORDER; column A;
run;
proc report data=test ; by ORDER; column B;
run;
ods excel close;
... View more
