"What is the difference between proc sort nodup and proc
sort nodupkey?"
Answers were Sorted based on User's Feedback
Answer / chandrakanth
Proc sort nodupkey will remove any repeated observations based on by variable you mention in the proc sort, whereas proc sort nodup will remove all the repeated observation irrespective of the mentioned by variable . Hope this answers your question let me know if you need more details.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / venkatesh
nodup: it deletes duplicates(column wise duplicates).
nodupkey: it deletes row wise duplicates according to
your by variable;
ex: id name
100 nani
101 ravi
100 nani
101 kali
nodup result:
id name
100 nani
101 ravi
101 kali
nodupkey result
100 nani
101 ravi
| Is This Answer Correct ? | 0 Yes | 1 No |
what are some good sas programming practices for processing very large data sets? : Sas programming
Which is the best training institute for SAS in hyderabad.
112 Answers Stansys Software Solutions,
Under what circumstances would you code a SELECT construct instead of IF statements?
what has been your most common programming mistake? : Sas programming
1.How to draw pivot tables in Excel by using SAS and in which version we can use VB script for to draw pivot tables in Excel? Answer with example data. 2.What are the advantages of _NULL_ in Data steps? Can we use _NULL_ in Proc steps also? 3. How to call the macro variable into Data Steps? 4. Can we draw pivot tables in Excel using Proc SQL? Please post answers for the above questions with suitable examples, and how to use VB script for Excel using SAS.
what are several options for creating reports in web report studio? : Sas-bi
Name and describe three SAS functions that you have used, if any?
how to change the execute of macro
what is the basic structure sas administrator? : Sas-administrator
What versions of SAS have you used (on which platforms)?
What is proc sort?
Have you ever linked SAS code? If so, describe the link and any required statements used to either process the code or the step itself.