Hi, Recently I came across an article 'Best Practices for Migrating SAS Code to Leverage CAS' - Page 43 that says we can use Order By in Proc Fedsql and running on CAS. proc fedsql sessref=casauto;
create table baseball_desc as
select distinct a.*
from baseball a
order by team DESC;
quit; I tried and got error msg saying this is not supported. ERROR: Unsupported operation in FedSQL query: ORDER BY.
ERROR: The action stopped due to errors.
ERROR: The FedSQL action was not successful. I searched the net and found many examples for emulating proc sort or to run order by in proc sql before uploading the ordered data to CAS. What are the options for doing sorting in CAS? Thanks, Will
... View more