how to use PROC sql to declare cursor?

[lizhenphd]

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.

[umashankersaini]

Hi,

https://communities.sas.com/thread/2965

have a look into Cynthia's comment.

Regards

Uma Shanker Saini