Help using Base SAS procedures

how to use PROC sql to declare cursor?

Reply
N/A
Posts: 1

how to use PROC sql to declare cursor?

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.

Frequent Contributor
Posts: 118

Re: how to use PROC sql to declare cursor?

Posted in reply to lizhenphd

Hi,

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

have a look into Cynthia's comment.

Regards

Uma Shanker Saini

Ask a Question
Discussion stats
  • 1 reply
  • 2097 views
  • 0 likes
  • 2 in conversation