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 are sas bi dashboard components? : Sas-bi

0 Answers  

---

How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?

0 Answers   Quintiles,

---

What are the main differences between sas versions 8.2, 9.0, 9.1?

4 Answers  

---

How many data types are there in SAS?

0 Answers  

---

what is Global Symbol table and Local symbol table?

4 Answers   CitiGroup,

---

---

Difference between SAS STATA & SPSS?

0 Answers  

---

What are the criticality that you have faced during your project in SAS?

2 Answers  

---

What is the difference between where and if statement?

0 Answers  

---

Which are SAS Windows Clients & SAS Java Clients

3 Answers   TCS,

---

how to rearrange the data as our wish by using dataset block?

4 Answers   Cognizant,

---

what is sas and what are the functions? : Sas-administrator

0 Answers  

---

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

0 Answers  

---