Provide step by step solutions using sas enterprise command steps and columb combinations $($i$.$e$.$ to calculate revenue combine $...$ and use $...$command$/$formula$)$ to solve these questions

Clean the data of all records with missing information.

Compute the RFM segmentation.

Use transactional level data $($Independent option$)$

Choose appropriate variables

Choose $4$X$4$X$4$ binning

Please submit your answers and EG project before midnight on the December

$2^{nd.}.$

Please state the rfm naming convention i$.$e$.$ The best group being the most

recent, highest transaction amount, and most recent would appear as $\text{'}444\text{'}$

with the least favoured group will be $\text{'}111.\text{'}$

estions

How many accounts$/$customers in the most recent, most frequent, highest

monetary group? $(2$ marks$)$

What is the total spend of the $444,443,434,344$ combined $(2$ marks$)?$

How much more total revenue is there between the highest and the lowest

$444$ vs $111?(2$ marks$)$

What is the percentage of revenue from the from each group for the East

Region? $(4$ marks$)$

Is there a particular store that has a higher concentration of "best customers"?

$(4$ marks$)$

Does the best groups buy more of certain products than the least favoured

group? $(4$ marks$)$

In terms of total revenue per segment per year, what is the trend for the best

group versus the least favourable group? Are sales increasing over time or