What are the ways to do a “table lookup” in sas?

0 Answers  

---

whenever we using the merging through data set merging ,we can get note in log like this "MERGE STATEMENT HAS MORE THAN ONE ONE DATASET BY REPEATED BY VAIABLES" but the output has come in good manner,whenever in in sql(full join) we can get cartion product.so How do overcome this problem in sql?

1 Answers   Accenture,

---

data study; input Subj : $3. Group : $1. Dose : $4. Weight : $8. Subgroup; x= input(Weight,5.1); datalines; 001 A Low 220 2 002 A High 90 1 003 B Low 193.6 1 004 B High 165 2 005 A Low 123.4 1 ; Why does X get truncated? X shows up as 22 instead of 220,9 instead of 90 and 19.8 instead of 198? This problem doesnt happen with the values 193.6 and 123.4. This does not happen if x is read on the 5. informat instead of the 5.1 informat

2 Answers  

---

How do you use the do loop if you don’t know how many times you should execute the do loop?

0 Answers  

---

How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?

0 Answers  

---

---

What are the prime responsibilities of data integration administrator? : Sas-di

0 Answers  

---

how do we get duplicate observations in a separate dataset?

6 Answers   CitiGroup,

---

what is the difference between sas and other datawarehousing languages?what are the advantages of sas over them?

2 Answers   Accenture, Infosys,

---

Which are SAS Windows Clients & SAS Java Clients

3 Answers   TCS,

---

explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di

0 Answers  

---

what is the difference between proc means and proc tabulate?

3 Answers   Cognizant, CTS,

---

What do you know about symput and symget?

0 Answers  

---