Splitting record into multiple records

[mona4u]

Hi ALL, 

I have some issues with some of the records that I have. 

The stdt and ptnm have multiple values in the same row and I want to split the stdt and ptnm values in multiple records 

this is what I currently have

Prot

StID

SubID

CRFID

ISubID

PACN

RevTp

VstDt

VstID

AERef

PtNm

LltNm

StDt

A3921133

A3921133 1134

A3921133 1134 11341049

3409741

144893

H1604060

Consensus

09/Feb/2016

823129

2 Sequential AST or ALT >= 3x ULN,2 Sequential AST or ALT >= 3x ULN,Liver injury;

03/Mar/2016,14/Mar/2016,09/Feb/2016

the aimed result 

Prot

StID

SubID

CRFID

ISubID

PACN

RevTp

VstDt

VstID

AERef

PtNm

LltNm

StDt

A3921133

A3921133 1134

A3921133 1134 11341049

3409741

144893

H1604060

Consensus

09/Feb/2016

823129

2 Sequential AST or ALT >= 3x ULN

03/Mar/2016

A3921133

A3921133 1134

A3921133 1134 11341049

3409741

144893

H1604060

Consensus

09/Feb/2016

823129

2 Sequential AST or ALT >= 3x ULN

14/Mar/2016

A3921133

A3921133 1134

A3921133 1134 11341049

3409741

144893

H1604060

Consensus

09/Feb/2016

823129

Liver injury;

09/Feb/2016

[PaigeMiller · Accepted solution]

So assuming that the ptnm and stdt gets split on commas, you could do something like this:

/* UNTESTED CODE */
data want;
    set have;
    record=1;
    do while (not missing(scan(ptnm,record,',')));
        ptnm_new=scan(ptnm,record,',');
        stdt_new=scan(stdt,record,',');
        record=record+1;
        output;
    end;
    drop record ptnm stdt;
run;
        

[Reeza]

@PaigeMiller missing an OUTPUT statement?

[PaigeMiller]

---

@Reeza wrote:

@PaigeMiller missing an OUTPUT statement?

---

Yes, I was! But that has been corrected now. Thanks!