Excel is generated but no data.

[ss171]

ODS EXCEL FILE='/Reports/Daily_delta1.xlsx'
options (sheet_name='CRM' embedded_titles='yes');
title "CRM Indicators By Portfolio on the Daily Delta Files from Equifax";

proc sql;
create table indicators as 
select *
FROM RESULTS;
QUIT;
ods excel close;
please help 

[Kurt_Bremser · Accepted solution]

A CREATE TABLE statement in SQL does exactly that, it creates a dataset, but it does not produce output for sending to ODS. If you want output from SQL, omit the CREATE TABLE and just use a SELECT:

proc sql;
select *
from results;
quit;

A better way to simply send a table to the ODS is PROC PRINT:

proc print data=result noobs;
run;

If you want the observation numbers printed, omit the NOOBS option.