topic Re: proc Report concatenation in New SAS User

proc Report concatenation

DLROW — Wed, 19 Dec 2018 22:04:36 GMT

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 — Wed, 19 Dec 2018 22:43:34 GMT

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

learsaas — Thu, 20 Dec 2018 01:13:23 GMT

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

DLROW — Thu, 20 Dec 2018 02:49:54 GMT

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 — Thu, 20 Dec 2018 02:50:41 GMT

Min ( lot if space) 30

Reeza — Thu, 20 Dec 2018 04:36:18 GMT

Look up the TRIMMED option when creating macro variables.

learsaas — Thu, 20 Dec 2018 08:18:38 GMT

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