Generate Crosstab in SAS

[Ksharp]

There is one thing I am worried about.

Judu  Female   A  Credit Card

Judu  Female   B  Cash

what you are going to count ?

Xia Keshan

[qazwsxedc]

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.

---------------------------------------------

[Ksharp]

data work.mydata ;

you missed ';'