Column names can be case-sensitive ... proc sql; connect to oracle (user=testuser pass=testpass); create view myview as select * from connection to oracle (select "Amount Budgeted$", "Amount Spent$" ...