09-04-2016 01:20 PM
I have a dataset as below and wondering if there is a way I can use Proc Sql to create the new column Percent. I am trying code below which does not work and it gives me 100% for all values -
create table test as select a.*,
( Value/ sum(Value) ) as Percent
from test a
group by month,Range;
Need further help from the community? Please ask a new question.