Hi:
Generally, speaking, an application that has visibility of the cursor on the screen, where the cursor is or what button was pushed or what record is currently loaded into some screen fields is a front-end application. That kind of front end application could, in some DBMS systems or application environments, allow you to code the kind of cursor-aware query that you show.
But, you are correct when you say that Proc SQL does not have the concept of cursors. That's because PROC SQL is not meant to be run in a "read a row, display a row on the screen, change a row, update the row" scenario. If Proc SQL does work in this kind of scenario, it is in the background, behind a front-end application. Some databases (like Microsoft Access and possibly SQL Server) allow you to build data entry forms and reporting structures and data viewing applications that are an integral part of the database definition. SAS datasets and procedures are not as tightly coupled together as Microsoft Access forms and Access tables, for example.
The kind of "stored procedure" which you describe is different from the kind of "SAS stored process" that runs in the context of the SAS Enterprise Intelligence Platform. I surmise that you want/need to code some kind of application front end to your data -- there are many ways to do this in SAS -- SAS/AF, SAS/IntrNet and htmSQL, SAS AppDev Studio, SAS Enterprise Guide and custom tasks using .NET and .COM, JDBC and Java applets in the context of the Enterprise Intelligence Platform, BI Web services, OLE-DB ... ...
For urgent requests, your best bet for help is to contact SAS Technical Support. To contact Tech Support and open a track, go to
http://support.sas.com/ and in the left-hand navigation pane, click on the link entitled "Submit a Problem".
cynthia