https://communities.sas.com/t5/SAS-Enterprise-Guide/CTE-expressions/m-p/845402#M41741 What is the alternative approach to use common table expressions in proc sql Mon, 21 Nov 2022 06:27:28 GMT Sanjeevas 2022-11-21T06:27:28Z https://communities.sas.com/t5/SAS-Enterprise-Guide/CTE-expressions/m-p/845402#M41741 What is the alternative approach to use common table expressions in proc sql Mon, 21 Nov 2022 06:27:28 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/CTE-expressions/m-p/845402#M41741 Sanjeevas 2022-11-21T06:27:28Z https://communities.sas.com/t5/SAS-Enterprise-Guide/CTE-expressions/m-p/845423#M41742 <P>You can use sub-selects, but often other methods are more practicable. It depends on the task at hand, so we would need to see your task definition.</P> Mon, 21 Nov 2022 07:59:35 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/CTE-expressions/m-p/845423#M41742 Kurt_Bremser 2022-11-21T07:59:35Z