No, I need all the information from Dataset A and set it to Dataset B, however, Dataset A has different STUDYID and USUBJID's. The only common variable between them is SUBJID. I am trying to find a way to match the STUDYID and USUBJID from Dataset A to Dataset B without hardcoding these values. ... View more

  This is exactly what I want to do and I believe this is my fault of making an incomplete dataset as I tried to simplify what i wanted. So your code actually does what I want but, it's not copying the entire row...for example I have 49 different variables in this dataset, however, when you're outputting the minimum value, it's copying everything that is in the maximum row:   For example: lets say I have this: Row SUBJID VISIT AVISIT ADY PARAMCD AVAL  1 1001 Week_1 Week_1 6 SUPINE 130 2 1001 Week_2 Week_2 12 SUPINE  133 3 1001 Week_3 Week_3 18 SUPINE 131 4 1001 Week_1 Week_1 6 ALT 8 5 1001 Week_2 Week_2 12 ALT 8 6 1001 Week_3 Week_3 18 ALT 8 7 1001 Week_1 Week_1 6 APC 5 I want this: Row SUBJID VISIT AVISIT ADY PARAMCD AVAL DTYPE 1 1001 Week_1 Week_1 6 SUPINE 130 2 1001 Week_2 Week_2 12 SUPINE  133 3 1001 Week_3 Week_3 18 SUPINE 131 4 1001 Week_1 Week_1 6 SUPINE  130 MINIMUM 5 1001 Week_2 Week_2 12 SUPINE  133 MAXIMUM 6 1001 Week_1 Week_1 6 ALT 8 7 1001 Week_2 Week_2 12 ALT 8 8 1001 Week_3 Week_3 18 ALT 8 9 1001 Week_1 Week_1 6 ALT 8 MINIMUM 10 1001 Week_3 Week_3 12 ALT 8 MAXIMUM 11 1001 Week_1 Week_1 6 APC 5 12 1001 Week_1 Week_1 6 APC 5 MINIMUM 13 1001 Week_1 Week_1 6 APC 5 MAXIMUM     The current code due to my lack of providing more context to the data creates the minimum line using all the data that is in the maximum line except for the aval value.  So your code is creating this: Row SUBJID VISIT AVISIT ADY PARAMCD AVAL DTYPE 1 1001 Week_1 Week_1 6 SUPINE 130 2 1001 Week_2 Week_2 12 SUPINE  133 3 1001 Week_3 Week_3 18 SUPINE 131 4 1001 Week_2 Week_2 12 SUPINE  130 MINIMUM 5 1001 Week_2 Week_2 12 SUPINE  133 MAXIMUM   ... View more

Hi I figured it , I subsetted the data into two groups. One with LBNAM="CVC" and one group without it.  Then performed the calculation via your code below, then set those subjects back with the group without the LBNAM="CVC" . However, I was hoping if your proc sql could be revised to also put Maximum as well if the aval is the same for example:   subjid paramcd aval 1 ALT 34 1 ALT 39 1 ALT 28 1 ALT 28 1 ALT 40 1 ALT 40 1 APT 15 1 APT 15 1 APT 15 1 APT 9 1 APT 9 1 APT 15 1 APT 12 1 ABC 9 1 ABC 9 1 ABC 9 1 ABC 9 I want the variable DTYPE to indicate the first max value and the first min value: subjid paramcd aval dtype 1 ALT 34 1 ALT 39 1 ALT 28 min 1 ALT 28 1 ALT 40 max 1 ALT 40 1 APT 15 max 1 APT 15 1 APT 15 1 APT 9 min 1 APT 9 1 APT 15 1 APT 12 1 ABC 9 min 1 ABC 9 max 1 ABC 9 1 ABC 9   When aval values are same, then MIN and MAX should have same value.   ... View more

Hi, is there a way to add a condition in this proc sql syntax to only do this when LBNAM="CVC" by any chance, without subsetting the whole dataset. Basically, I want it to perform this calculation only where LBNAM="CVC" out of all the 10 LBNAM's.    Thank you in advance.  ... View more

Hi thank you this is useful, however, I'm trying to add on a specific condition without subsetting. I'm trying to add the condition LBNAM="CVC" basically out of the whole dataset I only what this min and max to occur where LBNAM="CVC" without reducing the number of observations in the whole dataset.    I tried doing the following but it doesn't work, as it keeps applying values to other LBNAMs data want; minval = 1e200; maxval = .; do until (last.paramcd); set have; if LBNAM = "CVC" then do; by usubjid paramcd; maxval = max(maxval,aval); minval = min(minval,aval); end; end; do until (last.paramcd); set have; by usubjid paramcd; if aval = maxval dtype = "max"; maxval = .; end; if aval = minval then do; dtype = "min"; minval = .; end; output; dtype = ""; end; end; drop minval maxval; run; ... View more

Hi, So I actually want this For example lets say i have this set of data: subjid paramcd aval 1 ALT 34 1 ALT 39 1 ALT 28 1 ALT 28 1 ALT 40 1 ALT 40 1 APT 15 1 APT 15 1 APT 15 1 APT 9 1 APT 9 1 APT 15 1 APT 12 I want the variable DTYPE to indicate the first max value and the first min value: subjid paramcd aval dtype 1 ALT 34 1 ALT 39 1 ALT 28 min 1 ALT 28 1 ALT 40 max 1 ALT 40 1 APT 15 max 1 APT 15 1 APT 15 1 APT 9 min 1 APT 9 1 APT 15 1 APT 12 ... View more

Hi, I've attached a small subset of the data but that is essentially what i'm working with. the results in my table need to counts of how many total results there were per visit and then how many are in low(% of total), how many are normal(% of total), how many are in high (% of total), how many are in missing (% of total).  ... View more