topic required output in SAS Programming

required output

Aexor — Sat, 08 May 2021 19:46:53 GMT

Hi I have below table A , and i want to o/p table B

input

Table A

Bank Currency

ICICI USD,INR,EURO

output

Table B

Bank Currency

ICICI USD

ICICI INR

ICICI EURO

Re: required output

PaigeMiller — Sat, 08 May 2021 20:13:10 GMT

data have;
    bank='ICICI';
    currency_all='USD,INR,EURO';
run;

data want;
    set have;
    do i=1 to countw(currency_all,',');
        currency=scan(currency_all,i,',');
        output;
    end;
    drop i currency_all;
run;