About jtpalpillai

jtpalpillai · ‎11-27-2020

Thanks a lot for your time! Sorry if I wasn't clearer earlier; I am new to this whole field of coding. So basically I want to find the line items ( eg.SAU-Chief-Level4-Regional-Brazil ) which has atleast one instance where there is a growth rate of more than 70% between two quarters. So ideally, if there is a >70% growth btwn Q3 and Q4 of SAU-Chief-Level4-Regional-Brazil , then the output must be something like: Q3 Q4 SAU-Chief-Level4-Regional-Brazil 119 145 and such line items must be exported (proc export) as an excel output, where any line item with atleast one instance of >70% grwth must be filtered and exported.

jtpalpillai · ‎11-26-2020

Hi, I wanted to calculate the growth rate between two quarters and then pull out rows which have a growth rate less than the given threshold ( say, 70%), into a new dataset. The data is like this: Name Desig. Level Area Country Q1 Q2 Q3 Q4 Q5 ABU Manager Level3 Global UAE 100 109 111 106 121 SAU Chief Level4 Regional Brazil 98 106 119 145 191 Whichever quarter and line item that violates the threshold must be pulled out and saved in another dataset, like: Name Desig. Level Area Country Q3 Q4 SAU Chief Level4 Regional Brazil 119 145

Re: How do I Calculate growth rate and filter out values which fall be...

How do I Calculate growth rate and filter out values which fall below ...

Re: How do I Calculate growth rate and filter out values which fall be...

How do I Calculate growth rate and filter out values which fall below ...