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 system option ? give few examples ? what are dataset options and dataset statements ? if there is a keep option and keep statement ? which one is executed first ? Difference between a WHERE statement and IF statement ? what is the advantage of using WHERE statement option on the dataset ?

1 Answers   Satyam,

---

What is univariate n where it can be used n how...?

2 Answers  

---

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

4 Answers   Quintiles,

---

what are the advantages of using SAS in clinical data mangement? why should not we use other software products in managing clinical data?

2 Answers   Wockhardt,

---

Can you use a macro within another macro? If so how would SAS know where the current acro ended and the new one began?

1 Answers  

---

Difference between SAS STATA & SPSS?

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,

---

if a program has some 1000 or more line and how to know whether the syntax of the particular code is correct without checking it manually

4 Answers   Accenture,

---

Explain proc sort?

0 Answers  

---

i have multiple .csv files in a unix directory. every file is having variable names as header.even for empty file also. suppose take 3 files a.csv b.csv c.csv a.csv contains data as name;age,salary; raja;34;4000; ravi;33;5000; kumar;25;3000; b.csv contains data as name;age,salary; ajay;40;4500; and c.csv contains name;age,salary; (only headers) Now i want to import and append all these files in to a single dataset. i tried infile statement with *.csv to import all at a time. but i m not getting correct data. please help me . its urgent. thank you in advance

2 Answers   Tech Mahindra,

---

which features do you use to check the data validations and errors? : Sas-administrator

0 Answers  

---