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

Hi experts, Please apologize for any typos. I have the below dataset and I am trying to calculate the percent and flag. The first record of the subject will be calculated based on ((w2- w1)/w2)*100 and the same calculation will be carried out till any visit has percent +/-10%. If any visit (ascending order) has +/-10% then the later visits percent will be calculated based on that w2 value. Also we need flag the records where this change takes place.     Have this dataset:   data have; infile datalines dsd delimiter = ' ' ; input sub $ visit $ w1  w2 ; datalines; 001 Visit1 50 54 001 Visit2 50 57 001 Visit3 50 56 001 Visit4 50 51 001 Visit5 50 55 001 Visit6 50 54 002 Visit1 45 52 002 Visit2 45 48 002 Visit3 45 49 002 Visit4 45 46 002 Visit5 45 50 ; run;     and want this dataset   001 Visit1 50 54 8  001 Visit2 50 57 14      Y 001 Visit3 50 56 -1.7 001 Visit4 50 51 -10.5   Y 001 Visit5 50 55 7.8 001 Visit6 50 54 5.8 002 Visit1 45 52 15.5    Y 002 Visit2 45 48 -7.6 002 Visit3 45 49 -5.7 002 Visit4 45 46 -11.5   Y 002 Visit5 45 50 8.6   In want dataset, sub-001 has Visit1, Visit2 percent calculated based on W1. Due to the percent value +/-10% at Visit2 the later visits Visit3, Visit4 percent calculated based on Visit2 w2 value.   Due to the Visit4 has +/-10% the later visits from there will be calculate based on Visit4 W2 value.    Can you please help me on this.     ... View more