Hihi, anyone here understand and could share with me the solutions to resolve the below queries?   1) How to assign the number to the first "1" identified under "Active" variable by "Customer ID"? 2) How to produce the "Desired result" by identifying the first "1" and creating the column of "Desired Result" that captures the preceding 12 months observations?   Thank you so much for shedding the light for these ❤️         Period Customer ID Active Self-created Number Desired Result 201304 1 0   1 201305 1 0   1 201306 1 0   1 201307 1 0   1 201308 1 0   1 201309 1 0   1 201310 1 1 12 1 201311 1 0     201312 1 0     201401 1 0     201402 1 0     201403 1 0     201404 1 0     201405 1 0     201406 1 0     201407 1 0     201408 1 1     201409 1 0     201410 1 0     201411 1 0     201412 1 0     201304 8 0     201305 8 0     201306 8 0     201307 8 0   1 201308 8 0   1 201309 8 0   1 201310 8 0   1 201311 8 0   1 201312 8 0   1 201401 8 0   1 201402 8 0   1 201403 8 0   1 201404 8 0   1 201405 8 0   1 201406 8 1 12 1 201407 8 1     201408 8 1     201409 8 0     201410 8 0     201411 8 0     201412 8 0     ... View more

Hi Is anyone here could share how to write the code to reflect the "Desired Results" as below?   I would like to have the blank field from "Membership_Type" to be replaced by number from the next following month with available data.   Truly appreciate if anyone could shed the light on this question. Thank you so much!   YYYYMM Customer Membership_Type Desired Results 201712 1 1100 1100 201801 1 1100 1100 201802 1 1100 1100 201803 1 1100 1100 201804 1 . 2200 201805 1 . 2200 201806 1 . 2200 201807 1 . 2200 201808 1 . 2200 201809 1 . 2200 201810 1 . 2200 201811 1 2200 2200 201812 1 2200 2200 201901 1 2200 2200 201712 3 . 3000 201801 3 . 3000 201802 3 . 3000 201803 3 . 3000 201804 3 . 3000 201805 3 . 3000 201806 3 3000 3000 201807 3 3000 3000 201808 3 3000 3000 201809 3 3000 3000 201810 3 3000 3000 201811 3 3000 3000 201812 3 3000 3000 ... View more

Hi Is anyone here could share how to write the code to reflect the results "Active Status" as below?   I would like to have a field to reflect whether the customer is still active based on the subscription term ( month).   For example, when the subscription term is 24 months, the active status will be flagged as "Y" for the next 23 months.   Really really appreciate if anyone could shed the light on this question. Thank you so much!   YYYYMM Customer Subscription Term Active Status 201712 1 1 Y 201801 1 3 Y 201802 1 24 Y 201803 1   Y 201804 1   Y 201805 1   Y 201806 1   Y 201807 1   Y 201808 1   Y 201809 1   Y 201810 1   Y 201811 1   Y 201812 1   Y 201901 1   Y 201902 1   Y 201903 1   Y 201904 1   Y 201905 1   Y 201906 1   Y 201907 1   Y 201908 1   Y 201909 1   Y 201910 1   Y 201911 1   Y 201912 1   Y 202001 1   Y 201712 3     201801 3     201802 3     201803 3 6 Y 201804 3   Y 201805 3   Y 201806 3 7 Y 201807 3   Y 201808 3   Y 201809 3   Y 201810 3   Y 201811 3   Y 201812 3   Y 201901 3     201902 3     201903 3     201904 3     201905 3     201906 3     201907 3     201908 3     201909 3     201910 3     ... View more