Answer / chandrakanth

proc sql;
create table dataset-name as select distinct(variable-name),list-all-the-variables-you-want from dataset-name;
quit;

please let me know if you have any questions

Answer / naveen

data aaa;
input P_Id LastName $ FirstName $ City $;
cards;
1 Hansen Ola Sandnes
2 Svendson Tove Sandnes
3 Pettersen Kari Stavanger
;
run;
proc sql;
select distnict(city)
from aaa;
quit;

What statement do you code to tell SAS that it is to write to an external file?

5 Answers  

---

how do we get duplicate observations in a separate dataset?

6 Answers   CitiGroup,

---

how we can create optional or required parameters in SAS macro...

5 Answers   TCS,

---

How can you put a "trace" in your program?

2 Answers   Quintiles,

---

Why and when do you use proc sql?

0 Answers  

---

what is the purpose of _error_? : Sas programming

0 Answers  

---

How would you include common or reuse to be processed along with your statements?

0 Answers  

---

What are the default statistics that proc means produce?

0 Answers  

---

If a variable contains only numbers, can it be a character data type?

0 Answers  

---

How to save the log information in a file for future use

2 Answers   HCL,

---

Describe crosslist option in tables statement?

0 Answers  

---

What are the difference between ceil and floor functions in sas?

0 Answers  

---