CTE expressions

[Sanjeevas]

What is the alternative approach to use common table expressions in proc sql

[Kurt_Bremser]

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.