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;

define table lookup and how may ways it can be done...explian

3 Answers  

---

what is PhaseIII, ODS, TLG, Macro and Proc in SAS

0 Answers  

---

Explain bmdp procedure?

0 Answers  

---

What are Dashboard reports?And significance of these in analysis?

1 Answers  

---

In which case u go for libname and in which case u go for proc sql pass thru facilit diff?

1 Answers  

---

In the flow of DATA step processing, what is the first action in a typical DATA Step?

6 Answers   Accenture,

---

If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro

0 Answers  

---

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

1 Answers   Pfizer,

---

what is program data vector? : Sas-administrator

0 Answers  

---

What is proc sql pass through facility?

4 Answers   L&T,

---

what is hierarchy flattening? : Sas-di

0 Answers  

---

what is SAS/Access and SAS/Connect?what are the uses?

3 Answers  

---