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.

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

I need to find the numeric field which contains blank in between..Ex:123 456...there is blank in between the 123 456..I need to know if there is any SAS function to find a field.. Please suggest...

5 Answers   TCS,

---

For what purposes have you used sas macros? : sas-macro

0 Answers  

---

what is the difference between proc means and proc tabulate?

3 Answers   Cognizant, CTS,

---

% let A=3+4 what is result

4 Answers   Satyam,

---

if we dont want to print output what we have to do..???give syntax..???

8 Answers   Accenture, GSK GlaxoSmithKline,

---

What is shift table? have you ever created shift that?

2 Answers   Accenture, Clinical Research, Quintiles,

---

Describe how you would pass data to macro.

3 Answers  

---

If a variable contains letters or special characters, can it be numeric data type?

0 Answers  

---

To what type of programms have you used scratch macros?

0 Answers   Novartis,

---

how to delete the duplicate columns permanently in SQL

2 Answers   Satyam,

---

Hi , which book should i refer to for preaparing SAS statistical Exam. Searched a lot on books but still did n't find relevant books

2 Answers  

---

i have a null dataset with 20 variables. i want to upload the variables which contain name like a or k or anything in another dataset.how can we create the dataset?

3 Answers   L&T,

---