|Date: ||Mon, 5 Feb 1996 00:13:14 GMT|
|Reply-To: ||Aswin Bouwmeester <A.Bouwmeester@INTER.NL.NET>|
|Sender: ||"SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>|
|From: ||Aswin Bouwmeester <A.Bouwmeester@INTER.NL.NET>|
|Organization: ||Inter.NL.net, The Internet Provider in The Netherlands.|
|Subject: ||Re: Subsetting SAS Dataset with SCL Lists|
Chris Roper <ROPER%VTVM1.BITNET@VTBIT.CC.VT.EDU> wrote:
>I've been scratching my head on this one and I am sure someone out there has
>faced a similar problem, and I'm hoping they would share their solution.
>The problem: SAS 6.11, FRAME application,
>I've got an SCL list of names, which can vary in size, that I want to use to
>subset a SAS dataset, such that if the SCL list contains the names 'CHARLIE'
>'BOB' and 'LISA', I want to retrieve the observations from the SAS dataset
>which contain those names.
>I've tried using SCL arrays, and haven't had much luck, especially since SCL
>doesn't support implicit arrays(remember the list length varies and I don't
>know ahead of time how large the list will be).
>Any help on this snowbound day would be greatly appreciated!
>Lotus Biochemical Corp.
The solution to your problem is to create a WHERE clause using the SCL
list. In the following example a datastep is used to show this:
SET source(WHERE=(varname IN(
DO item=1 TO LISTLEN(list);
IF item>1 THEN woord=', '|| word;
Hope this is what you needed,