Answer / Rahul Pratap

1. Using the MISSING function with IF-THEN statements, 2. Using the IN operator, 3. Using the FIND or SCAN functions, 4. Using the LOOKUP function, and 5. Using PROC SQL to perform a join.

What is the pound sign used for in the data_null_ ?

1 Answers  

---

How to sort in descending order?

1 Answers  

---

Describe the function and untility of the most difficult SAS macro that you have written.

1 Answers  

---

I have 50 variables in one data set, In reports i want to generate every 10 variables in one page how we will write code in proc report.

4 Answers  

---

What are the difference between ceil and floor functions in sas?

1 Answers  

---

If you?re not wanting any SAS output from a data step, how would you code the data statement to prevent SAS from producing a set?

1 Answers  

---

What is SAS? is it a software just for use or we can creat something over there?

5 Answers   Cognizant,

---

What are the different types of sas functions?

1 Answers  

---

data abc; input x y ; cards; 1 2 5 6 7 8 7 8 1 7 5 7 ; run; Proc Freq data=abc; tables x*y / chisq nopercent nocol norow PLCORR; RUN; If we run the code, we have Polychoric Correlation = 0.9054 in the last table. I want to extract this particular entry with the value. Means I will create one dataset in which this value will be stored/extracted. I need your help in coding this. Please help me out.

2 Answers  

---

I use NOCUM/NOPERCENT option in the tables statement like this Proc freq data = deepak; tables x y /nocum nopercent; run; Here I get nopercent and nocum in the output only for variables x and y. How do i do it for all variables? Deepak

1 Answers  

---

firstobs and obs are working only option wise,but we are using infile statement with firstobs and obs in a statement wise? so firstobs,obs working at options and statemnts or not?

1 Answers  

---

Why and when do you use proc sql?

1 Answers  

---