Hi SAS Community,   I have a data set where I am trying to find the max grade for each ID. This is simple enough using Proc SQL and then using a group by statement.   There are two problems that I am running into , the first is I am trying to identify the model where the max grade comes from and assign that model for each row with the same ID. In the example below,  for ID #1 model b has a higher grade of 2 than a that only has a grade of 1, so model b would be assigned as the max_ model for ID #1..    The second problem that I am trying to tackle is the same as the first problem with an added nuance, If there are multiple models that have the same highest grade for the ID, I want to pick the one one with the highest amount value. In the example below, for ID #2 has two models have the same max grade of 3. Since model a has a higher value, I would assign a to every row for ID 2   This is an example of my data id         model       grade       amount 1             a               1               10 1             b               2               10 2             a               3               20 2             b               3               10   This is what I envision my data to look like in the end id         model       grade       amount    max_grade max_model 1             a               1               10            2                 b 1             b               2               10            2                 b 2             a               3               20            3                 a 2             b               3               10            3                 a   Please reach out if you have any questions or need me to clarify anything.   Best, Tom ... View more

Hi SAS Community, I not very good at using macros yet.   I have a process that I run already (See below), but I have to change the model macro variable and rerun it each time I run it.   %let model= a /*b c d e*/; DATA a&model; SET &model(Keep=&model); RUN; DATA a2&model; SET &Data2(Keep=&model); run; proc freq data=a&model noprint ; tables &model/ out=base&model; run; proc freq data=a2&model noprint; tables &model/ out=current&model; run; data finbase&model; set base&model; Bin=&model; Counts_Training= COUNT; Percent_Total_Training= PERCENT; drop &model count percent; run; /*... (skipped a few steps just to make display shorter)*/ proc print data=final2&i noobs label; title1 "PSI for &model.: &q &model &year "; sum counts_training percent_total_training counts_validation percent_total_validation PSI; run;     Now I want to take want to take what I have and loop through all the values of the model macro variable.     %let model = a b c d e;     I tried following the example https://communities.sas.com/t5/General-SAS-Programming/Looping-with-Variable-Names/td-p/365111, but I am not doing it correctly because it should finish with a proc print for each iteration and nothing is printing out. What I tried was     %let model= a b c d e %macro test (list= &model) %local n i; %do n=1 %to %sysfunc(countw(&list)); %let i=%scan(&list,&n); DATA a&i; SET &i(Keep=&i); RUN; DATA a2&i; SET &Data2(Keep=&i); run; proc freq data=a&i noprint ; tables &i/ out=base&i; run; proc freq data=a2&i noprint; tables &i/ out=current&i; run; data finbase&i; set base&i; Bin=&i; Counts_Training= COUNT; Percent_Total_Training= PERCENT; drop &i count percent; run; data fincur&i; set current&i; Bin=&i; Counts_Validation= COUNT; Percent_Total_Validation= PERCENT; drop &i count percent; run; /*...*/ proc print data=final2&i noobs label; title1 "PSI for &i.: &q &i &year "; sum counts_training percent_total_training counts_validation percent_total_validation PSI; run; %end; %mend; %test;   If anyone could help me figure what I am doing wrong and how I could loop through this that would be extremely helpful! (I don't know why the formatting is appearing wierd.) ... View more