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;

For what purposes have you used sas macros? : sas-macro

0 Answers  

---

what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming

0 Answers  

---

what do the sas log messages "numeric values have been converted to character" mean? : Sas programming

0 Answers  

---

Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro

0 Answers  

---

what does the run statement do? : Sas programming

0 Answers  

---

What do the put and input function do?

0 Answers  

---

How do you add a number to a macro variable?

3 Answers  

---

In a shcool there are 1000 students. After completion of every test in 6 subjects , each subject teacher submit the marks of every student at different times and loaded in the database commonly. How will you seperate the top two subject marks for each each studet using SAS?

6 Answers  

---

How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?

0 Answers  

---

how can u join the two tables without using proc sql Joins and nested queries ?

6 Answers   IBM,

---

What is the use of stop statement?

0 Answers  

---

How could you generate test data with no input data?

14 Answers   CTS,

---