topic Re: How to output two tabs with different names in Excel format? in SAS Programming

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

ybz12003 — Tue, 30 Jan 2024 18:51:55 GMT

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;

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

pink_poodle — Tue, 30 Jan 2024 19:38:06 GMT

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;

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

Tom — Tue, 30 Jan 2024 19:57:43 GMT

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;