Your SAS programs, embedded in web apps and elsewhere

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

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

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

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;


Accepted Solutions
Solution
‎10-31-2016 10:02 AM
Super User
Posts: 19,878

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

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. 

View solution in original post


All Replies
PROC Star
Posts: 1,167

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

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

 

Tom

Occasional Contributor
Posts: 5

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

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. 

 

Solution
‎10-31-2016 10:02 AM
Super User
Posts: 19,878

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

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. 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 236 views
  • 1 like
  • 3 in conversation