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;

Can you excute a macro within a macro? Describe.

2 Answers   Genta,

---

What can you learn from the SAS log when debugging?

0 Answers   Quintiles,

---

Are you familiar with special input delimiters? How are they used?

4 Answers   Accenture,

---

Can we replace a dataset into view?

6 Answers   CliniRx,

---

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

0 Answers   Wipro,

---

Which statement does not perform automatic conversions in comparisons?

0 Answers  

---

what is chi-square test? have you used that?

1 Answers   Accenture, Quintiles,

---

Tell e how how dealt with..

0 Answers  

---

In proc transpose and data step with arrays which one you pick?

0 Answers   Accenture, Quintiles,

---

what is the need of INDEX in datasets?

6 Answers   CitiGroup,

---

Explain the message ‘MERGE HAS ONE OR MORE DATASETS WITH REPEATS OF BY VARIABLE’.

2 Answers  

---

What are the scrubbing procedures in sas?

0 Answers  

---