proc Report concatenation

[DLROW]

Hi , I am trying to populate the value in the proc report statment but it is not working. Please advise.

min weight = 30

max weight = 40

Proc sql;

select MIn(weight) , Max(weight) into :MinWeight, :Maxweight

from table1;

quit;

Proc report data = final;

columns A B C

("Min 30"  Name ("Activity" Amount Percent) ("May" Result)

When I use concatenating funtion it is not working. I want the minWeight to be populated when the report runs..

("Min " || "&MinWeight" Name ("Activity" Amount Percent) ("May" Result) . 

[Reeza]

You don't need the concatenation operator here at all, just drop it and it should work fine.

[learsaas]

Proc report data = final nowd;
columns A B C
("Min &MinWeight" Name ("Activity" Amount Percent) ("May" Result))
;
run;

[DLROW]

Thank you. It works but I get lot of space between Min and Minweight.
It is like
Min 30
Please let me know how can this space be reduced.

[DLROW]

Min ( lot if space) 30

[Reeza]

Look up the TRIMMED option when creating macro variables.

[learsaas]

Proc report data = final nowd;
columns A B C
("Min %left(&MinWeight)" Name ("Activity" Amount Percent) ("May" Result))
;
run;