Which months does new customers generate income? Transpose-help?

Grimzarn — Tue, 31 Jan 2023 11:57:24 GMT

Hi, I have the following dataset in Enterprise Guide:

"New_customers_amount" are the amount of new "customer_id" per "Yearmonth_start_date". "Accounting_period" are which months a "Customer_id" has generated revenue

data CLV;
  input Customer_id $ New_customers_amount Yearmonth_start_date $ Accounting_period
;
datalines;
11004345 71  202201 202201
11004345 71  202201 202202
11004345 71  202201 202203
11004345 71  202201 202204
88004686 71  202201 202201
88004686 71  202201 202202
88004686 71  202201 202203
11100257 71  202201 202201
11100257 71  202201 202202
12100557 71  202201 202201
12100557 71  202201 202202
75393716 58  202202 202202
75393716 58  202202 202203
26738388 58  202202 202202
26738388 58  202202 202203
;

I want to follow which months a new customer generate income for us. Here is the end result i am hoping for:

What do i do?

Re: Which months does new customers generate income? Transpose-help?

PaigeMiller — Tue, 31 Jan 2023 12:22:59 GMT

I honestly don't understand how the desired output is created from the input, or even what do you mean by Y1. I don't see any connection between the data you show and the output and the concept of "which months does new customers generate income"?

I need a lot more explanation and a lot more detailed explanation.

topic Which months does new customers generate income? Transpose-help? in SAS Programming

Which months does new customers generate income? Transpose-help?

Re: Which months does new customers generate income? Transpose-help?