Which dataset do you want in EXCEL? Your codes is creating a dataset named QUERY and then using PROC CONTENTS to create another dataset named DETAILS which you then print.
You can use ODS EXCEL to direct the PROC PRINT to an XLSX file. So you could create a file named "myfile.xlsx" with something like this.
ods excel file='/folders/myfolders/myfile.xlsx';
proc print data=details;
run;
ods excel close;
Or you could just copy the data instead of using PROC PRINT.
libname out '/folders/myfolders/myfile.xlsx';
proc copy inlib=work outlib=out;
select details ;
run;
libname out close;
... View more