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;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.