Answer / gaurav gupta

SELECT DISTINCT statement in PROC SQL

Answer / xxx

proc sql;
select id where id(select id from tablename)group by id
having id>1;
quit;

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  

---

If money were no object, what would you like to do?

0 Answers   Oracle,

---

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,

---

What is the command used to find missing values?

0 Answers  

---

What data sets do you need to produce the report?

2 Answers   Novartis,

---

what is the difference between DUPKEY and NODUPKEY???

4 Answers   Cognizant, EXL,

---

What is the difference between an informat and a format. Name three informats or formats.

6 Answers  

---

How we can call macros with in data step? : sas-macro

0 Answers  

---

What do the sas log messages “numeric values have been converted to character” mean? What are the implications?

0 Answers  

---

How to convert .xls file into CSV format?

6 Answers   Quintiles,

---

if a program has some 1000 or more line and how to know whether the syntax of the particular code is correct without checking it manually

4 Answers   Accenture,

---

Explain data_null_?

0 Answers  

---