Environment: SAS Studio 9.4 PROC CORR data=have; var Y logY; with X_001-X_100; run; In working on a dataset with hundreds of variables, is there a way to sort the Pearson correlation coefficients with the response variable, 'y', in decreasing order through PROC CORR? Instead of sorting the output as X_001, X_002, ..., X_100 and their corresponding Pearson correlation coefficients, sort by the magnitude of coefficients. Several web searches have shown syntax such as 'DESCENDING' or 'RANK' but does not seem to work.
... View more
