Hello,   I have a large data set with customer IDs and daily cumulative usage readings. I'm looking to calculate the daily usage per customer from the cumulative usage and add it as a variable in the data set. Any suggestions on how to even begin doing this? Thank you!   HAVE ID date cumulative_reading 1 10/1/19 100 1 10/2/19 150 1 10/3/19 200 2 10/1/19 100 2 10/2/19 500 2 10/3/19 900 WANT ID Date Cumulative_reading Daily Usage 1 10/1/19 100 50 1 10/2/19 150 50 1 10/3/19 200 2 10/1/19 100 400 2 10/2/19 500 400 2 10/3/19 900   ... View more

Hello!   I have 2 sets of data in SAS Studio. The 1st data set has basic customer information (customer ID, city, state, etc...) and the 2nd data set has a listing of transaction by each customer. I need to append the customer data to the transaction data using the customer ID. I've tried using the merge function, but it then narrows down the transaction information down to 1 observation.   data transactions; set CD8940.transaction_data; run; data customer_info; set CD8940.customer_info; run; data merged; merge transactions customer_info; run; Any help is greatly appreciated! ... View more