I have produced a range of PROC FREQ tables, and I would like them ordered in a particular way. For example, in the screenshot attached, I would like them ordered as: 'Agree, Somewhat Agree, Neither Agree nor Disagree, Somewhat Disagree, Disagree'. I know that I am able to order the observations based on alphabetical order, or frequency etc. but is there a way to order them completely customized? One thing I am thinking about doing is to rank the values : proc format; value $rank 'Agree' = 1 'Somewhat Agree' = 2 'Neither Agree nor Disagree' = 3; etc. etc. run; Then sort by Rank, and THEN do the proc freq and order by data (the order they appear)? But hoping there is a quicker workaround than doing that. Appreciate the guidance.
... View more