Do you want to find out how to avoid duplicates in the results of a SQL SELECT query? This article will show you how. Simply use the DISTINCT clause and between the SELECT clause and the fields.

Note: See the appendix for a description of DLIB.OUTOFSTK. You can use the SQL procedure to create a view that joins the data from these three sources and displays their output. The SAS WHERE or ...