Hi Bnarang, What kind of nested conditions are specified in these datasteps that you want to include in your proc sql ? I think you might simply add them under the 'where' or 'having' clause, depending whether their scope is simple or aggregated data. Proc sql;    Create Table temp as    Select acct     from A     where acct in (Select acc from B where <condition on table B>)         and <condition on table A>; Quit; Kind regards, Florent ... View more

Thanks Reeza!!! ... View more

Thanks for reply. It makes lot of sense first analyse your input data with basic procedures like freq and univariate before blindly processing them. Thanks ... View more

Exactly what I need. Thank you. ... View more

So you're saying the following returns 4 records with all -8 for qty? PROC SQL; CREATE TABLE WORK.PTNT_PAYOR AS      SELECT DISTINCT E.SPCLTY_PHMCY_PHMCY_ID,      E.RX_RX_NB AS PRESCRIPTION_NUMBER,      E.PTNT_ID AS PATIENT_ID,           E.ORDR_DTL_DRUG_DSPNS_QTY,      UPCASE(E.PRODUCT_DESC_1) AS PRODUCT_DESC     FROM SASUSER.SPCLTY_PTNT_DETAIL E        WHERE E.PAYOR_LVL_1_LOW_ID IN('IBMSHAZ1C','PENNSPA2C','NQR-NQRH','WELLSFA1C','FEPPBM01C') and e.ptnt_id='ADACI61' ORDER BY E.SPCLTY_PHMCY_PHMCY_ID, E.PTNT_ID; QUIT; ... View more

Thanks a lot Bhpinder for the great input. ... View more

Tom, Thank you very much. It works perfectly. ... View more

Thank you so much. Finally, I succeeded to import the data with your help. Have a good day! ... View more

Thank you so much Linlin. I did not know about call symputx. It's  such a great place to learn. ... View more

Hi Cynthia Thank you so much for such detailed explanation. I am very thankful to you. Regards ... View more