Grimzarn

‎03-13-2023

Calcite | Level 5

Member since

1 Posts
0 Likes Given
0 Solutions
0 Likes Received

Follow Grimzarn

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

452

‎01-31-2023 06:57 AM

Activity Feed for Grimzarn

Posted Which months does new customers generate income? Transpose-help? on SAS Programming. ‎01-31-2023 06:57 AM

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?

Online Status	Offline
Date Last Visited	‎03-13-2023 06:45 AM