Search notes:

SAS: proc sql - insert

insert into … set

With the set clause, it's possible to specify an alternative order of columns in an insert statement:
proc sql;

  create table tq84_tab (
     col_1   char(10),
     col_2   num,
     col_3   char(10)
  );


  insert into tq84_tab
  set
     col_3 = 'three',
     col_2 =  2     ,
     col_1 = 'one'  ;

  select * from tq84_tab;

quit;
Github repository about-SAS, path: /programming/proc/sql/insert/set.sas

See also

proc sql

Index