topic Re: Output does not display when I run a simple stored procedure in EG 5.1 in Developers

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

sgtrun — Fri, 28 Oct 2016 21:23:55 GMT

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;

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

TomKari — Fri, 28 Oct 2016 21:40:56 GMT

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

Tom

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

sgtrun — Fri, 28 Oct 2016 21:50:18 GMT

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.

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

Reeza — Fri, 28 Oct 2016 23:02:22 GMT

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.