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 AE onset date and what is RDS?

4 Answers   Accenture,

---

What do you know about symput and symget?

0 Answers  

---

Can we replace a dataset into view?

6 Answers   CliniRx,

---

Name validation tools used in SAS

0 Answers  

---

What is the purpose of using the N=PS option?

2 Answers   Oracle,

---

---

what are input dataset and output dataset options?

6 Answers   HCL,

---

what are several options for creating reports in web report studio? : Sas-bi

0 Answers  

---

Are you involved in writing the inferential analysis plan? Tables specfications?

0 Answers  

---

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

4 Answers   Cognizant,

---

How would you invoke a macro? : sas-macro

0 Answers  

---

Do you need to know if there are any missing values?

0 Answers  

---

how do you want missing values handled? : Sas programming

0 Answers  

---