topic Re: Splitting record into multiple records in New SAS User

Splitting record into multiple records

mona4u — Mon, 10 Dec 2018 16:23:52 GMT

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

Re: Splitting record into multiple records

PaigeMiller — Mon, 10 Dec 2018 16:52:00 GMT

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;

Re: Splitting record into multiple records

Reeza — Mon, 10 Dec 2018 16:43:34 GMT

@PaigeMiller missing an OUTPUT statement?

Re: Splitting record into multiple records

PaigeMiller — Mon, 10 Dec 2018 16:51:30 GMT

@Reeza wrote:

@PaigeMiller missing an OUTPUT statement?

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