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

how to import HTML files into SAS datasets?

3 Answers   HP,

---

what is function of retain statment

0 Answers   PPD,

---

how to extract data from SAP servers? Is like oracle servers or any other methods to extract please reply me.

1 Answers  

---

In this question, I rename the numeric variable phone to numphone and then try use phone=put(numphone,comma16.) to store the numeric value numphone as a string value in phone. But I get a warning tha numphone already exists and in the data sat phone doesnt exist and numphone is set to missing. Why? data names_and_more; input Name $20. Phone : comma16. Height & $10. Mixed & $8.; Name = tranwrd(Name,' ',' '); rename phone = numphone; phone = put(numphone,comma16.); datalines; Roger Cody 9,087,821,234 5ft. 10in. 50 1/8 Thomas Jefferson 3,158,488,484 6ft. 1in. 23 1/2 Marco Polo 8,001,234,567 5Ft. 6in. 40 Brian Watson 5,183,551,766 5ft. 10in 89 3/4 Michael DeMarco 4,452,322,233 6ft. 76 1/3 ;

1 Answers  

---

what is portability of sas programmes?

2 Answers   Capital One,

---

Name statements that are recognized at compile time only?

3 Answers   Accenture,

---

how to read raw data in sas. Do it manually and throw the programming.

1 Answers   WNS,

---

What are the new features included in the new version of SAS Programming Language?

0 Answers  

---

What commands are used in the case of including or excluding any specific variables in the data set?

0 Answers  

---

For what purpose(s) would use the RETURN statement?

1 Answers  

---

here is a string like chq.2312244%4452- from that i want only special characters in a column. dont use compress. bcoz i have 1.2 billion of records.i want another process to find the values instant from the data.

2 Answers   Cap Gemini, L&T,

---

What is a put statement?

0 Answers  

---