Skip to Main Content
Base SAS 9.4 Procedures Guide, Third Edition
book

Base SAS 9.4 Procedures Guide, Third Edition

by SAS Institute
August 2014
Intermediate to advanced content levelIntermediate to advanced
2218 pages
209h 16m
English
SAS Institute
Content preview from Base SAS 9.4 Procedures Guide, Third Edition
Details
This example creates a table from existing tables by using PROC FEDSQL and the
CREATE TABLE statement with the AS query expression syntax. The query expression
selects rows from existing tables to create the new table.
Program
libname mybase base 'C:\Base';
libname myspde spde 'C:\Spde';
libname myoracle oracle path=ora11g user=xxxxxx password=xxxxxx schema=xxxxxx;
proc fedsql;
create table mybase.results as
select product.prodid, product.product, customer.name,
sales.totals, sales.country
from myspde.product, myoracle.sales, myoracle.customer
where product.prodid = sales.prodid and
customer.custid = sales.custid;
select * from mybase.results; ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Base SAS 9.4 Procedures Guide, Second Edition

Base SAS 9.4 Procedures Guide, Second Edition

SAS Documentation
Oracle® Database 10g Insider Solutions

Oracle® Database 10g Insider Solutions

Arun Kumar R., John Kanagaraj, Richard Stroupe

Publisher Resources

ISBN: 9781629593043