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) .
Proc report data = final nowd;
columns A B C
("Min &MinWeight" Name ("Activity" Amount Percent) ("May" Result))
;
run;
Proc report data = final nowd;
columns A B C
("Min %left(&MinWeight)" Name ("Activity" Amount Percent) ("May" Result))
;
run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.