Output does not display when I run a simple stored procedure in EG 5.1

[sgtrun]

I have a simple query against the SASHELP.CARS table to pull all of the data (just using something simple to show what keeps happening).   So when I run the query I get all of the records and I then want to create a stored procedure.  I go through the steps and then the Results tab shows a blank screen.

PROC SQL;

CREATE TABLE WORK.FILTER_FOR_CARS AS

SELECT t1.Make,

t1.Model,

t1.Type,

t1.Origin,

t1.DriveTrain,

t1.MSRP,

t1.Invoice,

t1.EngineSize,

t1.Cylinders,

t1.Horsepower,

t1.MPG_City,

t1.MPG_Highway,

t1.Weight,

t1.Wheelbase,

t1.Length

FROM SASHELP.CARS t1;

QUIT;

[TomKari]

Generally the results will be "printed" proc output. Try doing a proc print on sashelp.cars.

Tom

[sgtrun]

Tom,

Typically the results will show up in the results tab without having to do a proc print.  I may have to call TS because a month ago the Results tab would show the results and now it shows up as a light blue screen but the log shows there were records generated.  I am thinking it might be a setting I have changed that messed things up. 

[Reeza · Accepted solution]

Your code above does not generate any output, it creates a table in your work library. 

If you'd like to see the records, remove the CREATE TABLE portion of the query.