Answer / gaurav gupta

SELECT DISTINCT statement in PROC SQL

Answer / xxx

proc sql;
select id where id(select id from tablename)group by id
having id>1;
quit;

Can you execute a macro within a macro? Describe. : sas-macro

0 Answers  

---

what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming

0 Answers  

---

Code a PROC SORT on a data set containing State, District and County as the primary variables, along with several numeric variables?

3 Answers  

---

how can you improve the performance of a query, If it is excuting very slowly?

2 Answers   Zensar,

---

what is the difference between x=substr(name,1,2); and substr(name,1,2)='x';

3 Answers   HSBC,

---

---

What is SAS informats?

0 Answers  

---

1.How to draw pivot tables in Excel by using SAS and in which version we can use VB script for to draw pivot tables in Excel? Answer with example data. 2.What are the advantages of _NULL_ in Data steps? Can we use _NULL_ in Proc steps also? 3. How to call the macro variable into Data Steps? 4. Can we draw pivot tables in Excel using Proc SQL? Please post answers for the above questions with suitable examples, and how to use VB script for Excel using SAS.

1 Answers  

---

What does PROC print, and PROC contents do?

0 Answers  

---

How to get part of string form the source string without using sub string function in SAS?

3 Answers  

---

Briefly describe 5 ways to do a "table lookup" in sas.

4 Answers   Quintiles,

---

what is sas business intelligence? : Sas-bi

0 Answers  

---

name several ways to achieve efficiency in your program? : Sas programming

0 Answers  

---