topic SAS rolling average code using patient claims data in SAS Programming https://communities.sas.com/t5/SAS-Programming/SAS-rolling-average-code-using-patient-claims-data/m-p/490883#M128587 <P>I need to program market share based on a rolling 3 months average. I am using patient claims data. I would need to use a do loop to calculate the moving average by group (moving average of patients by brand by month) then calculate market share. Can someone help me with this?</P> Wed, 29 Aug 2018 15:16:22 GMT jkimmel 2018-08-29T15:16:22Z SAS rolling average code using patient claims data https://communities.sas.com/t5/SAS-Programming/SAS-rolling-average-code-using-patient-claims-data/m-p/490883#M128587 <P>I need to program market share based on a rolling 3 months average. I am using patient claims data. I would need to use a do loop to calculate the moving average by group (moving average of patients by brand by month) then calculate market share. Can someone help me with this?</P> Wed, 29 Aug 2018 15:16:22 GMT https://communities.sas.com/t5/SAS-Programming/SAS-rolling-average-code-using-patient-claims-data/m-p/490883#M128587 jkimmel 2018-08-29T15:16:22Z Re: SAS rolling average code using patient claims data https://communities.sas.com/t5/SAS-Programming/SAS-rolling-average-code-using-patient-claims-data/m-p/490886#M128590 If you need help please post some sample data and include anything you’ve tried to date. It also speeds things up if you show an example of the output that aligns with the input provided so logic can be verified. Wed, 29 Aug 2018 15:19:28 GMT https://communities.sas.com/t5/SAS-Programming/SAS-rolling-average-code-using-patient-claims-data/m-p/490886#M128590 Reeza 2018-08-29T15:19:28Z Re: SAS rolling average code using patient claims data https://communities.sas.com/t5/SAS-Programming/SAS-rolling-average-code-using-patient-claims-data/m-p/490901#M128596 <P>Do you have ETS? You could use PROC EXPAND (<A href="https://blogs.sas.com/content/iml/2016/01/27/moving-average-in-sas.html" target="_blank">https://blogs.sas.com/content/iml/2016/01/27/moving-average-in-sas.html</A>)</P> Wed, 29 Aug 2018 16:06:21 GMT https://communities.sas.com/t5/SAS-Programming/SAS-rolling-average-code-using-patient-claims-data/m-p/490901#M128596 cankrd 2018-08-29T16:06:21Z