BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
sgtrun
Fluorite | Level 6

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;

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

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

3 REPLIES 3
TomKari
Onyx | Level 15

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

 

Tom

sgtrun
Fluorite | Level 6

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
Super User

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. 

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

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
  • 3 replies
  • 1608 views
  • 1 like
  • 3 in conversation