how to use PROC　sql to declare cursor?

lizhenphd — Thu, 28 Nov 2013 07:47:19 GMT

98 Proc sql;

99 /*--1.

100 */

101 declare cursor_1 cursor scroll for

-------

180

ERROR 180-322:

102 select dealprice from Dealing where dealprice <> 0

103 ;

104 quit;

SQL is fine, but in SAS it is error. WHY? Thanks.

Re: how to use PROC　sql to declare cursor?

umashankersaini — Thu, 28 Nov 2013 10:40:40 GMT

Hi,

have a look into Cynthia's comment.

Regards

Uma Shanker Saini