DATA Step, Macro, Functions and more

commit in a data step

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 93
Accepted Solution

commit in a data step

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


Accepted Solutions
Solution
‎06-13-2016 04:25 PM
Super User
Posts: 10,538

Re: commit in a data step

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

View solution in original post


All Replies
Solution
‎06-13-2016 04:25 PM
Super User
Posts: 10,538

Re: commit in a data step

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 203 views
  • 0 likes
  • 2 in conversation