I have data set for demo. where I want to create the avearge percent of weight and height and getting the table containg only 4 observations where min of weight, max of weight and min of height and max of height. But my coding is giving me column of same min and max every observation...Please kindly help me again. Thanks. below is just an example of table that I want. Ht Wt Percent of Average Ht Percent of Average Wt 155 200 87.1 …. 145 150 …. …. 171 220 …. …. 141 110 …. …. Here is the coding what I have done so far; proc sql; create table demonew as select *, mean(ht) as mean_ht format=6.2, (ht/mean(ht)) as pct_total_ht format=Percent8.4, mean(wt) as mean_wt format=6.2, (ht/mean(wt)) as pct_total_wt format=Percent8.4, max(ht) as max_ht, min(wt) as min_wt from demo ; select * from demonew ; quit; That's what I get with above code. Ht Wt Percent of Average Ht Percent of Average Wt Max Wt Max Ht 158 190 87.1 …. 220 171 146 140 …. …. 220 171 161 210 …. …. 220 171 151 130 …. …. 220 171
... View more
