topic Re: Retain statement in SAS Programming

Retain statement

robertrao — Thu, 06 Dec 2012 17:24:21 GMT

Hi Team,

For a particular patient there might be many procedures done.But I want to eliminate the duplicates of the same procedure if any.......

patient proc_code

101 CPT

101 SPT

101 OMT

I want:

patient proc_code

101 CPT

101 SPT

101 OMT

Regards

Re: Retain statement

Linlin — Thu, 06 Dec 2012 18:17:31 GMT

one way:

data have;

input patient proc_code $;

cards;

101 CPT

101 SPT

101 OMT

;

proc sort data=have out=want nodupkey;

by patient proc_code;

run;

proc print;run;

Re: Retain statement

robertrao — Thu, 06 Dec 2012 19:44:54 GMT

Hi,

Thanks so much...is there any way i can use this with out the nodupkey??

maybe retain

Regards

Re: Retain statement

Linlin — Thu, 06 Dec 2012 19:49:00 GMT

I don't think you can do it by retain.

another way:

data want;

set have;

by patient proc_code notsorted;

if last.proc_code;

proc print;run;

Re: Retain statement

robertrao — Thu, 06 Dec 2012 21:35:45 GMT

Hi,

What is notsorted?is it an option?

Whats the use of it?could you please explain

Regards

Re: Retain statement

PGStats — Thu, 06 Dec 2012 22:28:57 GMT

Notsorted means just that: the data is not sorted. But you want first. and last. automatic variables to reflect every change in the sequence anyway, as if it was sorted. - PG

Re: Retain statement

joehinson — Thu, 06 Dec 2012 23:48:47 GMT

-----yet another way:

data have;

input patient proc_code $;

cards;

101 CPT

101 SPT

101 OMT

;

run;

data _null_;

if(1=2)then set have;

declare hash prc(dataset:"have",ordered:"a");

rc=prc.defineKey("patient","proc_code");

rc=prc.defineDone();

rc=prc.output(dataset:"want");

run;

Re: Retain statement

Ksharp — Fri, 07 Dec 2012 02:31:37 GMT

select distinct * from have ;

Re: Retain statement

Haikuo — Fri, 07 Dec 2012 02:54:02 GMT

Joe, I have to ask, Is there a particular reason you choose to use 'if (1=2)' instead of 'if 0', since (1=2) would always be 0? Haikuo

Re: Retain statement

robertrao — Fri, 07 Dec 2012 06:18:29 GMT

Hi,

This code still has duplicates of patient and proc_code.Do not know the reason.but they are intermingled with other data.

I think it is good for me to follow the nodupkey

Regards

Re: Retain statement

joehinson — Fri, 07 Dec 2012 14:48:39 GMT

Aha, Hai.Kuo the observant one!

IF(0) versus IF(1=2): I'm still brainstorming for suitable answers:

(1) "Different strokes for different folks (like CARDS vs DATALINES)".

(2) "Less mystifying to FORTRAN programmers".

(3) "Better understood by SAS debutantes".

(4) "Personal signature. (if you see that on planet Mars, then you know I'm there)"

(5) "Just being a little mischievous, getting the processor to spend an extra nanosecond".

(6) "More palatable to the human Visual and Prefrontal cortices".

(7) "More mathematically appropriate".

(8) ?

(9) ?

- -

COULD THERE BE A CATCH?

See the link below:

http://www.math.toronto.edu/mathnet/falseProofs/first1eq2.html

Re: Retain statement

Haikuo — Fri, 07 Dec 2012 15:17:35 GMT

I like your answer, you made my day, Joe.:smileylaugh:

Haikuo