Add the NOLABEL option to the query to display the renamed columns. The PROC SQL SELECT statement uses a CONNECTION TO component in the FROM clause to retrieve data from the ORACLE table. The ...

See Updating PROC SQL and SAS/ACCESS Views. Any column that is not modified retains its original values, except in certain queries using the CASE expression. See CASE expression for a description of ...