Proc sort procedure now with additional options
Page 1 of 1
Proc sort procedure now with additional options
Every one might be aware that till SAS 9.2 we were able to remove the duplicate observations or duplicate records with PROC SORT procedure using options like NODUPKEYS or NODUPS.
Now in SAS 9.3 addition options are available like
NOUNIQUEKEY
checks for and eliminates observations from the output data set that have a unique sort key. A sort key is unique when the observation containing the key is the only observation within a BY group. An observation has a unique sort key when it is the only observation within a BY group.
NOUNIQUEREC
checks for and eliminates observations from the output data set that are adjacently unique. PROC SORT only writes to the output data set observations that it determines are not unique. For example, during output, observation B is compared to observation A that precedes it and then to observation C that follows it. If observation B has variable values that differ from observation A’s or observation C’s variable values, then observation B is considered unique and is not written to the output data set.
When the UNIQUEOUT= option is specified with NOUNIQUEREC, then unique observations are written to the data set specified by the UNIQUEOUT= option.
For more information
CLICK HERE
Now in SAS 9.3 addition options are available like
NOUNIQUEKEY
checks for and eliminates observations from the output data set that have a unique sort key. A sort key is unique when the observation containing the key is the only observation within a BY group. An observation has a unique sort key when it is the only observation within a BY group.
NOUNIQUEREC
checks for and eliminates observations from the output data set that are adjacently unique. PROC SORT only writes to the output data set observations that it determines are not unique. For example, during output, observation B is compared to observation A that precedes it and then to observation C that follows it. If observation B has variable values that differ from observation A’s or observation C’s variable values, then observation B is considered unique and is not written to the output data set.
When the UNIQUEOUT= option is specified with NOUNIQUEREC, then unique observations are written to the data set specified by the UNIQUEOUT= option.
For more information
CLICK HERE
pallav- Posts : 98
Join date : 2012-03-14
Location : Ahmedabad
Similar topics
» Change in Proc Print Procedure
» MLF option added in Proc Report
» New Procedure added to Base SAS 9.3
» Which SAS procedure changes the name of a permanent format for a variable stored in a SAS data set?
» Collapsing across observations using proc sql
» MLF option added in Proc Report
» New Procedure added to Base SAS 9.3
» Which SAS procedure changes the name of a permanent format for a variable stored in a SAS data set?
» Collapsing across observations using proc sql
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