Hallo, I have a table like this Date                       ID               return .... .... and I would like to transpose it to have something like date                100048              100055 Can anyone tell me how can I get this? Thanks alot ... View more

Hi, how can I make a summary table like this one:                mean     median     min     max     std var1          a             b          c          d          e                 var2          f               g          h          i          j          var3          k               l          n          o          p where a,b,c,... is calculated. Now i only have it as one row. also, for the median I have instead of just 1 number a lot of number (all the number of that column). Thank you very much! ... View more

Hi, I want to calculate the weighted average of some variable the code looks like this Proc sql;     Create table want as     Select date, id, sum(value) as value,         sum(Value1*Weight1)/sum(Weight1),          sum(Value2*Weight2)/sum(Weight2),           sum(Value3*Weight3)/sum(Weight3)      from sasdata.monthly_return_fund_summary_adj group by wficn, caldt; quit; but this one it also take into account the missing values. How can I adjust the code such that only observed values are use and all the missing values are skipped. Thank you very much! ... View more