I am trying to learn to use PROC TRANSPOSE. I have used a couple of Udemy SAS courses and they use the contents of SASHELP but somehow I'm missing something.   I have an Excel document with three fields: Date, Store, and Amount. The spreadsheet is a record of purchases made for a hobby I'm trying to make some money from. I buy t-shirts with interesting graphics, like concerts, and cut the graphic out. I wrap the graphic around an artists canvas or other frame so that it can be hung on  wall and take up less space than t-shirts would.    The PROC IMPORT is fine. The PROC SORT is fine. I sort on a field called 'Store' and there are multiple entries for purchases from some of the stores. There in lies my problem. I want to use PROC TRANSPOSE to make each store name a column and have columns for Date and each store. In each column I want the date and amount of a purchase. Ideally, I'd have a sum at the bottom for each store.   PROC TRANSPOSE complains about the duplicate entries for STORE.      ... View more