@regulargal  The EXECUTE SQL Transformation is only of relevance if you're interfacing with a database and you want to write native database SQL which doesn't move data between SAS and the database (i.e. T-SQL).   To create a SAS view: Just use the Extract or Join transformation, connect the source tables or views to the transformation and map your columns as required to target. The Expression column in the mapping (part of the target table) allows you to define expressions. These expressions will then get used to generate the SQL Select bit for the view. Test what you've done by examining the generated code in the Code tab and by executing the code (right click on the target table - green table - and make sure View is not ticket because you want the code to actually execute and throw syntax errors and not just to define the view).   Once you're done right click on the target table, make sure that "vVew" is checked and then select "register table" and give the table the right name (metadata and physical and choose the library under which it should be registered).   ... View more