PROC SQL issue

[jaymin_shah]

I have used If first. and last. options in data step. 

But, couldn't find any similar options in proc sql.

Please provide me the solution for this issue.

[PaigeMiller]

These options do not exist in PROC SQL.

They exist in DATA steps.

Thus, if you need to use these options, you would use a DATA step and not PROC SQL.

[PGStats]

• Conceptually, SQL operates on unordered sets of records. Operations such as first, last, next, previous have no meaning in that context.
• The DATA step on the other hand operates on a sequence of records. You will sometimes need to sort your data before running the DATA step. 

Use both! You will twice as efficient!

[LinusH]

"Please provide me the solution for this issue"
Yeah, what exactly is your issue?
Syntax itself us never an "issue".

[Peter_C]

Linus
I think the issue is establishing the first and last rows within groups. The limitation of sql was not justified.
The result (finding first. And last. Rows) is native to data steps. My issue is the unexplained constraint (using sql).
But it really is no issue at all.

[Patrick]

I believe @PGStats comment nailed it.

Having said that: Some database SQL extensions provide "first" and "last" as analytics functions http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions056.htm ... but then: They don't have the SAS data step and implementing the same with PLSQL can be painful.