(Background: I'm new to SAS and my organization uses SAS Data Integration Studio 4.9. I predominantly use SQL and have been provided the SQL code to create tables in SAS for later use in SAS VA.)   Using the Execute SQL Transformation, how do I map a column to a field with an expression in the PROC SQL Select. I have tried putting the expression into both the SQL and the Mappings, but it fails. Or is there anyway around mapping the columns in SAS Properties so that it will just refer to the SQL?    PROC SQL; CREATE VIEW work.Price_Compare AS SELECT A. Business_UNIT ,A.PO_ID ,A.LINE_NBR ,A.INV_ITEM_ID ,B.PRICE_PO ,A.UNIT_PRICE ,B.PRICE_PO - A.UNIT_PRICE  AS PRICE_DIFF     ... View more