From where does your obsession with SQL come from? If the data step does what you want, stay with it.
(Answer to your question: none, as there isn't one. At least one that makes sense. SQL behaves differently, period)
... View more
I don't know if it could work, I never test it before.
1) libnanme z ......... /* NO access=readonly option*/
data SQL_lib.want;
set SAS_lib.want;
run;
OR
proc copy in=SAS_lib out=SQL_lib;
select want;
run;
OR SQL
proc sql;
insert into SQL_lib.want
select * from SAS_lib.want;
quit;
2)PROC DBLOAD .
3)Pass-through
proc sql;
connect to pcfiles();
execute( inset into ......... )
by pcfiles;
quit;
... View more
