How to output two tabs with different names in Excel format?

[ybz12003]

Hello, 

Is there a way to output two tabs with two different names and two different table titles in Excel format?  I could my output by assigning one tab with "NESS_Pos" and the other one was automatically changed to "NESS_Pos2" How can I assign to a specific name in the second table and tab? Thanks.

ods excel file="Test_&tdate..xlsx";

ods excel options(sheet_name="NESS_Pos");
title "new NESS tests with positive results only";
proc freq data=test; 
table updated_timestamp;
table epi_message*erv_rslt / list missing;
run;
title;

ods excel close;

[pink_poodle]

title "new NESS tests with positive results only";
proc freq data=test; 
     table updated_timestamp;
     table epi_message*erv_rslt / output = test2 list missing;
run;
title;

PROC EXPORT DATA= test2  /*Sheet 1*/
        outfile= "Test_&tdate..xlsx "
        dbms=xlsx replace;
        sheet="NESS_Pos";
run;

PROC EXPORT DATA= test2  /*Sheet 2*/
        outfile= "Test_&tdate..xlsx "
        dbms=xlsx replace;
        sheet="NESS_Pos2";
run;

[Tom · Accepted solution]

Use two separate PROC steps.

ods excel file="%sysfunc(pathname(work))/sheetnames.xlsx";
ods excel options (sheet_name='SEX');
proc freq data=sashelp.class;
  tables sex;
run;
ods excel options (sheet_name='AGE');
proc freq data=sashelp.class;
  tables age;
run;
ods excel close;