Since you are using SQL pass through, this is not a SAS question really. You should redirect this optimization inquire to forum specific for your source database. ... View more

But it does not work. could you please help me? No, we can't help you because "does not work" can mean anything. We need to see the log at least, please post it using the "insert code" function, 7th button above the textbox. ... View more