BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
ss171
Calcite | Level 5
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 
1 ACCEPTED SOLUTION

Accepted Solutions
Kurt_Bremser
Super User

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.

 

View solution in original post

1 REPLY 1
Kurt_Bremser
Super User

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.

 

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 652 views
  • 0 likes
  • 2 in conversation