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;

AE datasets names? how many types?

0 Answers   Accenture,

---

Approximately what date is represented by SAS date value of 730

9 Answers  

---

Have you ever linked SAS code, If so, describe the link and any required statements used to either process the code or the step itself?

4 Answers  

---

how does sas handle missing values in procs? : Sas programming

0 Answers  

---

what is the difference between %put and symbolgen?

6 Answers  

---

---

code the tables statement for a single level frequency?

2 Answers  

---

If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable?

16 Answers  

---

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

0 Answers  

---

Explain the difference between nodup and nodupkey options?

0 Answers  

---

how to remove the duplicates by proc sql?

2 Answers   Genpact,

---

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

7 Answers   Accenture,

---

how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?

0 Answers  

---