Help using Base SAS procedures

Creating data set from query

Reply
Occasional Contributor
Posts: 9

Creating data set from query

I'm able to crate a report by using:



proc sql;

select * from all_jer
except
select *
from out_jer

order by 1 ; /** this is not working either ?? */

Can I have use this as a sub query to create a new table ?
I.e rather than a report o/p can I want dataset as an output ?
PROC Star
Posts: 7,360

Re: Creating data set from query

Mush,

Of course!

To avoid seeing the table, simply start your call with:

proc sql noprint;

Then, before your select statement, simply add:

create table you_choos_a_name as

Then continue on with the rest of your statements.

HTH,
Art
Contributor
Posts: 33

Re: Creating data set from query

Could you use CREATE TABLE lib.dataset AS
for your second line of code after the PROC SQL;?
Ask a Question
Discussion stats
  • 2 replies
  • 215 views
  • 0 likes
  • 3 in conversation