|
Hi,
I have few code in datasteps as shown below. Can somebody give me an
equivalent code in PROC SQL, to imitate the following.
Thanks
Hari
********************************************
DATA MERGED ;
SET NEW2 NEW3 NEW4 NEW5 ;
RUN ;
DATA RS2 RS3 RS5 RSP ;
SET MERGED ;
IF RS_STUDY='2' AND PRODUCT_CODE IN ('H','G') THEN OUTPUT RS2 ;
IF RS_STUDY='3' AND PRODUCT_CODE IN ('H','G') THEN OUTPUT RS3 ;
IF RS_STUDY='5' AND PRODUCT_CODE IN ('H','G') THEN OUTPUT RS5 ;
IF RS_STUDY='6' AND PRODUCT_CODE IN ('H','G') THEN OUTPUT RSP ;
RUN ;
*********************************************
| 
