Prev: Use %like in a dataset
Next: how to FTP a pure XLS file to MAINFRAME and do PROC IMPORT
From: "NOMAIL Roger S. Clark" on 5 Jan 2010 10:38
oops! I'm in too much of a hurry. Dataset b is the fields dataset, not a.
you should change a.* to b.* to accomplish what I understood that you were
asking. Like this

proc sql ;

create table want as select b.* from param1 as a, fields1 as b
where a.param1 eq b.field1 and a.param2 eq b.field2 and a.param3 eq
b.field3 ;
quit ;


>Hi, Laika;
>
>It sounds like proc sql might help, here.
>
>Assume you have param1, param2, and param3 as parameters on dataset param1
and field1, field2, and field3 in dataset fields1 that you want to match
>on. Maybe dataset fields1 also has more variables besides fields 1 - 3.
>
>Then this code should work.
>
>proc sql ;
>
>create table want as select a.* from param1 as a, fields1 as b
> where a.param1 eq b.field1 and a.param2 eq b.field2 and a.param3 eq
b.field3 ;
>quit ;
>
>
>
>>Date: Tue, 29 Dec 2009 07:16:28 -0800
>>From: laika <michel.verheyen(a)AXA.BE>
>>Subject: Lookup in another dataset.
>>
>>Hi,
>>
>>I have a sas-dataset with parameters. Is it possible to read data from
>>another dataset and look if there is in the parameter-dataset an
>>agreement with certain fields. Only then accept the record. A merge in
>>not possible.
>>
>>Tx

Thanx,
Roger S. Clark
Address Products Management Branch
763-9177 4H584U
 | 
Pages: 1
Prev: Use %like in a dataset
Next: how to FTP a pure XLS file to MAINFRAME and do PROC IMPORT