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
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.
---------------------------------------------
data work.mydata ;
you missed ';'
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.