commit in a data step

[juanvg1972]

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

[ballardw · Accepted solution]

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.

B