You can use the SQL procedure's UPDATE statement to update the data in a DBF file, as illustrated by the following example. Because you are referencing a view descriptor, you use the SAS variable ...

A reader recently pointed out to me that I could drastically simplify that retrieval code by leveraging SQL views ... in my update/delete methods, I only need to work with a subset of those tables ...

PROC SQL allows you to specify the ORDER BY clause in the CREATE VIEW statement. Every time a view is accessed, its data are sorted and displayed as specified by the ORDER BY clause. This sorting on ...