| Date: | Wed, 30 Nov 2011 13:34:56 -0800 |
|---|
| Reply-To: | "Schwarz, Barry A" <barry.a.schwarz@BOEING.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | "Schwarz, Barry A" <barry.a.schwarz@BOEING.COM> |
|---|
| Subject: | Re: Merge/coding problem using index, find,
or some other SAS function (with have and need data) |
|---|
| In-Reply-To: | <1322597770.18298.YahooMailClassic@web161604.mail.bf1.yahoo.com> |
|---|
| Content-Type: | text/plain; charset="us-ascii" |
|---|
With only 361 observations in names, why not build an a 361 element array and populate it with the contents of this dataset. Then proceed to loop through drugs and for each observation test against the elements of the array, stopping at the first match or end of array, whichever occurs first.
> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Paul
> Miller
> Sent: Tuesday, November 29, 2011 12:16 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: Re: Merge/coding problem using index, find, or some other SAS
> function (with have and need data)
>
> Hi Joe,
>
> The first dataset has 9,110,746 rows. The second dataset has only 361
> rows.
|
