proc sql; connect to oracle (user=testuser pass=testpass); create view myview as select * from connection to oracle (select "Amount Budgeted$", "Amount Spent$" from mytable); quit; proc contents ...