how to delete the duplicate columns permanently in SQL

2 Answers   Satyam,

---

What do the sas log messages “numeric values have been converted to character” mean? What are the implications?

0 Answers  

---

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,

---

Code the MEANS to produce output to be used later.

2 Answers  

---

How would you determine the number of missing or nonmissing values in computations?

0 Answers  

---

How do you test for missing values?

0 Answers   Quintiles,

---

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  

---

DATA ABC; INPUT TDATE DATE9. AVG; CARDS; 18APR2008 150.00 19APR2008 167.00 20APR2008 123.00 21APR2008 145.00 ; RUN HOW CAN I FIND THE DIFFERENCE BETWEEN AVG OF 18APR2008 ANF 21APR2008?? IF ANY ONE GETS IT PLS TRY TO POST IT.

8 Answers   Verinon Technology Solutions,

---

Why is a STOP statement needed for the point=option on a SET statement?

2 Answers   Quintiles,

---

What is SAS Information Map Studio and its purpose ?

2 Answers   SAS, TCS,

---

What is the SAS data set?

0 Answers  

---

Under what circumstances would you code a SELECT construct instead of IF statements?

4 Answers  

---