Seperate Values From Observation

[Son_Of_Krypton]

Hi I have below dataset:

ID  Value

1    A,B,C

2    D,E,F,G,H

I want output as below:

ID  Value

1    A

1    B

1    C

2    D

2    E

2    F

2    G

2    H

Can somebody help me with this.??

[PaigeMiller · Accepted solution]

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

[Son_Of_Krypton]

How we can do without using do loop.??

[ballardw]

---

@Son_Of_Krypton wrote:
How we can do without using do loop.??

---

What is wrong with a loop? That is one of the basic tools for dealing with multiple similar items.

[PaigeMiller]

---

@Son_Of_Krypton wrote:
How we can do without using do loop.??

---

With great difficulty, if it even is possible at all.