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 is intially documentation for a sas programmer?

2 Answers   Accenture,

---

how many types of MERGE?

17 Answers   CitiGroup,

---

what is data integration? : Sas-di

0 Answers  

---

What are the table names in oracle database...?

0 Answers   HSBC,

---

How do you add a prefix to some or all variables in a dataset using a SAS macro?

2 Answers  

---

Explain the main difference between the sas procedures and functions? : Sas-administrator

0 Answers  

---

what is hierarchy flattening? : Sas-di

0 Answers  

---

Name types of category in which SAS Informats are placed?

0 Answers  

---

what are system option ? give few examples ? what are dataset options and dataset statements ? if there is a keep option and keep statement ? which one is executed first ? Difference between a WHERE statement and IF statement ? what is the advantage of using WHERE statement option on the dataset ?

1 Answers   Satyam,

---

what is data governance? : Sas-di

0 Answers  

---

Does SAS ?Translate? (compile) or does it ?Interpret?? Explain.

10 Answers  

---

hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

0 Answers   Pfizer,

---