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;

how would you create multiple observations from a single observation? : Sas programming

0 Answers  

---

Write SAS codes to compare two datasets. Suppose the allowable difference is 0.1.

2 Answers  

---

data task; input id date date9. visit; cards; 101 01jan2015 1 101 02jan2015 2 101 06jan2015 3 102 04jan2015 1 102 07jan2015 2 102 12jan2015 3 103 06jan2015 1 103 13jan2015 2 ; run; write a program to find out missing dates between visits by each subject.

1 Answers  

---

Name and describe few sas character functions that are used for data cleaning in brief.

0 Answers  

---

Describe the ways in which you can create macro variables? : sas-macro

0 Answers  

---

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?

3 Answers  

---

name few built in sas transformation in DI studio ?

4 Answers   SAS,

---

Which are the statements whose placement in the data step is critical?

0 Answers  

---

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

3 Answers  

---

Have you used macros? For what purpose you have used? : sas-macro

0 Answers  

---

i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;

0 Answers   L&T,

---

how to extract data from SAP servers? Is like oracle servers or any other methods to extract please reply me.

1 Answers  

---