DATA Step, Macro, Functions and more

Return Latest Iteration of observations

Reply
New Contributor
Posts: 4

Return Latest Iteration of observations

I have a table that contains order ID numbers.

When an order is updated, the observation for that order isn't updated. Instead, a new observation is inserted into the dataset so there would be two observations for a single order.

 

There is a variable that identifies the iteration of the observation for a particular order ID. So, the initial order will be iteration 1. If an order is updated, there will be a 2nd record that that order where the iteration number is 2. 


How would I query this table to return only observations with the highest iteration number for a each order id?

Super User
Posts: 2,061

Re: Return Latest Iteration of observations

Well, wouldn't you be wanting to query and filer on getting max of the dates for the order id's? To me this makes sense to get the latest inserted row considering the latest insert would have the most recent date, right?

New Contributor
Posts: 4

Re: Return Latest Iteration of observations

Posted in reply to novinosrin

Hi  novinosrin

 

Respected Advisor
Posts: 3,278

Re: Return Latest Iteration of observations

[ Edited ]

UNTESTED CODE

 

proc sql;
    create table want as select * from have group by order_id having iteration_number=max(iteration_number);
quit;
--
Paige Miller
New Contributor
Posts: 4

Re: Return Latest Iteration of observations

Posted in reply to PaigeMiller

Hmm, i think this will work actually. I'll test it and get back to you in a bit

Ask a Question
Discussion stats
  • 4 replies
  • 85 views
  • 0 likes
  • 3 in conversation