let ceral_id=2745 proc sql; select gr into :gr from maingro.cerals where ceral_id=&ceral_id; quit; proc sql; create table grocery2 as select tgr1,gr2,gr3,gr4 from maingro.Grocery where gr =&gr; quit. 2)from query of query builder selecting directly from maingro.Grocery table and filtering the passing value of gr. this will run faster then the above code. Thank you for your time
... View more
