Keshan, Thank you so much for your help.  One more thing I really need your kind help. I try to import the sample file (attached in my original post) into SAS but failed.   Could you please let me know what's wrong are my codes?  Thanks a lot. ---------------- Codes I used ------------------ data work.mydata       infile 'C:\SAS\Output\Customer Sample.csv';       informat Custom $10.;       informat Gender $10.;       informat Product $10.;       informat Payment $10.;       input             Custom $             Gender $             Product $             Payment $ run; proc contents data=work.mydata; run; ---------------------------------- ---------- Error message --------- ERROR: No DATALINES or INFILE statement. ERROR: Extension for physical file name "C:\SAS\Output\Customer Sample.csv" does not correspond        to a valid member type. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.MYDATA may be incomplete. When this step was stopped there were 0          observations and 5 variables. WARNING: The data set WORK.INFILE may be incomplete. When this step was stopped there were 0          observations and 5 variables. WARNING: Data set WORK.INFILE was not replaced because this step was stopped. --------------------------------------------- ... View more

Keshan, That's great!   Thank you so much for your time and effort. ... View more

It works!  Thanks lot.... ... View more

Keshan, Thank you for your reply.  I run your codes and realize that customers who purchase both A and B are counted twice.  Do you know how to fix it?  Thanks in advance. ... View more

Hello data_null_, I try to generate a crosstab output but failed.  I searched online but still cannot figure out what's wrong?  Please help me out.   Thanks... ----------------------- Codes I added --------------- proc tabulate data=have2; class Purchase gender payment; table Purchase, gender*payment; /*output out=counts;*/ run; proc print;    run; ------------------------------------------------------------- ------------------ Error message I got ------------ ERROR: Variable Purchase in list does not match type prescribed for this list. ------------------------------------------------------------- ... View more

Thank you very much for your time and help....I really appreciate it... ... View more

Hello data_null_, Thank you so much for your reply.   Since I am a beginner of SAS, could you please show me how to load my attached sample data into your codes and run them? In addition, could you please explain a little more about your following codes?  Thanks very much for your time and help ------------------------------- data have2;    set have2;    length Purchase $2;    Purchase = cats(a,b);    drop _name_ a b;    run; ------------------------------- ... View more

Hello Reeza, Thank you very much for you reply.  Attached is the expected output (I manually count them) based on the sample data I attached in my original post.   Could you please help me out?  Thanks a lot! Female Male Credit Card Cash Credit Card Cash Purchase A only 0 2 0 2 Purchase A and B 2 0 0 2 Purchase B only 1 0 2 0 ... View more