Hello,   I'm trying to keep an unscheduled visit that is only in one dataset for an aval derivation but I'm using a hash object merge. Here is a snippet of my data and dersired output. data have1; input SUBJID $ PARAMCD $ ADT :$9. AVISITN :8. AVISIT :$12. AVAL :8. ; infile datalines dlm = '|'; datalines; 1004|EASITOTA|21JUL2022|2|Day 1 |16.3 1004|EASITOTA|22JUL2022|99|Unscheduled |18 1004|EASITOTA|03AUG2022|4|Week 2 |8.6 1004|EASITOTA|17AUG2022|5|Week 4 |8.7 1004|EASITOTA|14SEP2022|6|Week 8 |9.6 ; run; data have2; input SUBJID $ ADT :$9. AVISITN :8. AVISIT :$12. RTT1L28D :8. RTT1G28D :8. SWREL :8. SWNREL :8. T2CM :8. RTT1L14D :8. RTT1G14D :8. NCUNODEV :8.; infile datalines dlm = '|'; datalines; 1004|21JUL2022|20|Day 1 |0|0|0|0|0|0|0|1 1004|03AUG2022|40|Week 2|0|0|0|0|0|0|0|1 1004|17AUG2022|50|Week 4|0|0|0|0|0|0|0|1 1004|14SEP2022|60|Week 8|0|0|0|0|0|0|0|1 1004|13OCT2022|70|Week 12|0|0|0|0|0|0|0|1 1004|10NOV2022|80|Week 16|0|0|0|0|0|0|0|1 ; run;       data want; input SUBJID $ PARAMCD $ ADT :$9. AVISITN :8. AVISIT :$12. AVAL :8. RTT1L28D :8. RTT1G28D :8. SWREL :8. SWNREL :8. T2CM :8. RTT1L14D :8. RTT1G14D :8. NCUNODEV :8.; infile datalines dlm = '|'; datalines; 1004|EASITOTA|21JUL2022|20|Day 1 |16.3|0|0|0|0|0|0|0|1 1004|EASITOTA|22JUL2022|99|Unscheduled |18 | | | | | | | | 1004|EASITOTA|03AUG2022|40|Week 2 |8.6 |0|0|0|0|0|0|0|1 1004|EASITOTA|17AUG2022|50|Week 4 |8.7 |0|0|0|0|0|0|0|1 1004|EASITOTA|14SEP2022|60|Week 8 |9.6 |0|0|0|0|0|0|0|1 1004|EASITOTA| |70|Week 12 | |0|0|0|0|0|0|0|1 1004|EASITOTA| |80|Week 16 | |0|0|0|0|0|0|0|1 ; run;         ... View more

Hello, I'm creating a parameter for a dataset and for each result (AVAL) there is a particular strategy (Composite Strategy 2). For this one I need to impute the AVAL from the last visit (DTYPE=LOV) (In this case Early termination and if an AVAL is present in that visit I need to use that AVAL for previous visits where AVAL is missing. My question is how do I do a double DOW loop to achieve this and get the missing AVAL records to populate with the AVAL from the Early Termination visit but without overwriting any visits where AVAL is present (In this example data the Week 2 AVAL). Here is a snippet of my current dataset and my desired output     data have; input PARAMCD $ STRATEGY :$30. DTYPE $ SUBJID $ VISIT :$30. AVAL :8.; infile datalines dlm = '|'; datalines; TOTEDPS1|Composite strategy 2|LOV|1001|Week 2|61.2 TOTEDPS1|Composite strategy 2|LOV|1001|Week 4| TOTEDPS1|Composite strategy 2|LOV|1001|Week 8| TOTEDPS1|Composite strategy 2|LOV|1001|Week 12| TOTEDPS1|Composite strategy 2|LOV|1001|Week 16| TOTEDPS1|Composite strategy 2|LOV|1001|Early Termination|43.5 TOTEDPS1|Composite strategy 2|LOV|1002|Week 2|16 TOTEDPS1|Composite strategy 2|LOV|1002|Week 4| TOTEDPS1|Composite strategy 2|LOV|1002|Week 8| TOTEDPS1|Composite strategy 2|LOV|1002|Week 12| TOTEDPS1|Composite strategy 2|LOV|1002|Week 16| TOTEDPS1|Composite strategy 2|LOV|1002|Early Termination|6.6 ; run; data want; input PARAMCD $ STRATEGY :$30. DTYPE $ SUBJID $ VISIT :$30. AVAL :8.; infile datalines dlm = '|'; datalines; TOTEDPS1|Composite strategy 2|LOV|1001|Week 2|61.2 TOTEDPS1|Composite strategy 2|LOV|1001|Week 4|43.5 TOTEDPS1|Composite strategy 2|LOV|1001|Week 8|43.5 TOTEDPS1|Composite strategy 2|LOV|1001|Week 12|43.5 TOTEDPS1|Composite strategy 2|LOV|1001|Week 16|43.5 TOTEDPS1|Composite strategy 2|LOV|1001|Early Termination|43.5 TOTEDPS1|Composite strategy 2|LOV|1002|Week 2|16 TOTEDPS1|Composite strategy 2|LOV|1002|Week 4|6.6 TOTEDPS1|Composite strategy 2|LOV|1002|Week 8|6.6 TOTEDPS1|Composite strategy 2|LOV|1002|Week 12|6.6 TOTEDPS1|Composite strategy 2|LOV|1002|Week 16|6.6 TOTEDPS1|Composite strategy 2|LOV|1002|Early Termination|6.6 ; run;         ... View more

Hello I basically want to keep the visit/visitnum from have2 where ANL01FL='Y' and match with visit/visitnum from have1 but also retain the week 12/16 records where aval is missing. Any help with this matter would be greatly appreciated.   data have1; input SUBJID $ PARAMCD $ ADT :$9. VISITNUM :8. VISIT :$12. AVAL :8. ; infile datalines dlm = '|'; datalines; 1004|EASITOTA|27JUN2022|1|Screening|9.6 1004|EASITOTA|21JUL2022|2|Day 1 |16.3 1004|EASITOTA|03AUG2022|4|Week 2 |8.6 1004|EASITOTA|17AUG2022|5|Week 4 |8.7 1004|EASITOTA|14SEP2022|6|Week 8 |9.6 ; run; data have2; input SUBJID $ ADT :$9. VISITNUM :8. VISIT :$12. ANL01FL :$1. RTT1L28D :8. RTT1G28D :8. SWREL :8. SWNREL :8. T2CM :8. RTT1L14D :8. RTT1G14D :8. NCUNODEV :8.; infile datalines dlm = '|'; datalines; 1004|21JUL2022|2|Day 1 |Y|0|0|0|0|0|0|0|1 1004|03AUG2022|4|Week 2 |Y|0|0|0|0|0|0|0|1 1004|17AUG2022|5|Week 4 |Y|0|0|0|0|0|0|0|1 1004|14SEP2022|6|Week 8 |Y|0|0|0|0|0|0|0|1 1004|13OCT2022|7|Week 12|Y|0|0|0|0|0|0|0|1 1004|10NOV2022|8|Week 16|Y|0|0|0|0|0|0|0|1 ; run; data want; input SUBJID $ PARAMCD $ ADT :$9. VISITNUM :8. VISIT :$12. RTT1L28D :8. RTT1G28D :8. SWREL :8. SWNREL :8. T2CM :8. RTT1L14D :8. RTT1G14D :8. NCUNODEV :8.; infile datalines dlm = '|'; datalines; 1004|EASITOTA|21JUL2022|2|Day 1 |16.3|0|0|0|0|0|0|0|1 1004|EASITOTA|03AUG2022|4|Week 2 |8.6 |0|0|0|0|0|0|0|1 1004|EASITOTA|17AUG2022|5|Week 4 |8.7 |0|0|0|0|0|0|0|1 1004|EASITOTA|14SEP2022|6|Week 8 |9.6 |0|0|0|0|0|0|0|1 1004|EASITOTA| |7|Week 12 | |0|0|0|0|0|0|0|1 1004|EASITOTA| |8|Week 16 | |0|0|0|0|0|0|0|1 ; run;     ... View more

Hello,   I have to derive aval based on conditional strategies.   "in the following order of priority: 1) Check "SWREL". If aval eq 1: Composite strategy 2 using "EASITOTA" as the source score if swrel = 1  then flg currently will be 'Composite Strategy 2'.  if swrel = 0 for all records per subject flag will be blank at this stage 2) Check "RTT1L28D” and “TCM2”. If aval eq 1: Composite strategy 1 using "EASITOTA" as the source score if either tcm2 or rtt1l28 = 1 along with swrel = 1 then flg will change from "Composite Strategy 2 " to  "Composite Strategy 1" . If swrel,rtt1l28,tcm2 all = 0 for all records per subject then flag will be blank at this stage 2) Check "SWNREL" aval eq 1: While-on-Treatment strategy. if swnrel = 1   and tcm2 or rtt1l28= 1 then flg  will be 'While-on-Treatment'. 3) Apply treatment policy strategy – use data as collected in “EASITOTA”" If swrel,rtt1l28,tcm2,swnrel all = 0 for all records per subject then flag will be 'treatment policy'     Programming logic "1)If AVAL = 1 for  "SWREL" , apply Composite strategy 2 using "EASITOTA" aval. 2) If AVAL equals 1 on either record where  "RTT1L28D" or "T2CM", apply Composite strategy 1 using "EASITOTA" aval. 3) If SWNREL equals 1 on the record,  apply While-on-Treatment strategy. 4) Apply Treatment Policy strategy using "EASITOTA" aval."   Here is the data in it's merged form with all relevant variables. For context the aval for SWREL, SWNREL, TCM2  and RTT1L28 represent intercurrent events and the score (AVAL)  was transposed to the EASITOTA  dataset and a value of 1 indicates an intercurrent event occurred and a value of 0 indicates no intercurrent event.   data have; input PARAMCD $ SUBJID $ AVISITN :8. ADT :$9. AVAL :8. RTT1L28D :8. T2CM :8. SWREL :8. SWNREL :8.; infile datalines dlm = '|'; datalines; EASITOTA|1001|20|27APR2022|13.4|0|0|0|0 EASITOTA|1001|30|11MAY2022|13.4|0|0|0|0 EASITOTA|1001|40|26MAY2022|13.4|0|0|0|0 EASITOTA|1001|50|22JUN2022|13.4|0|0|0|0 EASITOTA|1001|60|20JUL2022|13.4|0|0|0|0 EASITOTA|1001|70|31AUG2022|13.4|0|0|0|0 EASITOTA|1002|20|27APR2022|16.4|0|0|0|0 EASITOTA|1002|30|11MAY2022|16.4|0|0|0|0 EASITOTA|1002|40|25MAY2022|16.4|1|0|0|0 EASITOTA|1002|50|22JUN2022|16.4|1|0|0|0 EASITOTA|1002|60|20JUL2022|16.4|1|0|0|0 EASITOTA|1002|70|22AUG2022|16.4|1|0|0|0 EASITOTA|1003|20|07JUN2022|15.8|0|0|1|0 EASITOTA|1003|20|21JUN2022|15.8|1|0|1|0 EASITOTA|1003|30|05JUL2022|15.8|1|0|1|0 EASITOTA|1003|40|02AUG2022|15.8|0|0|1|0 EASITOTA|1003|50|30AUG2022|15.8|0|0|1|0 EASITOTA|1003|60|27SEP2022|15.8|0|0|1|0 EASITOTA|1003|70|25OCT2022|15.8|0|0|1|0 ; run; Basically I would like to create a flag that assigns the correct strategy to all records per subject so I can further go on to derive aval (based on these strategies below). I was thinking that a conditional dow loop may work here but if there is a simpler approach I would really appreciate it.       ... View more

Hello,   I have another question regarding aligning percentages in PROC Report. So currently my output is slightly off.   how can I consistently align them so they are the same regardless of the number and spacing. This would be the ideal output based on the example provided   Here is my code currently   %macro output(col=, page=); proc report data = page missing style=VeraRTF style(report)=[width=100% ] &_reportopts.; column paramn aval cond1 paramn &col.; /* Non printed order variables */ define paramn / order order=internal noprint; define aval / order order=internal noprint; /* Non printed variable used for indenting */ define cond1 / noprint; define col1 / id " " order order = internal style(column)=[width=28% asis=on just=l] style(header)=[width=28% asis=on just=l]; %if &page. = 1 %then %do; define col2 / id " " order order = internal style(column)=[width=3% asis=on just=l ]; define col3 / order order = internal style(column)=[width=11% asis=on just=l leftmargin = 2.5%]; define col4 / order order = internal style(column)=[width=11% asis=on just=l leftmargin = 2.5%]; define col5 / order order = internal style(column)=[width=11% asis=on just=l leftmargin = 2.5%]; define col6 / order order = internal style(column)=[width=11% asis=on just=l leftmargin = 2.5%]; %end; %if &page. = 2 %then %do; define col7 / page order order = internal style(column)=[width=11% asis=on just=l leftmargin = 2.5%]; define col8 / order order = internal style(column)=[width=10% asis=on just=l leftmargin = 2.5%]; define col9 / order order = internal style(column)=[width=8% asis=on just=l leftmargin = 2.5%]; define col10 / order order = internal style(column)=[width=8% asis=on just=l leftmargin = 2.5%]; define col11 / order order = internal style(column)=[width=8% asis=on just=l leftmargin = 2.5%]; %end; * Col1 indent *; compute col1; if cond1 eq 'Y' then call define(_col_, "style/merge", "style=[leftmargin=1.6%]"); endcomp; *Skip line *; compute before paramn; line " "; endcomp; run; %mend; %output(col = col1 col2 col3 col4 col5 col6, page = 1); %output(col = col1 col7 col8 col9 col10 col11, page = 2);   ... View more