order option in PROC FREQ to find out duplicate records
Page 1 of 1
order option in PROC FREQ to find out duplicate records
There is one option in proc freq called order which can be useful to find multiple occurring easily.
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;
order=freq option will arrange output or output dataset in descending order of frequency.
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;
order=freq option will arrange output or output dataset in descending order of frequency.
pallav- Posts : 98
Join date : 2012-03-14
Location : Ahmedabad
Similar topics
» MLF option added in Proc Report
» How to Transpose Data with Proc Transpose
» Collapsing across observations using proc sql
» Top 10 tips and tricks about PROC SQL
» Change in Proc Print Procedure
» How to Transpose Data with Proc Transpose
» Collapsing across observations using proc sql
» Top 10 tips and tricks about PROC SQL
» Change in Proc Print Procedure
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|
Mon Jun 10, 2013 2:57 pm by Admin
» SAS Enterprise Guide: Explore Data before you start Analysing
Mon Jun 10, 2013 2:53 pm by Admin
» Predictive Analytics
Fri May 31, 2013 3:30 pm by Admin
» Creating Frequency Report and Creating User Defined styles in SAS Add-In for Microsoft Office
Tue Oct 23, 2012 2:11 pm by pallav
» Prompted Reports in BI Dashboard
Thu Oct 11, 2012 4:54 pm by kushal
» Free SAS Webinar : Getting Started with SAS Hash Object
Wed Oct 10, 2012 6:08 pm by pallav
» Which SAS procedure changes the name of a permanent format for a variable stored in a SAS data set?
Tue Oct 02, 2012 12:47 am by rajin_kumar@yahoo.com
» What is written to SAS Log?
Tue Oct 02, 2012 12:39 am by rajin_kumar@yahoo.com
» SAS Portal and BI Dashboard: Customizing the Tabs
Tue Oct 02, 2012 12:33 am by kushal