Performing Queries Using SQL

Querying Multiple Tables

Write a clause to specify Clinic.Admit and Clinic.Insure as the tables to be queried.

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

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