Hey guys! I need help with a specific part of my sas code. I am supposed to use first. / last. and RETAIN to keep one record per patient and identify the highest and lowest temperature per patient. I am working with VS(vital signs data set ) which has multiple visits per patient and multiple temperatures recorded as well as multiple blood pressure taken ect.. I have the following code, which keeps only one record per patient, but then there isnt a value for temperature for that patient, because the first time it sees usubjid (the unique subject identifier) the temperature isnt recorded then is that makes sense? I therefore am not sure how i would go about this? ** i created vitals earlier in my code proc sort data = vitals; by usubjid; run; data vitals2(keep= ftemp usubjid visitnum vstptnum); set vitals; by usubjid; retain ftemp; if first.usubjid and then output; run;
... View more