Hi, are you trying do define a macro called abc_call (parms = ) or do you want to call the macro that is called abc_call? I am not sure if you can create a sas macro program name based on macro variables. But, that is just my guess. But, if you want to call a predefined macro based on a macro variable, that seem to be working.    %let client=abc; %macro abc_call (parms = ); %put This is the inparameters &=parms; %mend; %&client._call(parms=Hello World); ... View more

data in; input Patient $ adtm $ Value Unit $ Type $ avisit $ bflag $; cards; A Jan12019 1 m Height baseline Y A Jan12019 50 kg Weight baseline Y A Jan52019 2 m Height visit1 . A Jan52019 55 kg Weight visit1 . B Jan12019 1 m Height baseline Y B Jan12019 50 kg Weight . . B Jan52019 55 kg Weight baseline Y ; proc sort data=in; by patient adtm descending Type; run; data want; set in; by patient adtm descending Type; retain weight_ height_; if first.adtm then do; weight_=.; height_=.; end; if type='Weight' then weight_=Value; else if type='Height' then height_=Value; if last.adtm then do; bmi=weight_/height_**2; end; output; if bmi ne . then do; type='BMI'; value=bmi; unit='kg/m2'; output; end; drop height_ weight_ bmi; run;   ... View more

Note that if your BY statement has two variables like: by CN SEN; Then whenever you are at the first observation for a given value of CN you are also by definition at the first observation for any variable after it in the BY statement.  So your IF condition can be simplified by eliminating the FIRST.CN. if first.SEN   ... View more