https://communities.sas.com/t5/SAS-Data-Management/Creating-weighted-variables/m-p/249405#M6640 <PRE><CODE class=" language-sas">proc sql ; select *, days/SUM (days) as weight from have group by id; quit;</CODE></PRE> Thu, 11 Feb 2016 10:05:57 GMT mohamed_zaki 2016-02-11T10:05:57Z https://communities.sas.com/t5/SAS-Data-Management/Creating-weighted-variables/m-p/249398#M6638 <P>I'm having a problem that should be easy to solve, but my SAS experience is quite weak. My dataset have multiple records per case, with each record containing data for a single episode = number of days spent on a given&nbsp;hospital unit. I want to divide the number of days spent on each hospital unit with the total number of days spent on all hospital units. I have attached a simplified example of the data structure and added a column of what I want to add to the data.</P><P>&nbsp;</P><P>Appeciate all suggestions,</P><P>&nbsp;</P><P>Mats</P> Thu, 11 Feb 2016 09:48:46 GMT https://communities.sas.com/t5/SAS-Data-Management/Creating-weighted-variables/m-p/249398#M6638 matti77 2016-02-11T09:48:46Z https://communities.sas.com/t5/SAS-Data-Management/Creating-weighted-variables/m-p/249405#M6640 <PRE><CODE class=" language-sas">proc sql ; select *, days/SUM (days) as weight from have group by id; quit;</CODE></PRE> Thu, 11 Feb 2016 10:05:57 GMT https://communities.sas.com/t5/SAS-Data-Management/Creating-weighted-variables/m-p/249405#M6640 mohamed_zaki 2016-02-11T10:05:57Z