Can we use where and having clauses in a single SAS program. ex: proc sql;     select a,b,c from test      where state in 'KA'      and having <some condition>. Is the above program run correctly, if not why ?     

4 Answers   UHG,

---

what is validvarname and varnum? why we are using this options; explain with a syntax for this options?

1 Answers   Max India,

---

how does sas handle missing values in a merge? : Sas programming

0 Answers  

---

what are methods to identify duplicate observations?

5 Answers   HCL,

---

What other SAS features do you use for error trapping and data validation?

2 Answers  

---

Describe crosslist option in tables statement?

0 Answers  

---

if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation

0 Answers   CTS,

---

Describe a time when you were really stuck on a problem and how you solved it?

0 Answers   Oracle,

---

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

1 Answers  

---

You need to perform an analysis on a massive dataset by groups, but are unable to sort the data due to memory constraint. How would you accomplish the task?

2 Answers  

---

What is SAS Information Map Studio and its purpose ?

2 Answers   SAS, TCS,

---

what is SAS OPTIMIZATION?

0 Answers  

---