I’m so sorry about it. I’m a new user. Thank you for your suggestion. I’ll try to ask a better question next time. ... View more

Okay thank you. I have two questions about it and I thought it was different. Thank you so much for your help. ... View more

Thank you so much. It's working ... View more

thanks for your help. it's working so well. by any chance, do you know how to sort it ascending or descending? I want to sort it so that I will started with the highest revenue. And if you don't mind, is it possible if I want to try combine this two SQL run it? PROC SQL; CREATE TABLE buyerspent AS SELECT Buyer, sum('Price (RM)'n*unit) AS 'Total Spend (RM)'n FROM Payment GROUP BY Buyer; RUN; PROC PRINT DATA=buyerspent; TITLE 'Monarch Online Shop'; FOOTNOTE 'STAY AT HOME AND STAY SAFE'; RUN; PROC SQL; CREATE TABLE revenue AS SELECT 'Item ID'n, sum('Price (RM)'n*unit) AS 'Total Revenue (RM)'n FROM Payment GROUP BY 'Item ID'n; RUN; PROC PRINT DATA=revenue; TITLE 'Monarch Online Shop'; FOOTNOTE 'STAY AT HOME AND STAY SAFE'; RUN;   ... View more

here is my data. OrderID, Buyer, Price, Item, Unit, Courier are my variables. From this data, I have 12 buyers, I want to calculate the total amount spent by every buyer. ... View more

as you can see at Label, I put fee='Courier Fee (RM)'. how can I add another line of coding that consist of detail about the fee? for example, I have 2 couriers, PosLaju, and GDex with a different fee, 2MYR, and 3MYR, respectively. and how to add that into a function like this? i want to make it become if my first order is using PosLaju, so for the function below, fee become 2MYR net=after+fee;   ... View more

thank you for your help. I understand now what was my mistake. thanks for enlightening me. ... View more

Buyer that spent more than RM20 (excluding courier fee) will receive 5% discount, and buyer that spent more than RM30 (excluding courier fee) will receive 7% discount. Using SAS, calculate the net amount that the buyer needs to pay for that order (cost of item + courier fee). This is the question I got.   How can I make that if total=70, it only use either one of the statement? ... View more