topic Re: Error in simple code in SAS Programming

Error in simple code

astha8882000 — Thu, 31 May 2018 16:00:24 GMT

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.

Re: Error in simple code

Reeza — Thu, 31 May 2018 16:07:21 GMT

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

Re: Error in simple code

Kurt_Bremser — Thu, 31 May 2018 18:29:11 GMT

@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.