topic Re: SAS table insert into Oracle by Data Step in SAS Programming

SAS table insert into Oracle by Data Step

sorosch — Sun, 25 Sep 2016 13:08:48 GMT

Hello,

i want to insert a SAS Table into Oracle. Normally i use PROC SQL. But in this case i must recode or query every row in the SAS table - and after this the row should be inserted or not in Oracle.

This i want to do (with pseudo-code):

read until sas_base_table is EOF

"recode/do something with" the sas_base_row

if sas_base_row is a hit then
insert into oracle_table
else
DO NOTHING
end if

end read

How can i do that? Is there somewhere perhabs an example?

Thank you very much
Best regards
George

Re: SAS table insert into Oracle by Data Step

Tom — Sun, 25 Sep 2016 15:25:04 GMT

Why ?

If you want to write to Oracle using a data step then make a libref that points to your Oracel schema.

libname MYDB oracle .... ;

Generate the rows you want to insert. For example you could use a conditional OUTPUT statement in your data step to select the rows to insert.

data toadd ;
  set ....
  if ... then output;
run;

Then insert them.

proc append base=mydb.mytable data=toadd force;
run;

Re: SAS table insert into Oracle by Data Step

sorosch — Tue, 27 Sep 2016 11:38:50 GMT

Thank you very much for your help.

Best regards
George