Try the following: data want2; set db; length TypeTransfusion result $20; array list TypeTransfusion1-TypeTransfusion3 ; array list_r result1-result3; do index=1 to dim(list); TypeTransfusion=list[index]; result=list_r[index]; output; end; drop TypeTransfusion1-TypeTransfusion3 result1-result3; run; ... View more

In the case of my code where I treat the macro variable as text and compare it to text or @Quentin code that uses a macro %IF condition, you will get a value of Company=B for every observation in the Class data set. The following code works for me: %let cie=b2; data class; format company $1.; set sashelp.class; if "&cie" eq "b1" then company="A"; else if "&cie" eq "b2" then company ="B"; run; proc print; run; Output: Obs company Name Sex Age Height Weight 1 B Alfred M 14 69.0 112.5 2 B Alice F 13 56.5 84.0 3 B Barbara F 13 65.3 98.0 4 B Carol F 14 62.8 102.5 5 B Henry M 14 63.5 102.5 6 B James M 12 57.3 83.0 7 B Jane F 12 59.8 84.5 8 B Janet F 15 62.5 112.5 9 B Jeffrey M 13 62.5 84.0 10 B John M 12 59.0 99.5 11 B Joyce F 11 51.3 50.5 12 B Judy F 14 64.3 90.0 13 B Louise F 12 56.3 77.0 14 B Mary F 15 66.5 112.0 15 B Philip M 16 72.0 150.0 16 B Robert M 12 64.8 128.0 17 B Ronald M 15 67.0 133.0 18 B Thomas M 11 57.5 85.0 19 B William M 15 66.5 112.0 If this is not working for you, please send your log. ... View more

If you want the middle of the year, you can change the MDY function to the following: age=floor(YRDIF(d_birth, mdy(6,30,2025),"AGE")); ... View more

When you refer to variables under an Across, you need to refer to them by the column position, _Cn_. You can simplify this by using macro logic. Try the following: %macro loop; ods listing close; ods excel file='c:\temp\test.xlsx'; proc report data=sashelp.cars list spanrows; title "This is a complete report"; columns ("World Vehicle" origin make) drivetrain ,(msrp invoice) dummy; format msrp invoice dollar18.2; define Origin / group center; define Make / group left; define DriveTrain / across left; define dummy / computed noprint; break after origin / summarize style=[fontweight=bold]; compute dummy; %do i=3 %to 8; if _c&i._ > 100000 then call define("_c&i._", "style", "style={backgroundcolor=yellow}"); if _c&i._ > 1000000 then call define("_c&i._", "style/merge", "style={foreground=red}"); %end; endcomp; compute after origin; line " "; endcomp; run; ods excel close; ods listing; title; %mend; %loop ... View more