topic Re: How to select first few records to test implicit PROC SQL (corrected) in SAS Programming

How to select first few records to test implicit PROC SQL (corrected)

kentlewan — Wed, 01 Jul 2020 21:23:56 GMT

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.

Re: How to select first few records to test implicit PROC SQL (corrected)

ChrisNZ — Wed, 01 Jul 2020 23:37:54 GMT

Using option OUTOBS= is the chosen solution. As I see it, this post brings no value to a topic closed 12 years ago.

Re: How to select first few records to test implicit PROC SQL (corrected)

kentlewan — Wed, 01 Jul 2020 23:45:52 GMT

Not disagreeing with solution provided in 2008. However, the experts provided no sample code to allow users to copy. Unclear where OUTOBS= is supposed to go. That is why I've reposted it.

Re: How to select first few records to test implicit PROC SQL (corrected)

ChrisNZ — Wed, 01 Jul 2020 23:56:18 GMT

> Unclear where OUTOBS= is supposed to go.

Really?

Here is first line of the chosen reply:

you can use inobs= or outobs= option on the PROC SQL statement.

Re: How to select first few records to test implicit PROC SQL (corrected)

kentlewan — Thu, 02 Jul 2020 00:04:21 GMT

What's clear to you might not be as clear to newbies.
Why not wait and see if this post gets any likes.