https://communities.sas.com/t5/SAS-Programming/How-to-convert-two-columns-into-weekly-rate-in-SAS/m-p/526697#M143491 <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="IMG_1534(1).jpg" style="width: 320px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/26236i0078510165281353/image-size/large?v=v2&amp;px=999" role="button" title="IMG_1534(1).jpg" alt="IMG_1534(1).jpg" /></span>I need help in converting the ESC and seisurecount column into weekly rates.</P><P>The ESC column is a baseline 8 week seizure count while the Seizurecountcolum is a 2 week seizure count.</P><P>I have to convert both the 8 week and 2 week columns into weekly rates.</P><P>I havent written a code for this because I dont know how to start. Any help would be highly appreciated</P> Sun, 13 Jan 2019 03:45:39 GMT Stacy 2019-01-13T03:45:39Z https://communities.sas.com/t5/SAS-Programming/How-to-convert-two-columns-into-weekly-rate-in-SAS/m-p/526697#M143491 <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="IMG_1534(1).jpg" style="width: 320px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/26236i0078510165281353/image-size/large?v=v2&amp;px=999" role="button" title="IMG_1534(1).jpg" alt="IMG_1534(1).jpg" /></span>I need help in converting the ESC and seisurecount column into weekly rates.</P><P>The ESC column is a baseline 8 week seizure count while the Seizurecountcolum is a 2 week seizure count.</P><P>I have to convert both the 8 week and 2 week columns into weekly rates.</P><P>I havent written a code for this because I dont know how to start. Any help would be highly appreciated</P> Sun, 13 Jan 2019 03:45:39 GMT https://communities.sas.com/t5/SAS-Programming/How-to-convert-two-columns-into-weekly-rate-in-SAS/m-p/526697#M143491 Stacy 2019-01-13T03:45:39Z https://communities.sas.com/t5/SAS-Programming/How-to-convert-two-columns-into-weekly-rate-in-SAS/m-p/526715#M143500 <P>Don't write code until you know what you want to write.</P> <P>How can you convert a rate for 8 weeks or 2 weeks into a rate for 1 week?</P> <P>You can't.</P> <P>You could possibly make an estimate.</P> <PRE><CODE class=" language-sas">weekly_rate = rate / number_of_weeks;</CODE></PRE> <P>Is that what you want to calculate?</P> Sun, 13 Jan 2019 06:31:03 GMT https://communities.sas.com/t5/SAS-Programming/How-to-convert-two-columns-into-weekly-rate-in-SAS/m-p/526715#M143500 Tom 2019-01-13T06:31:03Z