I'm trying to assign rows in a table to a random variable entirely in Transact SQL (This is MS SQL Server ... except I can't use a variable inside my subquery (inline view, in Oracalese).

For this example you create a view descriptor, VLIB.ALLEMP, based on SYBASE data. The outer PROC SQL query retrieves data from the view descriptor; the subquery uses a Pass-Through query to retrieve ...

The result of a NOT EXISTS condition is true if the subquery evaluates to zero rows. For example, the following query subsets ... all the employees from PROCLIB.PAYROLL who live in CT. proc sql; ...