Hello guys,   I have 5 models 0, 1,2,3,4. My variables are  tool1, tool2, tool3, tool5, tool6, tool11, tool12 and AUC   data one; input modelstep TOOL1 TOOL2 TOOL3 TOOL5 TOOL6 TOOL11 TOOL12 AUC  datalines; 0 -0.097544 0.38682 -0.057215 0.19231 0.013377 -0.35196 0.58613 0.69676  1 -0.097379 0.3858 -0.057377 0.19214 0.013363 -0.35187 0.58526 0.69668  2 -0.096809 0.38621 -0.057295 0.19177 0.013297 -0.35061 0.58444 0.69618  3 -0.09729 0.38838 -0.057003 0.19405 0.013242 -0.34783 0.57736 0.69666  4 -0.096492 0.3881 -0.054853 0.19513 0.013091 -0.33446 0.57587 0.6963  ; run; Data two; set one; retain difference_from_model0; if first.AUC then difference_from_model0=0; if last.id then output; proc print; run; i basically want to write a code to find the difference in AUC between model 0 and the other models (model 1 to model 4). Simply put , model 0- model1 will be first observation. model 0 - model 2 will be second observation. model 0 - model 3 will be third observation etc.  I want my final output to be something like this modelstep TOOL1 TOOL2 TOOL3 TOOL5 TOOL6 TOOL11 TOOL12 AUC Difference_from_model0 1 -0.097379 0.3858 -0.057377 0.19214 0.013363 -0.35187 0.58526 0.69668 xxxx 2 -0.096809 0.38621 -0.057295 0.19177 0.013297 -0.35061 0.58444 0.69618 yyyy 3 -0.09729 0.38838 -0.057003 0.19405 0.013242 -0.34783 0.57736 0.69666 zzzz 4 -0.096492 0.3881 -0.054853 0.19513 0.013091 -0.33446 0.57587 0.6963 cccc   I tried to use the retain function but have not been successful. My code is attached. Any help will be appreciated.     Thanks ... View more

Hello,   I have this dataset with observations sorted by 6 hospitals - 518 546 548 573 672 673.   I am trying to determine the number of people within each hospital and overall that have a diagnostic code of '311' through '31199' and i have used the retain function for this. Here are my codes. Any help will be appreciated. Data is attached   data seven; set one; by hospital id ; retain hospital; array ya icd1-icd6; if first.id then do; hosp=0; end; do over ya; if '311' le ya le '31199' then hosp=1; end; if last.id then output; proc print; run; ... View more

Hello programmers,   How can i use the lag function to print out patients that have 15% or more reduction in systolic BP and 8% or more reduction in diastolic BP between visits 1 and 5.   Thanks! ... View more

Hello programmers,   I am working on an ER injury data.    I consider an injury as 'new' if there were no previous ER visits with an injury within 90 days. Otherwise, it’s a 'followup' visit. All patients are injury free prior to 1998. The data is also such that a non-injury visit cannot occur between two related injury visits.   I have been struggling to Mark each injury as being "new" or "followup" and I've also struggled with using an If statement to subset only those records that reflect a new injury.   Any help is appreciated. Is it possible to use a lag and first. for this? My dataset is attached.   Thanks ... View more