I am wondering if the use of :
in an Oracle query with outobs = 10 in the Proc Sql statement could cause records that are in the table not to be be selected.
I am trying to select 10 records that have a certain status code. I wanted to randomly pick the records and limit the number of records.
If there are only 30 records on the table that meet the criteria, it is possible that all of the 30 records are being bypassed because of the randomizing routine causing me to get no records in my selection?