Performing Queries Using SQL

Querying Multiple Tables

As the last clause in the SELECT statement, write a clause to select only rows with matching values for the column ID. (Remember to end the clause with a semicolon.)

proc sql; select admit.name,fee,total,balancedue, total-balancedue as AmountPaid from clinic.admit,clinic.insure

Copyright © 2002 SAS Institute Inc., Cary, NC, USA. All rights reserved.