Search
 
 

Display results as :
 


Rechercher Advanced Search

Keywords

Affiliates
free forum


Proc sort procedure now with additional options

View previous topic View next topic Go down

Proc sort procedure now with additional options

Post  pallav on Mon Mar 26, 2012 2:51 pm

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

pallav

Posts : 98
Join date : 2012-03-14
Location : Ahmedabad

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum