As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


Difference between revisions of "Tip of the Day:August 24"

From sasCommunity
Jump to: navigation, search
m (Scheduled Schedule SAS Programs with SYSTASK and WAITFOR)
(Scheduled Deduping using Proc Sort)
 
Line 5: Line 5:
 
sasCommunity Tip of the Day
 
sasCommunity Tip of the Day
 
</h1><div style="padding:10px;">
 
</h1><div style="padding:10px;">
{{Tips:Schedule SAS Programs with SYSTASK and WAITFOR}}
+
{{Tips:Deduping using Proc Sort}}
 
<div style="width:100%"><hr></div>
 
<div style="width:100%"><hr></div>
Feel free to [[Tips Talk:Schedule SAS Programs with SYSTASK and WAITFOR|comment]] on this tip.
+
Feel free to [[Tips Talk:Deduping using Proc Sort|comment]] on this tip.
 
</div>
 
</div>
 
</td></tr>
 
</td></tr>

Latest revision as of 19:42, 11 August 2010

sasCommunity Tip of the Day

You can easily deduplicate records based on specific keys using PROC SORT by using the NODUPKEY option. Please note that the deduplication only occurs for the keys defined and not for any other variables.

proc sort data = <data> nodupkey;
    by key1 key2 ... keyN;
run;


Submitted by Murphy Choy. Contact me at my Discussion Page.



Feel free to comment on this tip.


Prior tip - Next tip - Random Tip

Submit a Tip