topic Re: Checking for multiple numbers in SAS Procedures

Checking for multiple numbers

Wouter — Mon, 28 Jul 2008 16:56:23 GMT

Hi all!

Should be a simple task, but I don't get the code right...

I want to know (and FLAG) if a record contains a 1 time number or if there are other records with the same number. So I've got a dataset like:

1 text
2 text
2 text
3 text
4 text
4 text
4 text

I want to create a 'FLAG', so I know a number appears more than once in the dataset. The outcome should be something like:

1 text 0
2 text 1
2 text 1
3 text 0
4 text 1
4 text 1
4 text 1

Can anyone help me with this? Thanks!!

Re: Checking for multiple numbers

Olivier — Mon, 28 Jul 2008 18:26:39 GMT

Hi Wouter.
If your dataset is already sorted, what you can do is :
[pre]
DATA myData ;
SET myData ;
BY myVariable ;
IF NOT (FIRST.myVariable AND LAST.myVariable) THEN flag = 1 ;
ELSE flag = 0 ;
RUN ;
[/pre]
Regards
Olivier

Re: Checking for multiple numbers

Wouter — Wed, 30 Jul 2008 14:22:04 GMT

Thanks! Works perfectly! Should have thought of myself...!