Again s_lassen thanks for your answer.   For further reference I want to explain for other Sas-novices like me how solution 2 works: /* *** Create a temporary 'document' with the name tempsas *** */ Filename tempsas temp; /* *** Loop throuhg ValuesForA and write into tempsas. *** */ /* (The resulting tempsas is basically an SQL insert statement. All observations are written in one big values statement) */ Data _null_; file tempsas; set ValuesForA end=done; if _N_=1 then put 'rsubmit;' / 'proc sql;' / ' Connect to DB2(<connect options>);' / ' execute by DB2(' / ' insert into DBTable (a,b)' ' values' ; put " ('" a +(-1) "',' ')" @; /* "a" is the observation ValuesForA.a "+(-1)" removes the trailing blank set by the put statement "@" writes the next put statement in the same line if done then put / ' );' / 'quit;' / 'endrsubmit;' ; else put ','; run; /* *** Run the code in tempsas *** */ %include tempsas; For debugging and understanding this code one can also write the result into a file (change filename tempSas temp; to filename tempsas disk "example.txt"; and remove %include tempsas;) and see the resulting code in that file. ... View more

Thanks for the reply. Solution 1: I think I would prefer this solution, but in my case that's not possible as I don't have rights to create tables in the database. Solution 2: This seems to be a solution that stays on the SAS-side as long as it can, which for me is actually quite good. But I have troubles to understand the code. Can you point out to me where the content of ValuesForA get's transfered into the server session. I assume it's the line ending in an @, so maybe you can tell me what kind of syntax this is or where I can read about that. I don't want to hurt the companie's data base 😛 ... View more

Thanks for the tipp 🙂 But it does not seem to work. Column C is still not filled with (null) (in DbVisualizer the character in column C is displayed as a square btw) ... View more