I am posting a (hopefully correct) response for "How to select first few records to test the Proc SQL", which has a non-working solution, and is locked: https://communities.sas.com/t5/SAS-Programming/How-to-select-first-few-records-to-test-the-Proc-sql/td-p/7589 @LAP @srinidelite @SimonJF @ChrisNZ @Reeza @LinusH the solution I came up with is: Proc Sql outobs=10; create table TESTRESULT as select COL1, COL2 from YOURLIB.YOURTABLE where YOURFILTERS; quit; If there is no error in the SQL statement, this will return 10 records and produce &syscc = 4 / &sqlrc = 4 (warning.) You need to code to check SYSCC/SQLRC, if you are checking for warnings or errors.
... View more