Error in simple code

[astha8882000]

I'm trying to view the contents of a dataset in the SASHelp library, but it gives me these errors. I'm not sure what is wrong with my simple code:

Code:

proc sql;
Select top 2 * from sashelp.aacomp;
quit;

Errors:

ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, (, *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN,
CONTAINS, EQ, EQT, GE, GET, GT, GTT, LE, LET, LIKE, LT, LTT, NE, NET, OR, ^=, |, ||, ~=.

ERROR 76-322: Syntax error, statement will be ignored.

[Reeza]

TOP 2 is not valid SAS syntax. You can OUTOBS= on the PROC SQL statement instead.

[Kurt_Bremser]

---

@astha8882000 wrote:

I'm trying to view the contents of a dataset in the SASHelp library, but it gives me these errors. I'm not sure what is wrong with my simple code:

Code:

proc sql;
Select top 2 * from sashelp.aacomp;
quit;

Errors:

ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, (, *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN,
CONTAINS, EQ, EQT, GE, GET, GT, GTT, LE, LET, LIKE, LT, LTT, NE, NET, OR, ^=, |, ||, ~=.

ERROR 76-322: Syntax error, statement will be ignored.

---

Your select has two items, a variable called top and the literal 2. These items need to be separated by a comma to get valid SQL syntax.