commit in a data step

juanvg1972 — Mon, 13 Jun 2016 19:47:40 GMT

Hi,

Can I do a commit in a data step similar to sql commits?

data tab2;

set tab2;

....

run;

For example, every 1000 rows.

Thanks

Re: commit in a data step

ballardw — Mon, 13 Jun 2016 20:01:23 GMT

You may need to provide specific details on what your are attempting.

The OUTPUT statement is executeable and can be conditional so if you do something like:

Data tab3;

set tab2;

if mod(_n_,1000)=0 then output;

run;

you can get get every 1000 record. _n_ is an automatic variable indicating the record read, MOD is a function doing modular arithmetic.

BTW be very carefule using the Data table; Set table; construct. Logic errors may mean that you destroyed the data you needed at a later step.