Excel is generated but no data.

ss171 — Fri, 13 Nov 2020 07:30:40 GMT

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

Re: Excel is generated but no data.

Kurt_Bremser — Fri, 13 Nov 2020 07:44:33 GMT

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.

topic Excel is generated but no data. in SAS Enterprise Guide

Excel is generated but no data.

Re: Excel is generated but no data.