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;

name some data transformation used in sas di? : Sas-di

0 Answers  

---

Hi, I have one dataset, could you please ans for this. id amount paid_amount 1 700 400 2 900 250 3 300 300 a 400 250 b 500 320 c 800 650 x 200 190 y 900 250 z 300 180 i want create new dataset having id and paid_amount who are paid high amount comparing amount. ex: 1d paid_amount 3 300 c 650 x 190

3 Answers  

---

· What are some good SAS programming practices for processing very large data sets?

6 Answers   Quintiles,

---

What are TEAEs

2 Answers   Accenture, Quintiles,

---

describe about joins? briefly?

2 Answers   CitiGroup,

---

name several ways to achieve efficiency in your program? : Sas programming

0 Answers  

---

What are the features of SAS?

0 Answers  

---

Why double trailing @@ is used in input statement?

0 Answers  

---

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

3 Answers  

---

How you can read the variables that you need?

0 Answers  

---

what is the main difference between rename and label? (don't say that they both perform the same function).

11 Answers   Parexel,

---

Can we create datasets by proc step ? (Proc contents, Means)?

2 Answers  

---