Freq order option

From sasCommunity

Q: How can I see if I have multiple occurrences of identifer variables?

Use Proc Freq order = freq to find multiple occurrences.

PROC Freq data   = SAShelp.Class
          order  = freq;
          tables   Height
                 / list missing noprint
             out = Work.Freq;
Proc Print data  =  Work.Freq
          (where = (Count ge 2));
run;

See also:

• http://www.sascommunity.org/mwiki/images/1/14/FreqName.sas
• Getting_highest_and_lowest_values
• SmryEachVar_A_Data_Review_Suite uses this trick

--macro maven == the radical programmer 11:10, 14 November 2008 (EST)