Transform Data

SASPhile — Thu, 30 Aug 2018 15:51:04 GMT

How to transform the below from

id   BU
1    Credit
2    Credit,Debit
3    Credit,Debit,Giftcard

To below:
id    BU
1    Credit
2    Credit
2    Debit
3    Credit
3    Debit
3    Giftcard

Re: Transform Data

ballardw — Thu, 30 Aug 2018 15:57:57 GMT

The basic approach I would take would be along these lines:

data want; 
   set have (rename=(bu=buold));
   do i=1 to countw(buold);
      bu = scan(buold,i);
      output;
   end;
   drop i buold;
run;

It would likely be a good idea to set a length for the BU variable to longest expected value but I don't know what that might be so leave it up to you.

topic Re: Transform Data in SAS Programming

Transform Data

Re: Transform Data