topic Re: Seperate Values From Observation in SAS Programming

Seperate Values From Observation

Son_Of_Krypton — Wed, 12 Jan 2022 13:31:02 GMT

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 — Wed, 12 Jan 2022 13:34:37 GMT

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

Son_Of_Krypton — Wed, 12 Jan 2022 14:02:31 GMT

How we can do without using do loop.??

ballardw — Wed, 12 Jan 2022 17:35:27 GMT

@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 — Wed, 12 Jan 2022 17:40:10 GMT

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

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