SAS 9.4 SQL Procedure User's Guide, Second Edition, 2nd Edition

proc sql;

create table one(pw=red, col1 num, col2 num, col3 num);

quit;

proc sql;

insert into one(pw=red, col1, col3)

values(1, 3);

quit;

proc sql;

update one(pw=red)

set col2 = 22

where col2 = . ;

quit;

You cannot use SAS data set options with DICTIONARY tables because DICTIONARY

tables are read-only objects.

The only SAS data set options that you can use with PROC SQL views are data set

options that assign and provide SAS passwords: READ=, WRITE=, ALTER=, and PW=.

For more information about SAS data set options, see SAS Data Set Options: Reference.

Using PROC SQL with the SAS Macro Facility

Overview of Using PROC SQL with the SAS Macro Facility

The ...