Solved: commit in a data step

juanvg1972 · Posted 06-13-2016 03:47 PM

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 · Posted 06-13-2016 04:01 PM

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

ballardw · Posted 06-13-2016 04:01 PM

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

commit in a data step