topic Re: baseline excluding records in SAS Procedures

baseline excluding records

michtka — Thu, 26 Apr 2012 15:16:09 GMT

Hi guys, i've got the next dataset, and I would like to generate a dataset excluding the records with only baseline,

how can i do it?

subjid cpevent
10001 baseline

10001 w1

10001 w2

10001 w3

10001 w4

10002 baseline

10003 baseline

10003 w1

10004 baseline

10004 w1

10004 w2

thanks.

Re: baseline excluding records

Doc_Duke — Thu, 26 Apr 2012 15:20:41 GMT

just a subsetting IF

IF cpevent='baseline';

in the DATA step.

Re: baseline excluding records

Haikuo — Thu, 26 Apr 2012 15:26:30 GMT

Quick and dirty approach:

data have;

input (subjid cpevent) (:$);

cards;

10001 baseline

10001 w1

10001 w2

10001 w3

10001 w4

10002 baseline

10003 baseline

10003 w1

10004 baseline

10004 w1

10004 w2

;

proc sql;

select * from have

group by subjid

having sum(cpevent ne 'baseline')>0;

quit;

Regards,

Haikuo

Re: baseline excluding records

Haikuo — Thu, 26 Apr 2012 15:33:34 GMT

For a datastep approach, it seems to me 2X DOW could be the simplest:

data want;

flag=0;

do until (last.subjid);set have;by subjid;if cpevent ne 'baseline' then flag=1;end;

do until (last.subjid);set have;by subjid;if flag=1 then output;end;

run;

Regards,

Haikuo

Re: baseline excluding records

Jagadishkatam — Thu, 26 Apr 2012 15:43:27 GMT

Hi,

Please try the below code.

data exceptbaseline;

input subjid cpevent$;

if lowcase(cpevent)='baseline' then delete;

cards;

10001 baseline

10001 w1

10001 w2

10001 w3

10001 w4

10002 baseline

10003 baseline

10003 w1

10004 baseline

10004 w1

10004 w2

;

run;

Re: baseline excluding records

michtka — Thu, 26 Apr 2012 15:50:52 GMT

DC_Duke, is not right because with that condition I remove all the records with the baseline, and I dont want that,

I want the record that have (baseline and active treatment), excluding only the records with baseline and not active records after that.

Re: baseline excluding records

michtka — Thu, 26 Apr 2012 15:52:25 GMT

Jagadis...is not right, check my discussion with Duke.

Re: baseline excluding records

Haikuo — Thu, 26 Apr 2012 16:00:25 GMT

Hi Michtka,

I can see clearly why Doc and Jagadishkatam were going that way. I choose not doing the same only hinted by your word 'with only baseline'. So maybe next time you could lay out the exact output you wanted on top of your input data set and rules, then it would be a lot easier for others to understand your issue dead on and you will get what you need more efficiently. You know, the last thing you want when asking a question is to let others having questions upon what exactly you are asking.

Regards,

Haikuo

Re: baseline excluding records

michtka — Thu, 26 Apr 2012 16:13:51 GMT

Sorry, I'll be more clear next time...thanks.