Export Multiple datasets into on Excel files with Sheet names

[SASuserlot]

I have two datasets with the same variables and the same formats. How to export them into one excel file with different sheets.  Is there any simple way, or do I have to write ODS EXCEL ( or TAGSETS) with PORC REPORT for each dataset? Thank you for your input.

In the following example, is there any way I can create a macro and loop the required datasets?  The following is simple  export

 data class1;
 set sashelp.class;
 run;

 data class2;
 set sashelp.class;
 run;


PROC EXPORT DATA= WORK.class1
            OUTFILE= "D:\Desktop\classes.xls" 
            DBMS=EXCEL REPLACE;
     SHEET="Class1"; /* for class2 I have to run it again*/
     NEWFILE=YES;
RUN;

This is how I want two sheets in one excel file

[SASKiwi · Accepted solution]

It's a lot easier if you use the XLSX LIBNAME:

data class1;
 set sashelp.class;
 run;

 data class2;
 set sashelp.class;
 run;

 libname CLASS XLSX "<MyDir>\Class.xlsx";

 proc datasets library = CLASS;
   copy in = WORK  out = CLASS;
  select class1 class2;
  run;
quit;

libname CLASS clear;

No loop needed.

[SASuserlot]

Thank you very much. It served my purpose.