|
PMFJI, but the IN-vars are Boolean; can't be missing.
At 12:18 AM 12/6/2001 +0100, Eckhardt, Michael wrote:
>Brillant idea,
>but it may be necessary to improve the code by using the SUM-Function
>instead of addition, as I am afraid the standard addition of missing values
>may deliver missing value as a result while the SUM function interpretes
>missing values as zero.
>
>Mit freundlichen Grüßen
>Best regards
>
>Michael Eckhardt
>Berater Business Intelligence
>T-Systems ITS GmbH
>GS FDL Mitte
>Frankfurter Str. 27
>
>65760 Eschborn
>Tel. (06196) 961-530
>Fax (06196) 961-517
>
>Michael.Eckhardt@t-systems.de
>
>
>
>
>
>-----Ursprüngliche Nachricht-----
>Von: Dorfman, Paul [mailto:Paul.Dorfman@BCBSFL.COM]
>Gesendet: Mittwoch, 5. Dezember 2001 22:57
>An: SAS-L@LISTSERV.UGA.EDU
>Betreff: Re: merge with 4 datasets and create a count variable
>
>
>Max,
>
>Try this concept:
>
>data ... ;
> merge ds1(in=ds1) ds2(in=ds2) ds3(in=ds3) ds4(in=ds4) ;
> by key ;
> count = ds1 + ds2 + ds3 + ds4 ;
>run ;
>
>Kind regards,
>==================
>Paul M. Dorfman
>Jacksonville, FL
>==================
>
> > -----Original Message-----
> > From: Max F [mailto:max8ca@YAHOO.COM]
> > Sent: Wednesday, December 05, 2001 4:34 PM
> > To: SAS-L@LISTSERV.UGA.EDU
> > Subject: merge with 4 datasets and create a count variable
> >
> >
> > Hello,
> >
> > Someone please help.
> >
> > I have a list of ids. I want to check this list agaist
> > four datasets.
> > If a given id exists in all four datasets, the new
> > variable COUNT is '4',
> > and so on. If a given id does not exist in any
> > dataset, COUNT is '0'.
> > I know how to do this using a number of data steps,
> > but I think there must
> > be a more efficient way to do this. Your help is
> > highly appreciated.
> >
> > Max
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Send your FREE holiday greetings online!
> > http://greetings.yahoo.com
> >
> >
>
>
>Blue Cross Blue Shield of Florida, Inc., and its subsidiary and
>affiliate companies are not responsible for errors or omissions in this
>e-mail message. Any personal comments made in this e-mail do not reflect the
>views of Blue Cross Blue Shield of Florida, Inc.
------------------------------------------------------------
William W. Viergever Voice : (916) 483-8398
Viergever & Associates Fax : (916) 486-1488
Sacramento, CA 95825 E-mail : wwvierg@attglobal.net
------------------------------------------------------------
|
