proc sql ;
select * from inp.inp_claims_lds2013_2016
group by prvdr_num
quit;
LOG BELOW
99
100 proc sql ;
101 select * from inp.inp_claims_lds2013_2016
102 group by prvdr_num
103 quit;
____
22
76
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, ',', -, '.', /, <, <=, <>, =, >, >=, ?,
AND, CONTAINS, EQ, EQT, GE, GET, GT, GTT, HAVING, LE, LET, LIKE, LT, LTT, NE, NET, OR, ORDER, ^=, |, ||,
~=.
ERROR 76-322: Syntax error, statement will be ignored.
proc sql ;
select * from inp.inp_claims_lds2013_2016
group by prvdr_num;
quit;
YOU NEED TO HAVE semicolon before you write a quite statement
proc sql ;
select * from inp.inp_claims_lds2013_2016
group by prvdr_num;
quit;
YOU NEED TO HAVE semicolon before you write a quite statement
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.