I have tried the following code, but it's not giving the expected result: proc sql; create table want as select a.*, case when a.visitnum = b.visitnum and a.visit = b.visit then b.visitdy end as visitdy from have1 a, have2 b; quit; proc print data=want;run;  Please, help  ... View more

I have tried the following code, but it's not giving the expected result: proc sql; create table want as select a.*, case when a.visitnum = b.visitnum and a.visit = b.visit then b.visitdy end as visitdy from have1 a, have2 b; quit; proc print data=want;run; ... View more

Yes, the logic is : If have1.visitnum=have2.visitnum and have1.visit=have2.visit then want.visitdy = have2.visitdy; Note: Want table will contain all variables studyid, usubjid, visitnum, visit and visitdy ... View more

Sorry, I know only this requirement that using two datasets have1 and have2, need to produce another table want as shown above and not sure of the logic, but I think, following is the Logic by looking at have1 and have2 and want tables: If have1.studyid=have2.studyid and have1.visitnum=have2.visitnum and have1.visit=have2.visit then want.visitdy = have2.visitdy; Note: Want table will contain all variables studyid, usubjid, visitnum, visit and visitdy ... View more

Expected output: Need to create a new dataset by using have1 and have2 as below:  studyid usubjid visinum visit visitdy S001 1001 0 SCREENING -28 S001 1001 1 Day-1 -1 S001 1001 2 Day1 1 S001 1001 3 Day2 2 S001 1001 4 Day3 3 S001 1001 5 Day4 4 S001 1001 6 Day5 5 S001 1001 7 Day6 6 S001 1001 8 Day7 7 S001 1001 9 Day8 8 S001 1001 10 Day9 9 S001 1001 11 Day10 10 S001 1001 12 Followup1 14 S001 1001 99 unscheduled1 S001 1002 0 SCREENING -28 S001 1002 1 Day-1 -1 S001 1002 2 Day1 1 S001 1002 3 Day2 2 S001 1002 4 Day3 3 S001 1002 5 Day4 4 S001 1002 6 Day5 5 S001 1002 7 Day6 6 S001 1002 8 Day7 7 S001 1002 9 Day8 8 S001 1002 10 Day9 9 S001 1002 11 Day10 10 S001 1002 12 Followup1 14 S001 1003 0 SCREENING -28 S001 1003 1 Day-1 -1 S001 1003 2 Day1 1 S001 1003 3 Day2 2 S001 1003 4 Day3 3 S001 1003 5 Day4 4 S001 1003 6 Day5 5 S001 1003 7 Day6 6 S001 1003 8 Day7 7 S001 1003 9 Day8 8 S001 1003 10 Day9 9 S001 1003 11 Day10 10 S001 1003 12 Followup1 14 S001 1003 99 unscheduled1 S001 1004 0 SCREENING -28 S001 1004 1 Day-1 -1 S001 2001 0 SCREENING -28 S001 2001 1 Day-1 -1 S001 2001 2 Day1 1 S001 2001 3 Day2 2 S001 2001 4 Day3 3 S001 2001 5 Day4 4 S001 2001 6 Day5 5 S001 2001 7 Day6 6 S001 2001 8 Day7 7 S001 2001 9 Day8 8 S001 2001 10 Day9 9 S001 2001 11 Day10 10 S001 2001 12 Followup1 14 S001 2002 0 SCREENING -28 S001 2002 1 Day-1 -1 S001 2002 2 Day1 1 S001 2002 3 Day2 2 S001 2002 4 Day3 3 S001 2002 5 Day4 4 S001 2002 6 Day5 5 S001 2002 7 Day6 6 S001 2002 8 Day7 7 S001 2002 9 Day8 8 S001 2002 10 Day9 9 S001 2003 0 SCREENING -28 S001 2003 1 Day-1 -1 S001 2003 2 Day1 1 S001 2003 3 Day2 2 S001 2003 4 Day3 3 S001 2003 5 Day4 4 S001 2003 6 Day5 5 S001 2003 7 Day6 6 S001 2003 8 Day7 7 S001 2003 9 Day8 8 S001 2003 10 Day9 9 S001 2003 11 Day10 10 S001 2003 12 Followup1 14 S001 2004 0 SCREENING -28 S001 3001 0 SCREENING -28 S001 3002 0 SCREENING -28 ... View more

Thank you very much, it's working and it helped me a lot. Once again, thank you very much. ... View more

I have tried the following but, it is inserting a new row for subjid 101 only and not for subjid 102. But, I want to insert a new record for subjid 102 also.   Here is the code that I have tried: data have1; set visit_sorted; by subjid visitn; output; retain _basesubjid _basevisit _baseaval _basevisitn; if visit = 'base' and aval ne . then do; _basesubjid = subjid; _basevisit = visit; _baseaval = aval; _basevisitn = visitn; end; if _n_= 3 then do; subjid = _basesubjid; visit = _basevisit; aval = _baseaval; visitn = _basevisitn; dtype = 'BOCF'; output; end; drop _basesubjid _basevisit _baseaval _basevisitn; run; proc print;run; If anyone can help to insert the row for subjid 102 record also, it would be of great help. For subjid 102, following record highlighted in 'Red' color to be inserted between v1 and v2 records. data have; input subjid visit$ aval; cards; 101 screen 20 101 base 25 101 v1 25 101 v2 26 102 screen 25 102 base 30 102 v1 25 102 v2 30 103 screen 23 103 base 33 ; run; ... View more

If anyone can help me to achieve the following, would be of great help. In this, I have excluded the requirement for subjid 103 v1 and v2.   data have; input subjid visit$ aval; cards; 101 screen 20 101 base 25 101 v1 25 101 v2 26 102 screen 25 102 base 30 102 v1 25 102 v2 30 103 screen 23 103 base 33 ; run;   There are 3 subjid's 101, 102 and 103. For subjid 101 and 102, the row with visit as base is highlighted in blue color. Since, subjid 103 does not have v1 and v2, I have not highlighted the base row is not highlighted.   I want the above blue color highlighted rows inserted in between within each subjid group as follows:   data want; input subjid visit$ aval; cards; 101 screen 20 101 base   25 101 v1     25 101 base   25 101 v2     26 102 screen 25 102 base   30 102 v1     25 102 base   30 102 v2     30 103 screen 23 103 base   33 ; run; Then newly inserted rows are highlighted in Amber color. ... View more

For 103 v1 and v2, since it's just for testing purpose, I have used some example values for aval. ... View more

It's that I want to insert a row containing the base value for subjid before their visit 2 i.e., v2. I am just checking how to carry forward this row and insert it.    If visit 1 and visit 2 are missing for any subjid (in this example, they are missing for subjid 103), then create these two rows for that subjid (here aval can have any value as it is just for test purpose) and insert the row with base visit before the row of visit 2. ... View more

Here, is the data set that I have: data have; input subjid visit$ aval; cards; 101 screen 20 101 base 25 101 v1 25 101 v2 26 102 screen 25 102 base 30 102 v1 25 102 v2 30 103 screen 23 103 base 33 ; run;   There are 3 subjid's 101, 102 and 103. For each of these subjid group values, the row with visit as base is highlighted in blue color.   I want the above blue color highlighted rows inserted in between within each subjid group as follows and for subjid 103 since there are no rows for visits v1 and v2 and hence need to add these rows also:   data want; input subjid visit$ aval; cards; 101 screen 20 101 base   25 101 v1     25 101 base   25 101 v2     26 102 screen 25 102 base   30 102 v1     25 102 base   30 102 v2     30 103 screen 23 103 base   33 103 v1     20 103 base   33 103 v2     25 ; run; Then newly inserted rows are highlighted in Amber color.   Thanks ... View more