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 ';'
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.