Just bumping the thread. Any solution for this? ... View more

Something like this would help. Obviously I haven't filled all the cells. Would like the aggregated amount by customer for all weeks and months (even if there is no data in a given month/week etc.)   cust week _FREQ_ Total amount 1 1   40 1 2   60 1 3   30 1 4   40 1       1       1       1       1 52   20 2 1   40 2 2   60 2 3   30 2 4   40 2       2       2       2       2 52   20 until all cust       cust month _FREQ_ Total amount 1 1   40 1 2   50 1 3   30 1       1       1 12   30 2 1   40 2 2   30 2 3   40 2       2       2 12   30 until all cust     ... View more

Thanks. Is there a way to save a table for monthly/weekly data by "cust" for all weeks/months (regardless whether there is data or not)? This is so the table becomes a bit more standardized.  ... View more

Thanks. That helped in reading the data. Now I am trying to get to the original problem. It is giving error again. here is the code:   DATA Sample2; /*infile '/folders/myshortcuts/Data/test1.csv' dsd;*/ informat tdate date7.; format tdate date9.; input cust 1-1 @3 tdate date7. @11 amount; Datalines; 1 01Jan12 20 1 05Jan12 40 1 05Jun12 40 1 16Jul12 60 1 25Nov12 10 2 01Jan12 5 2 10Jan12 4 2 08Jun12 34 2 19Jul12 23 2 23Nov12 45 3 08Jan12 23 3 10Jan12 12 3 08Jun12 78 3 19Jul12 55 3 23Nov12 34 ; PROC PRINT DATA=Sample2; run; month=month(tdate); week=week(tdate,'v'); proc summary; class cust week month tdate; var amount; types cust*week cust*month cust*date; output out=stats mean=; run;   The errors I am getting are following. Checked the format of week, month etc. and they match. Do you find any issues. Thanks.          80 month=month(tdate); _____ 180   ERROR 180-322: Statement is not valid or it is used out of proper order.   81 week=week(tdate,'v'); ____ 180   ERROR 180-322: Statement is not valid or it is used out of proper order.   82 proc summary; 83 class cust week month tdate; ERROR: Variable WEEK not found. ERROR: Variable MONTH not found. 84 var amount; types cust*week cust*month cust*date; ERROR: Variable WEEK not found. ERROR: Variable MONTH not found. ERROR: Variable DATE not found. 85 output out=stats mean=; 86 run;   NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.STATS may be incomplete. When this step was stopped there were 0 observations and 0 variables. WARNING: Data set WORK.STATS was not replaced because this step was stopped. NOTE: PROCEDURE SUMMARY used (Total process time): real time 0.01 seconds cpu time 0.00 seconds ... View more

Thanks for the reply. Currently having some issues with reading date itself (relatively new to SAS though have done other languages). Below is the code I have. Output is given below. What should I do to get the date read correctly?   DATA Sample2; input cust 1-1 @3 tdate date7. @11 amount; Datalines; 1 01Jan12 20 1 05Jan12 40 1 05Jun12 40 1 16Jul12 60 1 25Nov12 10 2 01Jan12 5 2 10Jan12 4 2 08Jun12 34 2 19Jul12 23 2 23Nov12 45 3 08Jan12 23 3 10Jan12 12 3 08Jun12 78 3 19Jul12 55 3 23Nov12 34 ; PROC PRINT DATA=Sample2; run;   Here is the output: (The date does not even look like it is from that 1960 date) It is not even consistent. Any suggestions? Thanks.    cust   tdate   amount   1 1 18993 20 2 1 18997 40 3 1 19149 40 4 1 19190 60 5 1 19322 10 6 2 18993 5 7 2 19002 4 8 2 19152 34 9 2 19193 23 10 2 19320 45 11 3 19000 23 12 3 19002 12 13 3 19152 78 14 3 19193 55 15 3 19320 34 ... View more