topic Re: basic problem in SAS Programming

basic problem

hchan10 — Sat, 03 Feb 2018 16:46:15 GMT

can some one help me with the code for this problem ?

data trans;
input CustomerID transactiondate$ 10. amount category$;
cards;
9801234 10/01/1998 123.98 toys
9802234 12/10/1997 80.34 books
9802234 12/10/1997 100.00 apparel
9805556 08/01/1996 22.90 toys
9805556 09/10/1996 25.50 apparel
9805556 10/11/1996 18.90 books
9801134 11/11/1999 12.11 toys 
;
run;

Total and average amount spent by category

Which category has the highest average purchase
What is the average number of categories that customers purchase
What is the average and total amount by customer
What is the average number of days between purchases (as of today)

Re: basic problem

Norman21 — Sat, 03 Feb 2018 17:14:38 GMT

What code have you written?

Re: basic problem

PaigeMiller — Sat, 03 Feb 2018 17:35:16 GMT

For numbers 1, 2 and 3, use PROC SUMMARY.

Re: basic problem

Reeza — Sat, 03 Feb 2018 20:38:04 GMT

Here are some tutorial video's that will help you answer your question:

http://video.sas.com/detail/videos/sas-analytics-u/video/3306906230001/summary-statistics-using-sas-studio?autoStart=true&page=1

http://video.sas.com/detail/videos/sas-analytics-u/video/4573023399001/creating-a-new-column-in-sas?autoStart=true&page=0

@hchan10 wrote:

can some one help me with the code for this problem ?
data trans;
input CustomerID transactiondate$ 10. amount category$;
cards;
9801234 10/01/1998 123.98 toys
9802234 12/10/1997 80.34 books
9802234 12/10/1997 100.00 apparel
9805556 08/01/1996 22.90 toys
9805556 09/10/1996 25.50 apparel
9805556 10/11/1996 18.90 books
9801134 11/11/1999 12.11 toys 
;
run;
Total and average amount spent by category

Which category has the highest average purchase

What is the average number of categories that customers purchase

What is the average and total amount by customer

What is the average number of days between purchases (as of today)