So, I'll start with proc sql. Lots of times I'll have specific rows in mind that I want from a table, or I just want to look at the first few. But, SAS's implementation of SQL doesn't adhere to the ANSI standards and has their own proprietary stuff in there, so it took me a while to find out how to call specific rows.

The SAS command is MONOTONIC(). E.g., the syntax for selecting the first 100 rows from a table:

Code:

```
proc sql;
select x
from data
where monotonic() <= 100
; quit;
```

Code:

```
...
where rownum <=100
...
```

Code:

```
select top 100 x
...
```