You probably are having trouble with the step that is reading the text into a SAS dataset. To generate the two variable structure used in the solution you can mix list and formatted input modes. Read the lines using comma as a delimiter, but read the RESPONSE variable using a INFORMAT so that it ignores the commas and just reads the values. data response; infile CARDS dsd dlm=',' truncover; length store $20 response $60 ; input store response $60.; cards; Store 1,Bread, Eggs, Juice Store 2,Juice Store 3,Eggs, Juice ;;;; 732 data _null_; 733 set response ; 734 file log dsd ; 735 put store response ; 736 run; Store 1,"Bread, Eggs, Juice" Store 2,Juice Store 3,"Eggs, Juice"
... View more
