Hello Experts, Hope all are doing fine. Please apologize to bother you with my question. I am trying to assign the initial ID to the other ID rows based on Prior ID column. Can you please help on this to figure the way to do it. I have data have; input ID $ p_id $ ; datalines; 006 . 007 006 008 . 009 . 010 007 011 010 ; run; I want Here, I am trying to create the 'NEED' column with first ID number value based on P_ID. If you see row#2 has P_ID as '006' , since I have record with ID = '006' so I need to get NEED = '006' for that record. Row # 5 has P_ID = '007' which has inital P_ID is '006', so I want '006' in NEED column for rows # 5. Likewise, For Row # 6, based on all previous P_ID values, we should get NEED = '006' for that column. Can you please help on this. Thanks all and Have a great day.
... View more