Hi, I have a problem when importing data from ACCESS table which takes multiple values.
One of the questions in the access form was:
What is (are) your favorite fruit? The coding of the answer are 1=Apple, 2=Orange, 3=Banana, 4=Melon, 5=Mango, 6=Strawberry. Respondents are allowed to choose all that applies, so if they pick more than one choice the data will be stored as 3,4,6 for example. However when I imported the database to SAS format, it only takes the first value (‘3’) but not whole value string (‘3,4,6’).
Please suggest what I need to do to fix it.
PROC IMPORT OUT= WORK.FruitData
DATATABLE= "Fruit Survey"
DBMS=ACCESS REPLACE;
DATABASE="&path\Fruit Survey.accdb";
SCANMEMO=YES;
USEDATE=NO;
SCANTIME=YES;
RUN;
PS. I am using windows SAS 9.2 TS2M3.
Thanks!
... View more