Freq order option

From sasCommunity
Jump to: navigation, search

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;

The ORDER= option makes the identification of the duplicates easier by ordering the output by the most common values (of HEIGHT in this example).

See also:

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